Problem in using DB2 Type 4 driver

[Neeraj]

Hii ,

We have DB2 7.1 on windows and we are trying to use a type 4 driver to
connect to the data base .
I have included the db2jcc.jar in the class path .
I am able to create a connection to the data base and also run SQLs
with normal result set objects and get results
but the momment I try to create a Scrollable result set as follows
Statement Stat = connect.createStatement(ResultSet.TYPE_SCROLL_INSE NSITIVE,ResultSet.CONCUR_READ_ONLY);

I get a runtime error when executing the class . the data base
connection is established succesfully as is evident by the logs
Following is the Stack Trace

DB2 connection succesful !!!!!!
com.ibm.db2.jcc.b.SQLException: This method should only be called on
ResultSet objects that are scrollable(type TYPE_SCROLL_SENSITIVE or
TYPE_SCROLL_INSENSITIVE)
at com.ibm.db2.jcc.b.ca.U(ca.java:2669)
at com.ibm.db2.jcc.b.ca.last(ca.java:1348)
at test.main(test.java:28)

Following is the test code extract
connect = DriverManager.getConnection(url, userid, passwd);
if(connect !=null)
{
System.out.println("DB2 connection succesful !!!!!!");
}

String queryStr = "select NAME,CITY from CLIENT_DET";
Statement Stat = connect.createStatement(ResultSet.TYPE_SCROLL_INSE NSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs = Stat.executeQuery(queryStr);
ResultSetMetaData rsmd = rs.getMetaData();

rs.last();
rs.beforeFirst();
System.out.println("getColumncount is
........"+rsmd.getColumnName(1));
while(rs.next())
{
System.out.println("NAME Code is ......."+rs.getString(1));
System.out.println("CITY Code is ......."+rs.getString(2));
}
connect.close();

Has anyone faced the same problem earlier , kindly help .

Regards,
-Neeraj

[Christos Kalantzis]

Unless this changed in the absolute last FixPak for 7.x, Scrollable
result sets are not supported in the DB2 7.x JDBC driver.

The 8.2 JDBC driver does support it though.

Christos Kalantzis

Neeraj wrote:

Hii ,

We have DB2 7.1 on windows and we are trying to use a type 4 driver to
connect to the data base .
I have included the db2jcc.jar in the class path .
I am able to create a connection to the data base and also run SQLs
with normal result set objects and get results
but the momment I try to create a Scrollable result set as follows
Statement Stat = connect.createStatement(ResultSet.TYPE_SCROLL_INSE NSITIVE,ResultSet.CONCUR_READ_ONLY);

I get a runtime error when executing the class . the data base
connection is established succesfully as is evident by the logs
Following is the Stack Trace

DB2 connection succesful !!!!!!
com.ibm.db2.jcc.b.SQLException: This method should only be called on
ResultSet objects that are scrollable(type TYPE_SCROLL_SENSITIVE or
TYPE_SCROLL_INSENSITIVE)
at com.ibm.db2.jcc.b.ca.U(ca.java:2669)
at com.ibm.db2.jcc.b.ca.last(ca.java:1348)
at test.main(test.java:28)

Following is the test code extract
connect = DriverManager.getConnection(url, userid, passwd);
if(connect !=null)
{
System.out.println("DB2 connection succesful !!!!!!");
}

String queryStr = "select NAME,CITY from CLIENT_DET";
Statement Stat = connect.createStatement(ResultSet.TYPE_SCROLL_INSE NSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs = Stat.executeQuery(queryStr);
ResultSetMetaData rsmd = rs.getMetaData();

rs.last();
rs.beforeFirst();
System.out.println("getColumncount is
......."+rsmd.getColumnName(1));
while(rs.next())
{
System.out.println("NAME Code is ......."+rs.getString(1));
System.out.println("CITY Code is ......."+rs.getString(2));
}
connect.close();

Has anyone faced the same problem earlier , kindly help .

Regards,
-Neeraj

[Neeraj]

hii ,
thanks for the help .. This doesnt looks like the problem as we have
picked the db2jcc.jar from the DB2 V8.1 installtion and hence it
should support scrollable result sets, also when I decompiled the
classes in the driver I could see that the constructor to pass the
parameters to make a result set scrollable is implemented there in .
Christos Kalantzis <ch*******@intertrade.com> wrote in message news:<41**************@intertrade.com>...

Unless this changed in the absolute last FixPak for 7.x, Scrollable
result sets are not supported in the DB2 7.x JDBC driver.

The 8.2 JDBC driver does support it though.

Christos Kalantzis

Neeraj wrote:

Hii ,

We have DB2 7.1 on windows and we are trying to use a type 4 driver to
connect to the data base .
I have included the db2jcc.jar in the class path .
I am able to create a connection to the data base and also run SQLs
with normal result set objects and get results
but the momment I try to create a Scrollable result set as follows
Statement Stat = connect.createStatement(ResultSet.TYPE_SCROLL_INSE NSITIVE,ResultSet.CONCUR_READ_ONLY);

I get a runtime error when executing the class . the data base
connection is established succesfully as is evident by the logs
Following is the Stack Trace

DB2 connection succesful !!!!!!
com.ibm.db2.jcc.b.SQLException: This method should only be called on
ResultSet objects that are scrollable(type TYPE_SCROLL_SENSITIVE or
TYPE_SCROLL_INSENSITIVE)
at com.ibm.db2.jcc.b.ca.U(ca.java:2669)
at com.ibm.db2.jcc.b.ca.last(ca.java:1348)
at test.main(test.java:28)

Following is the test code extract
connect = DriverManager.getConnection(url, userid, passwd);
if(connect !=null)
{
System.out.println("DB2 connection succesful !!!!!!");
}

String queryStr = "select NAME,CITY from CLIENT_DET";
Statement Stat = connect.createStatement(ResultSet.TYPE_SCROLL_INSE NSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs = Stat.executeQuery(queryStr);
ResultSetMetaData rsmd = rs.getMetaData();

rs.last();
rs.beforeFirst();
System.out.println("getColumncount is
......."+rsmd.getColumnName(1));
while(rs.next())
{
System.out.println("NAME Code is ......."+rs.getString(1));
System.out.println("CITY Code is ......."+rs.getString(2));
}
connect.close();

Has anyone faced the same problem earlier , kindly help .

Regards,
-Neeraj