A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
Maximum cursor exceed
Joined: Mar 27, 2006
Apr 14, 2006 07:28:00
in my appliction,
i am getting exception :
: 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....
Joined: Dec 15, 2005
Apr 14, 2006 07:43:00
Answered for this user, in another forum:
Joined: Sep 25, 2003
Apr 14, 2006 14:26:00
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.
insapp = conn.prepareStatement(contSql.toString()); //contSql is a simple insert statement insapp.setLong(1, num_sequence); insapp.setString(2, "DRAPPS"); insapp.setLong(3, 1100); insapp.setLong(4, 1100); insapp.setString(5, "Job Application"); insapp.setString(6, tmpAry.trim()); insapp.setString(7, tmpAry.trim() + " " + tmpAry.trim()); insapp.setString(8, tmpAry.trim()); insapp.setString(9, tmpAry.trim()); insapp.executeUpdate(); insapp.close();
Hopefully it is something simple that i just seem to be overlooking...
It is sorta covered in the
JavaRanch Style Guide
subject: Maximum cursor exceed
Midlet size restrictions
TextArea max length Validation
maximum open cursor ... please help
Closing Statement object prior to committing
Cannot get Oracle CURSOR from Oracle procedure
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015