Re: jdbc cursors

From: Lane W. Sharman <lane_at_opendoors.com>
Date: Sun, 03 Jan 1999 23:51:44 -0800
Message-ID: <36907310.FBACA4E8@opendoors.com>

Hi,

Actually, cursors are a scarce resource. Increase the your initXXXX.ora file:

OPEN_CURSORS=xxxx

where xxxx > 500 for minimum production systems.

-Lane

Ed Zappulla wrote:

> Hi, I'm using the oracle 8.0.4 JDBC drivers and have a loop which invokes a
> method to insert a row. The insert method creates a prepared statement and
> executes the update.
>
> I'm getting a SQLException from the Oracle driver indicating that the max
> cursors have been reached. It seems each execute is allocaing a new cursor.
> I'm done with the statement after each insert.
>
> How do I clean up the cursors?
>
> ...ed

--
Lane Sharman
CTO: http://www.opendoors.com/lane
Professional Services: http://www.opendoors.com/ps Time Management: http://www.opendoors.com/gt

Application Server Construction SDK: http://www.opendoors.com/instant/lcis

Evolving Software: http://www.opendoors.com/instant/mcm

User Interface Builder (Open Source): http://www.freebongo.org

Sales/Direct: 800-923-TIME/619-755-2868 Solutions, Not Hand Waving Received on Mon Jan 04 1999 - 01:51:44 CST