Spring JDBC - Last inserted id

Question

I'm using Spring JDBC. Is a simple way to get last inserted ID using Spring Framework or i need to use some JDBC tricks ?

jdbcTemplate.update("insert into test (name) values(?)", params, types);
// last inserted id ...

I found something like below, but i get: org.postgresql.util.PSQLException: Returning autogenerated keys is not supported.

KeyHolder keyHolder = new GeneratedKeyHolder();
jdbcTemplate.update(new PreparedStatementCreator() {

    @Override
    public PreparedStatement createPreparedStatement(
            Connection connection) throws SQLException {
        PreparedStatement ps = connection.prepareStatement("insert into test (name) values(?)", new String[] {"id"});
        ps.setString(1, "test");
        return ps;
    }

}, keyHolder);
lastId = (Long) keyHolder.getKey();

score 3 · Accepted Answer · answered Apr 18 '11 at 14:58

3

The old/standard way is to use call currval() after the insert (ref). Simple and secure.

answered Apr 18 '11 at 14:58

leonbloy

73,180
20
142
190

Thanks. I did it this way: `jdbcTemplate.queryForLong("select currval('main_seq')");` – marioosh Apr 19 '11 at 06:39

score 1 · Answer 2 · answered Apr 18 '11 at 14:48

1

Support for "generated keys for PreparedStatements" started only since PostgreSql Ver 8.4-701.

answered Apr 18 '11 at 14:48

sojin

4,527
2
37
40

Spring JDBC - Last inserted id

2 Answers2

Linked