Home » Developer & Programmer » JDeveloper, Java & XML » Closed Statement (Oracle Database 10g Release 10.1.0.2.0, AIX 5.3)
Closed Statement [message #278246] Fri, 02 November 2007 09:29 Go to next message
alexleong
Messages: 2
Registered: November 2007
Junior Member
Hi,
I’m experiencing the following error running a java web application on AIX version 5.3 with Oracle Database 10g Release 10.1.0.2.0? This error is only happened off and on, is there anything wrong with my java code or the database configuration?

java.sql.SQLException: Closed Statement
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java(Compiled Code))
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java(Inlined Compiled Code))
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java(Inlined Compiled Code))
at oracle.jdbc.driver.OracleStatement.ensureOpen(OracleStatement.java(Inlined Compiled Code))
at oracle.jdbc.driver.OraclePreparedStatement.sendBatch(OraclePreparedStatement.java(Compiled Code))
at oracle.jdbc.driver.OracleConnection.commit(OracleConn
ection.java(Compiled Code))
at com.evermind.sql.FilterConnection.commit(FilterConnec
tion.java(Compiled Code))
at com.evermind.sql.OrionCMTConnection.commit(OrionCMTCo
nnection.java(Compiled Code))
at com.evermind.sql.ConnectionBCELProxy.commit(Connectio
nBCELProxy.java(Compiled Code))


Below is my application configuration for JBDC.
<data-source
class="com.evermind.sql.DriverManagerDataSource"
name="OracleDS"
location="jdbc/OracleCoreDS"
xa-location="jdbc/xa/OracleXADS"
ejb-location="jdbc/OracleDS"
connection-driver="oracle.jdbc.driver.OracleDriver"
username="xxx"
password="xxxxxx"
url="jdbc:oracle:thin:@127.0.0.1:1521:uat"
inactivity-timeout="120"
min-connections="10"
max-connections="500"
max-connect-attempts="10"
wait-timeout="60"
connection-retry-interval="10"/>
</data-sources>
Re: Closed Statement [message #278402 is a reply to message #278246] Sat, 03 November 2007 15:13 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
This exception normally is thrown when you try to reuse a callable statement that was closed already.
Check the stacktrace for the location of the offending line in your java-source.
Re: Closed Statement [message #278521 is a reply to message #278246] Sun, 04 November 2007 20:43 Go to previous messageGo to next message
alexleong
Messages: 2
Registered: November 2007
Junior Member
hi Frank,
Thanks for your reply, this exception occur at the moment my program called the commit method, but my close method is at the finally block, so the connection should not be closed. This exception is only happened occasionally, if the case like what you mentioned, this exception will occur consistently.

Regards
Re: Closed Statement [message #278541 is a reply to message #278521] Mon, 05 November 2007 00:42 Go to previous message
Frank
Messages: 7901
Registered: March 2000
Senior Member
The error does not have to occur consistently. There are more ways to close a transaction then to commit. It depends greatly on how you handle exceptions for example. Are all exceptions propagated to the java-block you are referring to, or are some handled somewhere halfway? (Either in a nice "when others" in the database-procedure, or a catch in a java method)
Previous Topic: Removing Whitespace from XML with DBMS_XMLGEN
Next Topic: XPath - get element name - works in v11g, not in 10g
Goto Forum:
  


Current Time: Thu Mar 28 07:21:55 CDT 2024