Re: JDBC / oracle 8i

From: Buck Turgidson <remove-me_jc_va_at_hotmail.com>
Date: Tue, 13 Mar 2001 00:53:06 GMT
Message-ID: <Sber6.6380$Rb.505544@bgtnsc05-news.ops.worldnet.att.net>

Close the cursor upon leaving the method, or make the prepared statement an instance variable instead of a method variable. It's one of the things I don't like about JDBC. You might also have a look at SQLJ.

"Thomas Durlach" <durlecht_at_msu.edu> wrote in message news:98ipqd$flb$1_at_msunews.cl.msu.edu...
> Hello all,
>
> i have a java program that inserts records into oracle 8i....problem
> is...after the 7th record, i get this error:
>
> unable to insert beacuse: java.sql.SQLException: ORA-01000: maximum open
> cursors exceeded
>
>
> i am new at this and not sure what to do. i set the connection to
> auto-commit but that didnt help. any help would be greatling appreciated.
>
>
> thanks,
>
> thomas durlach
>
>
Received on Mon Mar 12 2001 - 18:53:06 CST