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

[Zahid Rahman]

Let me correct myself it is one of the Oracle files but not tnsnames. You have to restart Oracle for it take effect.   Also if you increase the cache size I think that increases the speed.   This is only a trouble shoot because possibilities can be endless although I did come across a similar problem before.   Also it may be worth having a look at ext proc agent server which allows you to hook c DLLs   Zahid    ----- Original Message -----   From: Zahid Rahman To: [EMAIL PROTECTED] Sent: Monday, July 30, 2001 9:44 PM Subject: Re: JSP JDBC bean doesn't seem to release cursor !? 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