Re: Open_Cursors

Mark Bole <makbo_at_pacbell.net> wrote in message news:<wtHec.36238$Pr7.8852_at_newssvr29.news.prodigy.com>...

Actually, this is CFMX which is a full J2EE Application. They way it works is you write some SQL statements in a tag, the application then executes the statement and returns a recordset.

We have no access to the database connection pool so there is no way for us to leave connections open. That is all handeled by the CFMX Application.

That was my question. We have not seen this issue on CF5 (a non-Java implementation) and we have seen tons of bugs in the MX product as it relates to the database drivers so I was just assuming that this was potentially another bug.

A few of our customers that have the problem have the cursors set to 300. I did not want to go back to them and tell them to bump that up to say 1000 or 1500 if

1. That would chew up a ton of memory and potentially cause the server to be unstable
2. Not fix the problem, if this was just some sort of race game and by bumping it up to 1000 it would just extend the time between the error messages.

Thanks for your input.

> Another agreement, from another perspective: with numerous "open
> cursor" error situations from a Java front-end, every time it has turned
> out to be application code that opens a cursor but doesn't close it,
> typically an in-house library routine for DB access. Ask your
> developers to list all the ways that the application can open a
> cursor... you may be surprised.
>
> Funny developer statement: "Gee, can't Oracle just know to close the
> cursor when I'm done with it?".
>
> If you have a connection pool of some sort, just close and re-open it
> every so often, that is one pragmatic way to solve the problem. ;-)
>
> --Mark Bole
Received on Tue Apr 13 2004 - 08:12:44 CDT