I' m using CMP, so there is no statement object on which I could perform a
close()
> -----Original Message-----
> From: Schultz, Bob (Consultant) [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 25, 2000 5:46 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Cursors Open problem with multiple insertions
>
>
> I also had this problem with Oracle. A quick search on
> deja.com led me to
> the solution (it SEEMS to be working!) that says we must
> explicitly perform
> a close() on the statement object you are using. In fact,
> you are likely
> best off closing every result set and statement object, then
> closing the
> connection, for every database call you make.
>
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".