This week's book giveaways are in the Refactoring and Agile forums.
We're giving away four copies each of Re-engineering Legacy Software and Docker in Action and have the authors on-line!
See this thread and this one for details.
Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

maximum opened cursors exeeded

 
elhamidi othman
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic