how to get the primary key after an insert h2

Solutions on MaxInterview for how to get the primary key after an insert h2 by the best coders in the world

home

app

help

profile

we are a community of more than 2 million smartest coders

registration for

employee referral programs

are now open

get referred to google, amazon, flipkart and more

showing results for - "how to get the primary key after an insert h2"

Leonardo

25 Oct 2016

1// here you can specify the list of returned attributes, in your case just the data
2String[] returnedAttributes = {"data"};
3String insertQuery = "insert into test(id) values(1);";
4try 
5(
6    PreparedStatement insertStatement = conn.prepareStatement(insertQuery, returnedAttributes);
7) 
8{
9    int rows = insertStatement.executeUpdate();
10    if (rows == 0) 
11    {
12        throw new SQLException("Failed of insertion");
13    }
14    try (ResultSet rs = insertStatement.getGeneratedKeys()) {
15        if (rs.next()) 
16        {
17             java.util.UUID uuid = (java.util.UUID) rs.getObject("data");
18             System.out.println(uuid);
19        }
20    }
21}

source

similar questions

create table with primary key alter table add key sql server add primary key to existing table sql what is primary key get primary key of table add primary key to table mysql set last insert id primary key start from number mysql set primary key how to add a new column 2ffield to an existing composite primary key sql server add primary key to existing table with data get last inserted primary key create sql table from script inline primary key constraint h2 auto increment and unique sql create tabel with primary key auto increment code primary key add primary key to database sql sql change primary key to composite key primary key multiple

queries leading to this page

h2 syntax h2 update table h2 database create table bool default value h2 create table h2 sql syntax how to make a field primary key in h2 database h2 sequence h2 table column index starts from insert without primary key max length of table name h2 create table query for h2 database h2 change column order create table sql h2 default index h2 h2 database foreign key constraint name h2 select schema name how to get the primary key after an insert h2