title: Does closing Connection automatically close statement and resultset?
body: <p>I know the safe pattern in Java is to close your ResultSet, Statement, and Connection in order in a finally block. </p>
  
  <p>If you close connection and then try to close statement(doesnt throw exception). But if you try to call any method from statement an exception is thrown. </p>
  
  <p>I was wondering does closing connection automatically close all the statement objects created out of that connection?</p>
  
  <p>Update:<br>
  I am using DatabaseProductVersion: Oracle Database 11g Release 11.1.0.0.0<br>
  DriverName: Oracle JDBC driver<br>
  DriverVersion: 10.2.0.4.0</p>