wood burning stoves*
The moose likes Object Relational Mapping and the fly likes maximum opened cursors exeeded Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "maximum opened cursors exeeded" Watch "maximum opened cursors exeeded" New topic

maximum opened cursors exeeded

elhamidi othman

Joined: Apr 16, 2004
Posts: 1
When using hibvernate to access an oracle DB I get the following error message: "maximum opened cursors exeeded"
I still have the proble even after putting "hibernate.statement_cache.size=0" in my "hibernate.properties"

If any one has an idea ??
[ April 16, 2004: Message edited by: elhamidi othman ]
Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336

Hibernate's statement cache doesn't hold on to open cursors. Are you sure you are closing Hibernate sessions after you use them? In a finally block? Have you checked how many cursors Orcale will allow you? This might be set to a very low value.

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
It is sorta covered in the JavaRanch Style Guide.
subject: maximum opened cursors exeeded
Similar Threads
implicit open cursors problem
Is it possible that number of open_cursors raise above maximum set limit
Maximum PreparedStatements per connection
Handling huge resultset
Error message : ORA-01000: Maximum number of open cursors reached ??