<div>
This took me a while as the link only shows part of ther answer. &nbsp;The Insert must be done with executeUpdate and the second parameter:<br />
<br />
stmt.executeUpdate(&quot;INSERT<wbr /> INTO xx(Name) VALUES ('Joe')&quot;, Statement.RETURN_GENERATED<wbr />_KEYS);<br />
<br />
ResultSet rs = stmt.getGeneratedKeys(); <br />
if (rs.next()) { <br />
&nbsp; &nbsp; &nbsp; int autoKey = rs.getInt(1); }<br />
<br />
Thanks
</div>


This took me a while as the link only shows part of ther answer.  The Insert must be done with executeUpdate and the second parameter:

stmt.executeUpdate("INSERT INTO xx(Name) VALUES ('Joe')", Statement.RETURN_GENERATED_KEYS);

ResultSet rs = stmt.getGeneratedKeys();
if (rs.next()) {
      int autoKey = rs.getInt(1); }

Thanks

<div>
<div class="content wysiwyg-content">
I have a table in a Derby database with a column created:<br />
<br />
Id int GENERATED ALWAYS AS IDENTITY &nbsp;CONSTRAINT &nbsp;PK PRIMARY &nbsp;KEY<br />
<br />
How do I get the id of the last record inserted? &nbsp;I think I need IDENTITY_VAL_LOCAL, but how do I call it from code?
</div>
</div>


I have a table in a Derby database with a column created:

Id int GENERATED ALWAYS AS IDENTITY  CONSTRAINT  PK PRIMARY  KEY

How do I get the id of the last record inserted?  I think I need IDENTITY_VAL_LOCAL, but how do I call it from code?

Get last ID after identity insert in Derby DB

Java is a platform-independent, object-oriented programming language and run-time environment, designed to have as few implementation dependencies as possible such that developers can write one set of code across all platforms using libraries. Most devices will not run Java natively, and require a run-time component to be installed in order to execute a Java program.