title: Closed Connection Error 17008
body: <p>I am trying to execute a query which takes huge amount of time sometimes which causes closed connection, meaning the connection gets closed before the query executes/commits. I want to recover from the error, get a new connection and then retry.</p>
  
  <pre><code>Caused by: java.sql.SQLRecoverableException: Closed Connection
      at oracle.jdbc.driver.OracleStatement.ensureOpen(OracleStatement.java:4051)
      at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1473)
      at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406)
      at com.fimt.sat.testora12date.dao.DateSaverGetterDao.testAbandonedConnectionWithDS(DateSaverGetterDao.java:73)
  </code></pre>