Database shutdown question

khalim

Connection con = DriverManager.getConnection (url, "123", "123");
       Statement stmt = con.createStatement ();
       ResultSet rs = stmt.executeQuery (sql);
       Suppose there is a long code (20 lines)
       Suppose that the code in these 20 lines reports a SQLException or other end
       rs.close
       stmt.close
       con.close
       The above three sentences will not be executed, and the connection cannot be closed
      

       How can I close all connections to the database and the method still throws an exception upwards?
       This method throws SQLException
       Try catch words! too big! !!

lancelot0229

Closing timing can be wrong

khalim

That's wrong! There must be closed

seakey

try {
      tx = session.beginTransaction ();
          } catch (Exception ex) {
      throw SQLException;}
    finally {
         rs.close;
       stmt.close;
       con.close;

    }

ank11111

try {
// Make DB Connection
// Do whatever you need
}
catch (SQLException e) {
// Do Exception handling
// throw e; // if you have to.
}
finally {
  if (DBConnection is still open)
    Close it.
  // Release all necessary resources.
}

hannah2222

Upstairs positive solution, get a finally, he doesn't want to close