Hello,
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 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?
Keith