wood burning stoves 2.0*
The moose likes Oracle/OAS and the fly likes too many open cursors Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "too many open cursors" Watch "too many open cursors" New topic
Author

too many open cursors

Lars Vegas
Greenhorn

Joined: Dec 04, 2001
Posts: 27
Hi,
I've a big problem with Oracle/Borland classes. Im using the borland class QueryDataSet. That class has a method closeStatement(), which is supposed to close the open cursor on the database. but it doesn't seem to work. The open cursors remain open. so, after a while I get the big bang. Has anyone experience with problems like this? Or, if not, how can I close the open cursors although I don't know the names of the not-active cursors?
Any help appreciated.
Lars
Asif Equbal
Greenhorn

Joined: Dec 10, 2001
Posts: 7
The problems sems to be with the init.ora file setting .
Change ur init.ora parameter names max_open_cursor = 200 ( default it is 50) .
i think this will do the Job

------------------
Asif Equbal
Cognizant Technology Solutions , India.


Asif Equbal<BR>Cognizant Technology Solutions , India.
Lars Vegas
Greenhorn

Joined: Dec 04, 2001
Posts: 27
Thanks for trying to help. But I don't want to raise the allowed maximum of open cursors, because it will lower performance. I want to close the open cursors, that are not needed anymore!!!
Lars Vegas
Greenhorn

Joined: Dec 04, 2001
Posts: 27
Thanks for trying to help, but I don't want to raise the allowed number of open cursors, I want to close the not needed open cursors. In my application even 200 open cursors won't be enough. And I cannot raise to 5000. I need performance and I just don't want to keep these cursors!!!
Lars
Beksy Kurian
Ranch Hand

Joined: Jul 11, 2001
Posts: 254
close the resultset and the statement.
Regards
Beksy
Lars Vegas
Greenhorn

Joined: Dec 04, 2001
Posts: 27
I cannot close the statement, because the function closeStatement() from the Borland class QueryDataSet is NOT working!!! The function does not close the statement. And replacing the whole Borland stuff is not possible anymore in short time!!!
Any help still appreciated.
Lars
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: too many open cursors
 
Similar Threads
ORA-01000: maximum open cursors exceeded
Result Set
CallableStatement (Oracle JDBC)
JPA Queries Open Cursors
ORA-01000 maximum open cursors exceeded