MySQL Java - Get id of the last inserted value JDBC

Question

Possible Duplicate    How to get the insert ID in JDBC        Hi  I m using JDBC to connect on database through out Java    Now  I do some insert query  and I need to get the id of last inserted value  so  after a stmt executeUpdate    I don t need something like SELECT id FROM table ORDER BY id DESC LIMIT 1  because I may have concurrency problems    I Just need to retrieve the id associated to the last insertion  about my instance of the Statement    I tried this  but seems it doesn t work on JDBC    public Integer insertQueryGetId String query        Integer numero 0      Integer risultato -1      try           Statement stmt   db createStatement            numero   stmt executeUpdate query            ResultSet rs   stmt getGeneratedKeys            if  rs next                 risultato rs getInt 1                     rs close             stmt close          catch  Exception e            e printStackTrace            errore   e getMessage            risultato -1          return risultato      In fact  every time risultato   -1  and I get java sql SQLException  Generated keys not requested  You need to specify Statement RETURN GENERATED KEYS to Statement executeUpdate   or Connection prepareStatement     How can I fix this problem  Thanks Stackoverflow People

User · Answer

Alternatively you can do   Statement stmt   db prepareStatement query  Statement RETURN GENERATED KEYS   numero   stmt executeUpdate     ResultSet rs   stmt getGeneratedKeys    if  rs next         risultato rs getString 1       But use Sean Bright s answer instead for your scenario

User · Answer

Wouldn t you just change   numero   stmt executeUpdate query     to   numero   stmt executeUpdate query  Statement RETURN GENERATED KEYS     Take a look at the documentation for the JDBC Statement interface   Update  Apparently there is a lot of confusion about this answer  but my guess is that the people that are confused are not reading it in the context of the question that was asked  If you take the code that the OP provided in his question and replace the single line  line 6  that I am suggesting  everything will work  The numero variable is completely irrelevant and its value is never read after it is set

[java] MySQL & Java - Get id of the last inserted value (JDBC)

Examples related to java

Examples related to mysql

Examples related to jdbc