Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: JDBC / oracle 8i

Re: JDBC / oracle 8i

From: <dbianchi_at_square.nl>
Date: 12 Mar 2001 15:59:31 GMT
Message-ID: <98irp2$24pon$4@ID-18487.news.dfncis.de>

In comp.lang.java.programmer Thomas Durlach <durlecht_at_msu.edu> wrote:
> unable to insert beacuse: java.sql.SQLException: ORA-01000: maximum open
> cursors exceeded

Your database has a maximum of 7 cursor for each connection, you have to close each ResultSet/Statement after the insertion.

Davide Received on Mon Mar 12 2001 - 09:59:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US