Re: Help...

From: Telemachus <telemachus_at_ulysseswillreturn.net>
Date: Mon, 20 Jan 2003 14:36:56 -0000
Message-ID: <cQTW9.4108$V6.6066_at_news.indigo.ie>


What happens when you do SQL*Plus

SELECT 1 from dual;

?
"Jayakrishnan" <jktojk_at_hotmail.com> wrote in message news:1ba4614.0301200513.2ec1723e_at_posting.google.com...
> Please tell me how to solve this?
> I closed all the open connections....still it comes...
>
>
> 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.ja va:119)
> at

oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.ja va:92)
> at

oracle.jdbc.driver.OracleConnection.privatePrepareStatement(OracleConnection .java:950)
> at

oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:8 02)
> 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)
> 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)

> at org.apache.tomcat.core.Handler.service(Handler.java:286)
> at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
> at
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:79 7)
> at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
> at
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpC onnectionHandler.java:210)
> at

org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
> at

org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498)
> at java.lang.Thread.run(Thread.java:484)
Received on Mon Jan 20 2003 - 15:36:56 CET

Original text of this message