| Author |
DB2 - JDBC2.0 Batch update
|
sram bahl
Greenhorn
Joined: Nov 26, 2002
Posts: 13
|
|
With DB2 JDBC2.0 drivers i am trying to do some batch updates. My prep stmt for an update works, but a prep stmt for a delete operation throws a runtime Exception like this, Uncaught Exception (java.lang.UnSatisfiedLindError) DB2PreparedStatement:SQLBindIntArray(int,int,...) code: String query = "delete from user where userkey= ?"; PreparedStatement pstmt = (PreparedStatement) qm.getPrepStatement(query); qm.getConnection().setAutoCommit(false); for (int i = 0; i < keyList.size(); i++) { pstmt.setInt(1, (Integer.parseInt(keyList.get(i).toString()))); pstmt.addBatch(); } // throws exception here... int[] updatecnt = pstmt.executeBatch(); Any clues?
|
 |
sram bahl
Greenhorn
Joined: Nov 26, 2002
Posts: 13
|
|
|
I figured out...seems the "inuse" file is erroneously updated to indicate that jdbc 2.0 is being used. I stopped all db2 processes and services and rerun the usejdbc2.bat command. It works now.
|
 |
 |
|
|
subject: DB2 - JDBC2.0 Batch update
|
|
|