Not able to execute a callable statement which has CURSOR as out parameter with JDBC 5.1...

[rajain@informatica.com]

By Using the Data Direct DB2 JDBC driver, we are not able to execute a callable statement which has CURSOR as out parameter. Problem is that this is big limitation and we are not able to use the driver where customers are using cursors in their store procedures. This is supported by ibm jdbc driver. To add some more details. Java.sql.types does not have a type Cursor. IBM jdbc driver support this , they have defined their own data type to handle cursor as out parameter (com.ibm.db2.jcc.DB2Types.DB2Types.CURSOR) In data direct driver we could not find what type we need to use to register “cursor” as out parameter. The details about this issue can be found in case Case 00303563.

Continue reading...