Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

can any one help me how to solve th problem with jdbc driver for DB2

 
Arun Asoorya
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Statement stmt= con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);

i want to open a result set in update mode...
i am getting sql exception that websphere dont support.
can any body tell me how to use resultset in update mode.

java.sql.SQLException: [IBM][JDBC Driver] CLI0626E Updatable result set is not supported in this version of DB2 JDBC 2.0 driver

--------------------
And how to get jdbc drivers for DB2 which supports the updatable result sets.
[ January 20, 2007: Message edited by: Arun Asoorya ]
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34178
340
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Arun,
Welcome to JavaRanch!

db2 started supporting updatable resultsets in version 8. You can point to the db2java.zip file that came with your db2 8.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic