Hello Vitaly,
I have seen this problem before and I got two ways to solve it:
1. Don't use the same JDBC Connection object more than a certain number of
times.
2. Increase the maximum number of connections to the database instance.
Either of the above solves the problem.
You can do the second, but the chances of the error re-occuring sooner or later
is pretty high and so I resorted to the first choice.
Can somebody tell me if this is a bug or a feature of the Oracle Drivers. I
don't know what else could cause this to happen.
Thank you,
Ramesh
At 03:21 PM 6/30/99 +0300, Vitaly Yermolenko wrote:
>
> Hi!
>
> Has anyone known what I must to do in case:
>
> java.sql.SQLException: ORA-01000: maximum open cursors exceeded
>
> In my servlets for access to Oracle database I use the next
> constructions, like:
>
> try
> {
> stmtStmt = connConn.createStatement ();
> rsResult = stmtStmt.executeQuery (strQuery);
> while (rsResult.next ())
> {
> . . .
> }
> }
> catch (SQLException e1)
> {
> try
> {
> if (rsResult != null)
> rsResult.close ();
> if (stmtStmt != null)
> stmtStmt.close ();
> }
> catch (SQLException e2) { }
> }
> finally
> {
> rsResult = null;
> stmtStmt = null;
> }
> but after some time I have this SQL Exception...
>
> I use Kaffe VM 1.0b4 + Apache/1.3.4 + JServ 1.0b1 + Oracle JDBC Thin
> Driver 7.3.4 (classes111.zip) on the RH Linux 5.0 for connection to the
> Oracle7 Server
> (7.3.2.1.0).
> If you can give me some help regarding this problem it will be nice...
>
> Thanks!
>
> Regards,
> Vitaly Yermolenko
> <mailto:[EMAIL PROTECTED]>[EMAIL PROTECTED]
___________________________________________________________________________
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
