«

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

savita wrote:
> 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