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?