I have the following error:
java.sql.SQLException: ORA-01000: maximum open cursors exceeded
From what I researched, the error happens when the maximum number of cursors is exceeded, and to solve, or you increase the number of cursors or close the connections, closing the connections would be the best option. My application is in java
and used the default of POJO
and DAO
to connect to the oracle database.
My two top questions are:
If I have to close the PreparedStatement
of the include, change, delete, or just query methods (and in the query also close ResultSet
)?
Can I close it like this?:
PreparedStatement ps = ConexaoOracle.getConexao().prepareStatement(SQL_CONSULTAR);
ps.close();