I'm using a PreparedStatement and I do close it. It still has problems. I
have no problems when I don't use the connection pooling.
Thanks,
Gary
> -----Original Message-----
> From: Eric Knapp [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, April 09, 1999 5:04 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Connection Pool - DbConnectionBroker
>
> You have to close the statement after you use it.
>
> stmt = con.createStatement();
> rs = stmt.executeQuery(qs);
>
> perform query here
>
> rs.close();
> stmt.close();
>
>
> Each time you run the createStatement() method it opens a cursor in
> Oracle.
> When you close() it closes the cursor.
>
> -Eric
>
> At 04:10 PM 4/9/99 -0500, Formanek Gary L wrote:
> >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.
>
> __________________________________________________________________________
> _
> 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
___________________________________________________________________________
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
