title: Transaction rollback on SQLException using new try-with-resources block
body: <p>I have a problem with try-with-resources and I am asking just to be sure. Can I use it, if I need to react on exception, and I still need the resource in catch block? Example given is this:</p>
  
  <pre><code>try (java.sql.Connection con = createConnection())
  {
      con.setAutoCommit(false);
      Statement stm = con.createStatement();
      stm.execute(someQuery); // causes SQLException
  }
  catch(SQLException ex)
  {
      con.rollback();
      // do other stuff
  }
  </code></pre>
  
  <p>I fear that I am still doomed to use the old try-catch-finally in this case, even according to oracle documentation - "catch and finally blocks in a try-with-resources statement, any catch or finally block is run after the resources declared have been closed."</p>