On WebLogic Linux server I'm running a servlet and trying to connect to db2. I get the following error: 'No suitable driver '

Here is the code that I use to connect:

try {
String driver = "COM.ibm.db2.jdbc.app.DB2Driver";
Class.forName(driver);

}catch(Exception e){
throw(new UnavailableException(this, "Sorry! The Database didn't load!"));}

try {
String url = "jdbc:db2:" + LOGID_DATA_SOURCE;
con = DriverManager.getConnection (url,LOGID_USER,LOGID_PASSWORD);
stStatement = con.createStatement();
}catch (SQLException e) {
out.println("SQL Exception: " + e.getMessage() + "\n");
}


I also set up following environment variables:
export CP_CLASSPATH=/home/db2clnt7/sqllib/java/sqlj.zip:/home/db2clnt7/sqllib/java/db2java.zip:/home/db2clnt7/sqllib/java/runtime.zip
export CP_LD_LIBRARY_PATH=/home/db2clnt7/sqllib/lib
export CP_PATH=/home/db2clnt7/sqllib/bin:/home/db2clnt7/sqllib/adm:/home/db2clnt7/sqllib/misc

Can you please advise what am I doing wrong? And why am I getting 'No suitable driver found error"

Thanks in advance

Try using NET driver (COM.ibm.db2.jdbc.net.DB2Driver) instead of the APP driver.

That didn't help.

Thanks!

Well, the error you get can only mean two things: either the driver didn't load properly or it can't handle the url you're trying to pass to it. Check the url syntax and ensure that the driver loads (no security violation etc.). See if WebLogic log files contain any useful information.

As a side note, I think you would want to use WebLogic's JDBC connection pool instead of establishing your own connections from a servlet...