• Post Reply Bookmark Topic Watch Topic
  • New Topic

getting "max open cursors exceeded" from EJB  RSS feed

 
Gul Khan
Ranch Hand
Posts: 173
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi, I am using weblogic 6.1 i try to run this process in loop which reads/writes to the database. When the loop size increases it gives me the maximum open cursors exceeded error. I checked and the bean is closing the connection and statements in every loop.
the same code is working fine when i use a normal java class and not an EJB. By the way i am migrating the old process(which uses java class) into an EJB.
The maximum allowed connection inside weblogic is 5. I am the only one using it as it is on the local machine.

Can anyone provide some help regarding this problem.

Thanks
[ July 13, 2004: Message edited by: pervaiz gul ]
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Check how many open cursors you DB is configured to allow. It might be set way below the max connections value set by your connection pool (if you are using one) or the number of connections your loop requires.
 
Karthik Guru
Ranch Hand
Posts: 1209
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yes, as already suggested you might want to take a look at the max cursor open setting for your database. Weblogic 8.1 has an option to switch on prepared statement cache. We used to see this error when the cache was on and it went away when it was switched off. but ofcourse switching off the cache w'd lower performance.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!