Re: EXCEPTION

[Godbey, David]

Title: RE: EXCEPTION

Caution here. A mistake I see all the time is that a developer will create a loop in which a PreparedStatement object, or some other result set generating entity, is instantiated every time through the loop. If you don't hava a matching close() on these objects, you will get too many open cursors very quickly.

 

The proper way to handle the situation is to create a single PreparedStatement object, then change the bind variable values every time through the loop. This way you only create a single cursor with changing the variable values every time through the loop. This also has a performance advantage since the database engine will not have to reparse the sql statement every time through.

 

Dave

[Godbey, David]  -----Original Message-----
From: Julian Eduardo de Anquin [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 24, 2001 8:31 AM
To: [EMAIL PROTECTED]
Subject: Re: EXCEPTION

it is not enough to close the connections? i must also close the statements and the resultsets?

thanks a lot

Julian

-----Original Message-----
From: A mailing list for discussion about Sun Microsystem's Java Servlet API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of Naresh Chhuttani
Sent: Viernes, 24 de Agosto de 2001 03:39 a.m.
To: [EMAIL PROTECTED]
Subject: Re: EXCEPTION

Close all the connections in ur program
You can also increase the max number of connections
in DB Server.

-----Original Message-----
From:   Geeta Ramani [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, August 23, 2001 10:03 PM
To:     [EMAIL PROTECTED]
Subject:        Re: EXCEPTION

Hi Julian:

Make sure you close every statement you create (and every connection you make
to your database). That may do the trick.

Geeta

Julian Eduardo de Anquin wrote:

> I'am getting this excpection when executing some query and inserts into
> Oracle, ORA-01000: maximum open cursors exceeded ORA-06512:  at
> "SA2.tr_CELDAS", line 2 ORA-04088: error during execution of trigger
> 'SA2.tr_CELDAS'
> any clue?
> Julian
>
> ___________________________________________________________________________
> 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