Breaking News: Grepper is joining You.com. Read the official announcement!

how to get the primary key after an insert h2

Velvet Thunder answered on September 19, 2020 Popularity 4/10 Helpfulness 1/10

answer how to get the primary key after an insert h2

how to get the primary key after an insert h2

Comment

// here you can specify the list of returned attributes, in your case just the data
String[] returnedAttributes = {"data"};
String insertQuery = "insert into test(id) values(1);";
try 
(
    PreparedStatement insertStatement = conn.prepareStatement(insertQuery, returnedAttributes);
) 
{
    int rows = insertStatement.executeUpdate();
    if (rows == 0) 
    {
        throw new SQLException("Failed of insertion");
    }
    try (ResultSet rs = insertStatement.getGeneratedKeys()) {
        if (rs.next()) 
        {
             java.util.UUID uuid = (java.util.UUID) rs.getObject("data");
             System.out.println(uuid);
        }
    }
}

Popularity 4/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: get h2 insert primary-key sql

Link to this answer
Share Copy Link