I am getting this error when my
java code trying to acess DB (Oracle 9i) thr'
JDBC driver. It happens only in the production environment that to occationally. We can not duplicate the problem on our
test servers, which has exact same configuration. Here is the trace.
java.sql.SQLException: Closed Statement
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:158)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:305)
at oracle.jdbc.driver.OracleStatement.ensureOpen(OracleStatement.java:3945)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3000)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3059)
I thought and searched for all my connections is there any closing statements before calling executeQuery() method,
Please suggest me is there any other place get chance to close connections
Thanks in advance
Bala