I have been trying to get connection pooling to work for our servlet. I'm
using the DbConnectionBroker from http://www.javaexchange.com/. However, I
keep getting the following error:
Error code = -5 Error message = A SQL Exception has occurred in
insertUpdateDelete. SQLState: Message: ORA-01000: maximum open cursors
exceeded Vendor: 1000
It seems to work for 3 or for transactions and then gets this message. Wait
a bit and then it works 3 times. I've tried raising the OPEN_CURSORS
initialization for Oracle 7.3, but it only goes longer and then has the same
problem.
I've double-checked the code and I'm doing a getConnection() and then a
freeConnection() in the same method and the freeConnection() is in a finally
block, so it always gets executed.
Has anyone run across a similar problem?
I appreciate any help.
Thanks,
Gary
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
