Re: jdbc thin driver raises: ORA-01000: maximum open cursors exceeded

From: <essmith4647_at_my-deja.com>
Date: 2000/07/11
Message-ID: <8kg2ab$7l7$1@nnrp1.deja.com>#1/1

Be sure that once you have finished using your result set, you close the result set AND the statement.

In article <8jfisj$cda$1_at_crusher.de.colt.net>, "André Hartmann" <Andre.Hartmann_at_pace.de> wrote:
> Hi there,
>
> my jdbc thin driver comes up with a "ORA-01000: maximum open cursors
> exceeded" message after a connection has been opened and several
statements
> have been processed. How do I work around that ?? Surely I could
increase
> the number of max. cursors allowed but this would shift the problem to
a
> later point of time only... so, how to really handle it ?
>
> If this is rather a java question... sorry about it. Thanx in
advance,
> your's
>
> André
> :)
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Jul 11 2000 - 00:00:00 CDT