Problem with closing cursors in web application.
Posted on 2006-04-09
I have developed a web application with lots of database interraction. I use a javax.sql.DataSource, which I declare in my server.xml
As webserver I use tomcat 5.5. All the queries for the database are stored procedures, so I use CallableStatement.
The problem is that after a while I get an "maximum open cursors exceeded" sqlexception. I have triple checked and all of my resultsets, callablestatements and connection are being closed in a finally block.
So, I am starting to think that, although I close everyting, not everything is being closed.
So here is my question. If I close a resultset, callablestatement or a connection are they closed immediately, or is there a period of time that should pass before everything is closed (perhaps with gc).
I am using a Oracle 8.1.7 database.
Does anyone know this?