MQSeries.net :: View topic - REG: Connecting to a DB2 Database using Java Application

ppraveen33 · Posted: Fri Jan 17, 2014 7:19 am Post subject:

HI
I am developing a java application to connect to DB2 database. I am getting Class Not Found EXCEPTION. So can any one guide me on this.
I have added db2jcc.jar to my application

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.io.IOException;

public class TestDB {

/**
* @param args
*
*
*/
/* static{
try {
//Class.forName("COM.ibm.db2.jdbc.app.DB2Driver");
Class.forName("COM.ibm.db2.jcc.DB2Driver");

} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}*/

public static void main(String[] args) {

// TODO Auto-generated method stub
String dataSource="DSNV",userName="db2admin" , passWord = "db2admin";

try {
Class.forName("com.ibm.db2.jdbc.app.DB2Driver");
//COM.ibm.db2.jdbc.app.DB2Driver
Connection con = DriverManager.getConnection("jdbc:db2:"+dataSource,userName,passWord);

System.out.println("Connection :"+ con);

}
catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}

}