PreparedStatement with Statement.RETURN_GENERATED_KEYS

by

You can either use the prepareStatement method taking an additional int parameter

PreparedStatement ps = con.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS)

For some JDBC drivers (for example, Oracle) you have to explicitly list the column names or indices of the generated keys:

PreparedStatement ps = con.prepareStatement(sql, new String[]{"USER_ID"})

More Related Contents:

  1. having an exception when saving oracle type object in some entity
  2. PreparedStatement IN clause alternatives?
  3. How do I get the size of a java.sql.ResultSet?
  4. Must JDBC Resultsets and Statements be closed separately although the Connection is closed afterwards?
  5. What is the best approach using JDBC for parameterizing an IN clause? [duplicate]
  6. Reusing a PreparedStatement multiple times
  7. MySQL and JDBC with rewriteBatchedStatements=true
  8. How to connect SQLite with Java?
  9. “Loading class com.mysql.jdbc.Driver … is deprecated” message
  10. Getting Database connection in pure JPA setup
  11. Returning a ResultSet
  12. How to change MySQL timezone in a database connection using Java?
  13. How to configure Tomcat to connect with MySQL
  14. Does the preparedStatement avoid SQL injection? [duplicate]
  15. What is the most recommended way to store time in PostgreSQL using Java?
  16. Native Library sqljdbc_auth.dll already loaded in another classloader
  17. ResultSet: Retrieving column values by index versus retrieving by label
  18. com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost, port 1433 has failed [duplicate]
  19. dll missing in JDBC
  20. Java, looping through result set
  21. How to connect JDBC to tns oracle
  22. The specified DSN contains an architecture mismatch Error
  23. How to pass Table-Valued parameters from java to sql server stored procedure?
  24. Date columns in SQL-Server (MSSQL-JDBC 3.0) running under Java 1.7.0 retrieved as 2 days in the past
  25. How to use prepared statement for select query in Java?
  26. Oracle JDBC : invalid username/password (ora-01017)
  27. Why do we use a DataSource instead of a DriverManager?
  28. Do I need to close ‘PreparedStatement’? [closed]
  29. Database independence through JDBC in java
  30. java.sql.SQLException: No database selected – why?

Leave a Comment