This is a bug in Oracle's Java implementation - it is mentioned somewhere
in their technical web site, but even when you know to look for it it takes
about 5 hours to find (from my experience).
You can work around by making all your embedded sql into prepared
statements:
String sql = "select * from table_name";
PreparedStatement ps = databaseconnection.prepareStatement(sql);
ResultSet rs = ps.executeQuery();
rs.close();
ps.close();
databaseconnection.close();
-Duncan
-----Original Message-----
From: Rathna [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 04, 2000 2:08 PM
To: [EMAIL PROTECTED]
Subject: Help Needed - Max cursor exceeded Exception
hi all,
This is a bit off topic but i am sure someone in the list would thru
light on this.
we are developing a internet based application which works fine but when
we keep accessing for some time, at some point in sql query it throws
"max number of cursors exceeded" , then after wards it stops responding
for all the database operation.i sure we are closing all the statements
after
each execution of query also we have set the maximum cursor as 250.
when would the opened cursor will reach the max limit?
FYI,we are using connection pooling mechanision to maintion the
connection.
env: Jrun,apache,oracle8.1.6 on NT.
thanx in advance ...
--
with regards,
rathna
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
