Problem with DB2 connectivity using Java

[getthatthing123098]

Hello Everybody,

dis is Abhinav. I'm facing 2 errors:

1. In my DBBrowser in MyEclipse my Driver ClassName is "com.ibm.db2.jcc.DB2Driver" instead of "com.ibm.db2.jdbc.app.DB2Driver". The connection is established but will it work properly and if no then how should i configure it.

2. when making a class DB2Connection for connection i m getting an error in this line--

results = connection.query(Select * from <TABLE_NAME> where <CONDITION>);

although i've given right table name. The error is

"the method query(String) is undefined for the type DB2Connection"

any help from u would benefit me a lot
waiting for ur rply...
tia,
Abhinav

[docdiesel]

Hi,

first, the jcc driver is type 4 jdbc driver which connects directly to the database server. This should work fine if the type 4 server port has been started on the remote side. (See also Wikipedia:Java Database Connectivity.)

The app driver is expecting a locally installed db2 driver which then is doing the TCP/IP connection to the server (DRDA access).

Second, after initially creating a connection, prepare a statement before executing any statement. In some manner like this:

try 
{    
  statement = connection.createStatement(...);
 
  resultset = statement.executeQuery( "Select field1, field2 from ... where ..." ); 
}
catch (Exception myexpt)
{
  System.out.println("The query failed.");
  myexpt.printStackTrace();
}

Regards, Bernd

[docdiesel]

... oh, and, I reformatted your post a little bit, e.g. gave it code tags for better readability and changed the title to make the subject more clear.

Regards, Bernd