Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help...
did you just 'close' the connections or did you kill the sessions?
check v$session for open session and kill them.
"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)