Maximum Open Cursors

[bsuribabu]

Hi All,

I am facing Maximum Open Cursors problem in our Application.

Actually we are closing the result set at commit level.

What my idea is to place result set values in a 2D Array
and my function uses the same and i will close the result set once the Array had been formed .

Is there any consequences placing the Result set into an 2D array?

Please suggest me with u r comments

 

[hologram]

Have a look at

http://developer.java.sun.com/developer/Books/JDBCTutorial/chapter5.html

"A disconnected rowset gets a connection to a data source in order to fill itself with data or to propagate changes in data back to the data source, but most of the time it does not have a connection open. While it is disconnected, it does not need a JDBC driver or the full JDBC API, so its footprint is very small. Thus a rowset is an ideal format for sending data over a network to a thin client."
And more specific look at "CachedRowSet".

 

[sedj]

>>> Hi All,

I am facing Maximum Open Cursors problem in our Application.


Are you sure your db is returning the connections to its pool, or actually registering that the connection is no longer used ?

Also speak to your DBA to check how many cursors are allowed. It may be really low !