Problem connecting to db2 through java in WDSC

Problem connecting to db2 through java in WDSC

Post by savit » Fri, 29 Dec 2006 20:57:07


Hello ,

I want to connect to IBM db2400 of AS400 through java in websphere.
The code I have written is follows


package com.jdbc;


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class Dbjdbc
{
public Dbjdbc()
{


}
public static void main(String args[])
{
try
{


Class.forName("com.ibm.db2.jcc.DB2Driver");
}
catch (ClassNotFoundException e)
{
System.err.println("Could not load DB2 driver \n");
System.err.println(e.getMessage());


}


try
{
//Connect to a database
Connection conn = DriverManager.getConnection
("jdbc:db2:192.168.0.10","SAVITA","SAVITA");


}
catch (SQLException e)
{
System.out.println("SQL Exception: ");
}
}



}


I am getting compile error as follows:-

------------------------------------------------------------------------------------------------------------------------------------



Could not load DB2 driver


com.ibm.db2.jcc.DB2Driver
SQL Exception:
-------------------------------------------------------------------------------------------------------------------------------------



Does it mean I have to install the DB2 Universal JDBC Driver
com.ibm.db2.jcc.DB2Driver
If yes? Please let me know the step to be followed.How to do ?


Thanks
Regards
Savita
 
 
 

Problem connecting to db2 through java in WDSC

Post by Arne Vaj » Sat, 30 Dec 2006 10:31:14


No - you are getting a runtime error.



You need to put the jar file(s) with the DB2 JDBC driver in
your classpath.

db2jcc.jar and db2jcc_license_something.jar

Arne