Re: ORA-01000: maximum open cursors exceeded

From: Thomas Kellerer <BDHLDUUTPRWS_at_spammotel.com>
Date: Fri, 16 Jun 2006 15:47:15 +0200
Message-ID: <4ffr33F1hugclU1@individual.net>

On 16.06.2006 15:32 Oliver Neumann wrote:
> Hi dennis,
>

>> I think that your transaction is too long.
>> The cursor used to get the sequence number is not being closed until
>> the transaction commits.

>
>
> hmm i have no idea when i use cursors (like i told, im not this familiar
> with oracle db's). I just send the SQL-Statement by jdbc and use the
> resultset to get the return-values.
>

You have to make sure, you do close all ResultSets and all Statements (even more important, as every Statement maps to a cursor on the server side)

Thomas

-- 
It's not a RootKit - it's a Sony

Received on Fri Jun 16 2006 - 08:47:15 CDT