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

This depends on the value of the open_cursor parameter. The default is 50 which is usually way too low.
500 is more like it.
A common problem in java applications is programmers don't close their cursors. This eventually results in the error you are seeing.

Regards,

Sybrand Bakker, Oracle DBA

"André Hartmann" <Andre.Hartmann_at_pace.de> wrote in message news:8jfisj$cda$1_at_crusher.de.colt.net...
> 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é
> :)
>
>
>
Received on Thu Jun 29 2000 - 00:00:00 CDT