• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

IBM Universal JDBC driver bug?

 
Giriraj Bhojak
Ranch Hand
Posts: 72
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am using universal driver by IBM in type 4 mode.
By default, java.sql.Connection creates FORWARD_ONLY type of resultset. In DB2, this resultset type is closed on reaching the last record.
This is how i create the connection.
I get exception "result set closed" even when there are more records to be fetched.
When I switch to Type 2 mode, the problem disappears.
But the problem is that I have to use type 4 driver.
If i use the result set as SCROLL_INSENSITIVE in type 4 mode, the result set problem resolves but then I am getting following at other places....
Function not supported (Reason code = "63").. SQLCODE=-270, SQLSTATE=42997, DRIVER=3.52.95
Does this sound familiar to someone?
I have been scratching on this and then i found this: http://forums.pentaho.org/showthread.php?p=177515

I know that I cannot use LOB datatypes for scrollable result sets as per http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw.apdv.java.doc/doc/tjvrsush.html

But I have to use type 4 driver and also need to support LOBs as datatypes.

Someone please help me out with this.

Regards,
Giriraj.


 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Giriraj,
Can you use a non scrollable result set to get around this?
 
Giriraj Bhojak
Ranch Hand
Posts: 72
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Jeanne,

The problem with non scrollable result set in type 4 mode is that it is giving me exception "result set is closed" even when there are more records to be fetched.
And if i use it as scrollable i get error like "Function not supported" (as i mentioned above.)

Regards,
Giriraj.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic