Ch3: JdbcTacoRepository.saveTacoInfo: keyHolder.getKey() returns null

[glebocki]

spring-in-action-5-samples/ch03/tacos-jdbc/src/main/java/tacos/data/JdbcTacoRepository.java

Line 38 in ff98b2e

private long saveTacoInfo(Taco taco) {

Following an answer to question on StackOverflow.

JdbcTacoRepository is missing a crucial peace: preparedStatementCreatorFactory.setReturnGeneratedKeys(true);

This is a working method:

private long saveTacoInfo(Taco taco) {
    taco.setCreatedAt(new Date());
    var pscf = new PreparedStatementCreatorFactory(
        "insert into Taco (name, createdAt) values (?, ?)",
        Types.VARCHAR, Types.TIMESTAMP);
    pscf.setReturnGeneratedKeys(true);
    PreparedStatementCreator psc = pscf.newPreparedStatementCreator(
        Arrays.asList(
            taco.getName(),
            new Timestamp(taco.getCreatedAt().getTime())));


    KeyHolder keyHolder = new GeneratedKeyHolder();
    jdbc.update(psc, keyHolder);

    return keyHolder.getKey().longValue();
}

[hbliyafei]

<properties>
    <!-- H2 1.4.197 breaks auto-incrementing identity columns for some reason -->
    <h2.version>1.4.196</h2.version>
</properties>