Re: signoff JSP-INTEREST - Just for signoff

[Zahid Rahman]

JSP Pro book recommend you use mysql database when you are using connection pooling with a type IV driver. Apparently it improves performance. I think the database is free.   Perhaps have a look at that aswell.   ----- Original Message ----- From: Schulz Ryan C To: [EMAIL PROTECTED] Sent: Tuesday, July 31, 2001 1:24 PM Subject: signoff JSP-INTEREST   -----Original Message----- From: Panayotou, Michael [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 31, 2001 12:08 AM To: [EMAIL PROTECTED] Subject: Re: JSP JDBC bean doesn't seem to release cursor !? 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