How to get generated keys with regular dbutils?

Question

I don't understand how to get automatically generated keys with commons-dbutils?

Answer 1

You can use QueryRunner#insert() . The following is an example. For a table called users that has an auto-generated primary key column and a varchar column called username , you can do something like this:

 DataSource dataSource = ... // however your app normally gets a DataSource QueryRunner queryRunner = new QueryRunner(dataSource); String sql = "insert into users (username) values (?)"; long userId = queryRunner.insert(sql, new ScalarHandler<Long>(), "test"); 

Answer 2

In fact, I think this is not possible with the current version of common-dbutils. A few months ago, when I worked for another company, I expanded QueryRunner with my own implementation.

The request was sent to the DbUtils project, and there you can even find a viable implementation that I think you could copy if you really need it.

https://issues.apache.org/jira/browse/DBUTILS-54