how to get sequence generated ids from batch insert for spring JdbcTemplate

Asked Jun 14 '13 at 04:24

Active Jun 14 '13 at 04:24

Viewed 4,985 times

If I have a batch of rows to insert where each row gets a sequence generated id, how can I get those ids (or at least the last one) back when using JdbcTemplate?

E.g., for a single row, I know I use, among other ways

jdbcTemplate.update(PreparedStatementCreator, KeyHolder);

But there seems to be no correlating batchUpdate method with a KeyHolder parameter.

asked Jun 14 '13 at 04:24

ticktock

1,593
3
16
38

1

Check this: http://stackoverflow.com/questions/2423815/is-there-anyway-to-get-the-generated-keys-when-using-spring-jdbc-batchupdate – Snehal Patel Jun 14 '13 at 06:24
Thanks.. essentially, you can't. fiddle. – ticktock Jun 14 '13 at 20:01

how to get sequence generated ids from batch insert for spring JdbcTemplate

0 Answers0