Problem connecting to db2 through java in WDSC

S

savita

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
 
?

=?ISO-8859-1?Q?Arne_Vajh=F8j?=

savita said:
I want to connect to IBM db2400 of AS400 through java in websphere.
The code I have written is follows
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:-

No - you are getting a runtime error.
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 ?

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

db2jcc.jar and db2jcc_license_something.jar

Arne
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,989
Messages
2,570,207
Members
46,782
Latest member
ThomasGex

Latest Threads

Top