• 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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic