oracle out of bounds,如何通过不具有ArrayIndexOutOfBoundsException的executeBatch获取生成的键？...

下面的方法我想同时插入几条记录。

public void insert() {

try {

this.connection.setAutoCommit(false);

PreparedStatement ps = this.connection.prepareStatement(

"INSERT INTO COMPANY (NAME,Address) Values (?,?)", new String[]{"ID"});

ps.setString(1, "X01");

ps.setString(2, "Address1");

ps.addBatch();

ps.setString(1, "Y01");

ps.setString(2, "Address2");

ps.addBatch();

//EXCEPTION OCCURS HERE

int[] numUpdates = ps.executeBatch();

for (int i = 0; i < numUpdates.length; i++) {

System.out.println("Execution " + i +

"successful: " + numUpdates[i] + " rows inserted");

}

ResultSet resultSet =

(ps).getGeneratedKeys();

while (resultSet.next()) {

String deptNoKey = resultSet.getString(1);

System.out.println("Automatically generated key value = "

+ deptNoKey);

}

} catch (BatchUpdateException b) {

// process BatchUpdateException

} catch (SQLException e) {

e.printStackTrace();

}

}

在这一点上，当我希望获得为每个INSERT生成的PK时，就会收到此异常

Exception in thread "main" java.lang.ArrayIndexOutOfBoundsException: 22

at

oracle.jdbc.driver.T4CNumberAccessor.unmarshalOneRow(T4CNumberAccessor.java:250)

at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:754)

at

oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)

at

oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1250)

at

oracle.jdbc.driver.OraclePreparedStatement.executeForRowsWithTimeout(OraclePreparedStatement.java:14264)

at

oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:14379)

at

oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:589)

at dbpro.SqlHelper.insert2(SqlHelper.java:988)

at dbpro.SqlHelper.main(SqlHelper.java:1023)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at

sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at

sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:483)

at

com.intellij.rt.execution.application.AppMain.main(AppMain.java:134)

例外之后：在表COMPANY中，正确添加了两条记录，但是我希望对每个执行的插入操作都获得一个ResultSet一行，因此我可以生成每个PK。