sqlbuilder
sqlbuilder copied to clipboard
Support for Statement.RETURN_GENERATED_KEYS on InsertCreator
KeyHolder keyHolder = new GeneratedKeyHolder();
PreparedStatementCreator psc = new InsertCreator(SHOP_TABLE)
.setValue("shop_name", shopEntity.getName())
.setValue("created_At", String.valueOf(shopEntity.getCreatedAt()))
.setValue("last_renewal", String.valueOf(shopEntity.getLastRenewal()))
.setValue("max_timer", String.valueOf(shopEntity.getMaxTimer()));
jdbcTemplate.update(psc, keyHolder);
The code returns an exception since I need to specify Statement.RETURN_GENERATED_KEYS