Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Implicit and Explicit cursors
I work with an application that uses JDBC (the ORACLE thin driver ) to connect to an ORACLE 8i database and our database connections are stored in a connection pool. The application uses the CallableStatement object to execute statements and all database access ( Select, Insert, Update, etc ) is from stored procedures.
Despite our best efforts to explicitly close ResultSet objects and CallableStatement objects .... our database connections continue to leave cursors open. I have read everything I can find about implicit vs. explicit cursors and I believe that these lingering cursors are implicit cursors. And, because we don't close the database Connection object.. .these implicit cursors are never closed.
Can anyone recommend a document that I can read that describes in detail implicit vs. explicit ORACLE cursors and when ORACLE closes and/or deallocates implicit cursors? Has anyone else seen this type of behavior when using connection pools? Any insight someone can provide will be most helpful.
Thank You
The contents of this message express only the sender's opinion. This message does not necessarily reflect the policy or views of my employer, Merck & Co., Inc. All responsibility for the statements made in this Usenet posting resides solely and completely with the sender.Received on Mon Apr 16 2001 - 15:48:05 CDT