Java 7 Automatic Resource Management JDBC (try-with-resources statement)

by 
try(Connection con = getConnection()) {
   try (PreparedStatement prep = con.prepareConnection("Update ...")) {
       //prep.doSomething();
       //...
       //etc
       con.commit();
   } catch (SQLException e) {
       //any other actions necessary on failure
       con.rollback();
       //consider a re-throw, throwing a wrapping exception, etc
   }
}

According to the oracle documentation, you can combine a try-with-resources block with a regular try block. IMO, the above example captures the correct logic, which is:

  • Attempt to close the PreparedStatement if nothing goes wrong
  • If something goes wrong in the inner block, (no matter what is is) roll back the current transaction
  • Attempt to close the connection no matter what
  • If something goes wrong closing the connection, you can’t rollback the transaction (as that’s a method on the connection, which is now in indeterminate state), so don’t try

In java 6 and earlier, I would do this with a triply nested set of try blocks (outer try-finally, middle try-catch, inner try-finally). ARM syntax does make this terser.

More Related Contents:

  1. How should I use try-with-resources with JDBC?
  2. What’s the purpose of try-with-resources statements?
  3. Close resource quietly using try-with-resources
  4. having an exception when saving oracle type object in some entity
  5. PreparedStatement IN clause alternatives?
  6. Recursively list files in Java
  7. How do I get the size of a java.sql.ResultSet?
  8. Must JDBC Resultsets and Statements be closed separately although the Connection is closed afterwards?
  9. What is the best approach using JDBC for parameterizing an IN clause? [duplicate]
  10. Reusing a PreparedStatement multiple times
  11. Java 7 language features with Android
  12. How to set specific Java version to Maven?
  13. Getting Database connection in pure JPA setup
  14. Returning a ResultSet
  15. How to change MySQL timezone in a database connection using Java?
  16. Does the preparedStatement avoid SQL injection? [duplicate]
  17. What is the most recommended way to store time in PostgreSQL using Java?
  18. How to read all rows from huge table?
  19. com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost, port 1433 has failed [duplicate]
  20. dll missing in JDBC
  21. Java, looping through result set
  22. How to connect JDBC to tns oracle
  23. The specified DSN contains an architecture mismatch Error
  24. how to copy data from file to PostgreSQL using JDBC?
  25. Getting the Return Value from JDBC MSSQL
  26. java.security.cert.CertificateException: Certificates does not conform to algorithm constraints
  27. Differences in auto-unboxing between Java 6 vs Java 7
  28. How to use prepared statement for select query in Java?
  29. Does collect operation on Stream close the stream and underlying resources?
  30. Postgres UUID JDBC not working

Leave a Comment