File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Maximum cursor exceed Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Maximum cursor exceed " Watch "Maximum cursor exceed " New topic

Maximum cursor exceed

sachin kataria
Ranch Hand

Joined: Mar 27, 2006
Posts: 45
in my appliction, java handles server
i am getting exception : java.sql.SQLException : Maximum cursor exceed

i check the code and all the connection's are closed.

i search for solution, so, there was a solution, in init.ora file OPEN_CURSOR = 500

but i do not want to change that parameter .... so, is there any another way to solve that bug...??
pls help me....
stu derby
Ranch Hand

Joined: Dec 15, 2005
Posts: 333
Answered for this user, in another forum:
Lisa D'Aniello
Ranch Hand

Joined: Sep 25, 2003
Posts: 42
Hi All - (Sorry Sachin - I don't mean to hijack your question, but I didn't want to post the same exact issue in another thread).

I am having the same problem, and the solution below does not help. Nor does any other solution I can find... Here is my code - it happens after less than 100 record insertions.

Hopefully it is something simple that i just seem to be overlooking...
I agree. Here's the link:
subject: Maximum cursor exceed
jQuery in Action, 3rd edition