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

[Panayotou, Michael]

You must increase the init.ora parameter open_cursors -----Original Message----- From: Keith Kwiatek [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 11:33 PM To: [EMAIL PROTECTED] 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