JSP jdbc bean doesn't seem to release cursor !?
Posted on 2001-07-30
I am running oracle 8.1.6, and the 1.5.2 orion server.
I am using connection pooling.
I am using a JSP page with a jdbc java bean.
Everything works fine, except if I execute about 40-50 rapid executions of the JSP page, I run out of cursors.
I have rs.close, stmt.close, and connection.close() commands at the end of each SQL call, BUT I see the cursor count climb with each execution.
The cursor count does go down with time, - I imagine the cursor times out. Also I notice that once the jsp page executes, I will not see the db connection close until a few minutes later, even though I have issued conn.close() explictedly (?) !
Can anyone give me some insight into what may be going on?