| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Cursor : please help
What type of JDBC driver are u using? I haven't used 9i yet.
But some 8i OCI drivers caches the cursor even if you close the ResultSet,
Statement object. Thus you will see it increments. You will have to
close the Connection object which is not good like your situation since
you are pooling them.
No to doubt your programming ability but you should also check to see how and where the ResultSet and Statement are closed. I have gone through codes that the developer claim that they closed everything, but if the statement is not at the right place, just having a closed statement doesn't necessarily means it will get closed.
Richard Ji
-----Original Message-----
From: JOSHY MON M C [mailto:JOSHYMON_at_nestec.net]
Sent: Tuesday, September 10, 2002 1:14 PM
To: Multiple recipients of list ORACLE-L
Subject: Cursor : please help
Hi All,
I ve a JSP application. Each time I query database ( oracle 9i) from the
page, I see that the no.of cursors increments by one. I m accessing database
using JDBC, I close resultset and statement objects after query. But I m not
closing Connection object since I use a Connection Pool.
Can anyone tell why the no,of cursors increasing each time ?
Thanks in advance
Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: JOSHY MON M C
INET: JOSHYMON_at_nestec.net
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Sep 10 2002 - 15:43:37 CDT
 |
 |