Home » Developer & Programmer » JDeveloper, Java & XML » POOL - Maximun Open Cursors Exceeded
POOL - Maximun Open Cursors Exceeded [message #119471] Thu, 12 May 2005 13:43
jiperinha
Messages: 3
Registered: May 2005
Junior Member
Hi,

I have a problem with my java-oracle connection pool.

We are using a Connection Pool but some hours later we receive a message about "Max open cursors excedeed".

We open and close the conexions, CallableStatements and PreparedStatements properly, so this is not the problem.

Because of we are using a connection pool, the connection is always opened and what is happening is that the implicit cursors that Oracle opens when we are calling a stored procedure are never closed.

We have discovered an option "CLOSE_CURSORS_AT_COMMIT" but it doesn't work properly and It's not supported.

Moreover, we don't know how to release the connection pool definitely to close all this cursors.

Has anyone suffered this problem?

Thanks
Previous Topic: Passing Array of objects from java to oracle
Next Topic: Connection to 8.1.7 Database Fails With OCI8 Driver : UnsatisfiedLinkError
Goto Forum:
  


Current Time: Sun Mar 03 22:58:19 CST 2024