Re: JDBC problem

From: <sybrandb_at_my-deja.com>
Date: Mon, 05 Feb 2001 12:55:38 GMT
Message-ID: <95m7s7$l0u$1@nnrp1.deja.com>

In article <3A7E93AD.2F0D13F8_at_cs.strath.ac.uk>, Randeep Gill CS1997 <rgill_at_cs.strath.ac.uk> wrote:
> I am using JDBC to access an oracle 7 database however keep
experiencing
> the following AQL error: The ERROR : ORA-01000: maximum open cursors
> exceeded
> Ive tried closing all my resultsets after use but that doesnt help.
> Any ideas?
>

Increase the init.ora parameter open_cursors. The default is 50 which is just ridiculous.

Hth,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


Sent via Deja.com
http://www.deja.com/

Received on Mon Feb 05 2001 - 06:55:38 CST