jktojk_at_hotmail.com (Jayakrishnan) 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.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)
> 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:797)
> 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)
> at java.lang.Thread.run(Thread.java:484)
Thanx for your answers. Problem was due to some open connections.
Now it works fine...plz avoid discussion on this question here after.
Received on Mon Jan 20 2003 - 21:59:47 CST
