sqlbuilder icon indicating copy to clipboard operation
sqlbuilder copied to clipboard

Support for Statement.RETURN_GENERATED_KEYS on InsertCreator

Open divios opened this issue 2 years ago • 0 comments

        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

divios avatar Dec 16 '22 20:12 divios