File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
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 ""

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
I agree. Here's the link:
subject: maximum opened cursors exeeded
It's not a secret anymore!