Is there anyway to get the generated keys when using Spring JDBC batchUpdate?

Question

I am using JDBC and want to batch insert, but I need the generated keys for the next round of inserts - is there anyway to accomplish this?

MapSqlParameterSource[] batchArgs ....

DAL.getNamedParameterTemplate().batchUpdate("INSERT INTO...", batchArgs);

Thanks

Answer 1

Use db sequences to grab the next primary key value and use it in the insert statement.