Re: JSP JDBC bean doesn't seem to release cursor !?

[Zahid Rahman]

If memory serves me correctly   In the tnsnames file for oracle there is default cursor limit set to 50.   you need to increase the limit.   Zahid    ----- Original Message ----- From: Keith Kwiatek To: [EMAIL PROTECTED] Sent: Monday, July 30, 2001 9:32 PM Subject: JSP JDBC bean doesn't seem to release cursor !? 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