| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
