Re: open_cursors limit?

Ed,

I'm an oracle newbie so I'm not sure of the parameter to use to increase that, but you need to make sure your Java code doesn't leak cursors by calling the Statement.close() and ResultSet.close() methods inside the finally block of the try/catch/finally you've got around your db processing code. Sure, these get closed automagically when your references go out of scope and when the garbage collector feels like finalizing them, but you have limited control ever that.

I quickly ran into the cursor limit w/Oracle & Java and learned it was because I was relying on the finalizer to clean up Statements and ResultSets.

Hope this helps.

-MGP ewong74_at_netscape.net wrote:

> Hi, I have a java application which connect to an Oracle8 db on NT4. I would
> like to know is there a open_cursor limit for the database(or OS)?
>
> Thanks in advance.
>
> Ed
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

Received on Wed Apr 21 1999 - 22:48:52 CDT