JDBC connection to Progress through a Servlet

[siren]

By using JDBC driver, I am trying to connect to a Progress91b db through a class and a servlet. The commands that the class and servlet are using while connecting to the db are the same:

...

String driver = "com.progress.sql.jdbc.JdbcProgressDriver";
String URL = "jdbc:jdbcprogress:T:localhost:10500:rac";
String username = "dba1";
String password = "dba1";

Connection con = null;
DatabaseMetaData dmd = null;
ResultSet rs = null;

try
{
Class.forName( driver );
con = DriverManager.getConnection( URL, username, password );

.....



I can easily connect to the db and see the results of a query through a class. However, I cannot do the same things by a servlet and I come across such an error:
"java.lang.ClassNotFoundException: com.progress.sql.jdbc.JdbcProgressDriver"

In short, when I try to connect to the db by a servlet it cannot find the JDBC driver. What shall I do?

 

[vinko]

I would suggest you to go to Progress Knowledge Base at

http://www.progress.com/services/support/cgi-bin/techweb-kbase.cgi/webkb.p

and search for "java.lang.ClassNotFoundException".
You probably need to change your CLASSPATH.
Cheers,
Vinko.