java jdbc 批量更新_java – JDBC PreparedStatement,批量更新和生成的密钥

我在批处理中使用jdbc preparedStatement并尝试获取由此创建的生成密钥时出现问题.

代码 ：

PreparedStatement stmt = null;

...

connection.setAutoCommit(false);

stmt = connection.prepareStatement(insertSuspiciousElement,new String[] {"external_id","element_id"});

final int elementBatchSize = 5000;

int elementCount =0;

for(BlSuspiciousElement element : elements){

externalIds.add(element.getExternalId());

stmt.setInt(1, element.getBlElementType().getElementTypeId());

stmt.setString(2, element.getFirstname());

stmt.addBatch();

elementCount++;

if(elementCount % elementBatchSize == 0){

System.out.println("Running query with batch size for suspiciousElement");

stmt.executeBatch();

ResultSet keys = stmt.getGeneratedKeys();

while(keys.next()){

externalIdElementIdMapping.put(keys.getInt("external_id"),keys.getInt("element_id"));

}

keys.close();

stmt.clearBatch();

stmt.clearParameters();

stmt.clearWarnings();

System.out.println("Done query with batch size for suspiciousElement");

}

}

它在第一个stmt.executeBatch()方法失败.

错误 ：

[30/01/12 15:54:41:684 CET] 00000029 RemoteExcepti E CNTR0020E: EJB threw an unexpected (non-declared) exception during invocation of method "processFullFeedForPepAndRelationUpdateOnly" on bean "BeanId(CoRelateEar#AmlKycToolBO.jar#FactivaDBUpdater, null)". Exception data: java.lang.ArrayIndexOutOfBoundsException

at oracle.jdbc.driver.T4CNumberAccessor.unmarshalOneRow(T4CNumberAccessor.java:201)

at oracle.jdbc.driver.T4C8Oall.readRXD(T4C8Oall.java:696)

at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:340)

at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)

at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)

at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)

at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1044)

at oracle.jdbc.driver.OraclePreparedStatement.executeForRowsWithTimeout(OraclePreparedStatement.java:10143)

at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10249)

at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:230)

at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.executeBatch(WSJdbcStatement.java:748)

对我来说不是很明显……

它似乎不适用于批量更新？仅用于声明或准备好的声明.在这种情况下,我想我最好尝试进行我的批量插入,然后运行另一个查询来查找每个创建的元素生成的键…

谢谢你的帮助,

F