Help...

From: Jayakrishnan <jktojk_at_hotmail.com>
Date: 20 Jan 2003 05:13:30 -0800
Message-ID: <1ba4614.0301200513.2ec1723e_at_posting.google.com>

Please tell me how to solve this?
[Quoted] [Quoted] I closed all the open connections....still it comes...

[Quoted] java.sql.SQLException: ORA-01000: maximum open cursors exceeded

	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
	at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
	at oracle.jdbc.ttc7.Oopen.receive(Oopen.java:120)
	at oracle.jdbc.ttc7.TTC7Protocol.open(TTC7Protocol.java:586)
	at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:385)
	at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:413)
	at oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:119)
	at oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:92)
	at oracle.jdbc.driver.OracleConnection.privatePrepareStatement(OracleConnection.java:950)
	at oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:802)
[Quoted] [Quoted] 	at com.mercatorgeo.rabo.db.sqlBase.doQuery(sqlBase.java:116)
	at com.mercatorgeo.rabo.db.DataProcessor.getProjectByPK(DataProcessor.java:54)
	at com.mercatorgeo.rabo.db.DataProcessor.getSystemUsageWithGroup(DataProcessor.java:309)
	at com.mercatorgeo.rabo.servlet.DynamitServlet.doPost(DynamitServlet.java:85)
[Quoted] [Quoted] 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404)
[Quoted] 	at org.apache.tomcat.core.Handler.service(Handler.java:286)
[Quoted] 	at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
	at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797)
[Quoted] 	at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
	at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:210)
	at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
	at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498)
[Quoted] 	at java.lang.Thread.run(Thread.java:484)

Received on Mon Jan 20 2003 - 14:13:30 CET