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 ]
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.
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.