I am experiencing some problems with oracle closing connections. I will
list all the information that I have below.
My application is threaded but we have safely implemented concurrent
transactions. As my threads complete and begin closing connections to the
database there is always an arrent thread that hangs when trying to close
its connection to oracle. It is always the last connection that hangs, and
appears to be random. Although it appears it might be a deadlock of some
kind between the Finalizer and the thread. The stack trace of the thread is
listed below.
[1] oracle.jdbc.driver.OraclePreparedStatement.close
(OraclePreparedStatement.java:235)
[2] oracle.jdbc.driver.OracleConnection.close_statements
(OracleConnection.java:1,596)
[3] oracle.jdbc.driver.OracleConnection.close (OracleConnection.java:899)
[4] org.exolab.castor.jdo.engine.TransactionContextImpl.commitConnections
(TransactionContextImpl.
java:133)
[5] org.exolab.castor.persist.TransactionContext.commit
(TransactionContext.java:1,532)
[6] org.exolab.castor.jdo.engine.DatabaseImpl.commit
(DatabaseImpl.java:500)
[7] com.cnanash.medfees.persistence.MedfeesJDOManager.end
(MedfeesJDOManager.java:119)
[8] com.cnanash.medfees.MedfeesInvoiceManager$ThreadManager$Runner.run
(MedfeesInvoiceManager.java
:395)
[9] java.lang.Thread.run (Thread.java:539)
Thread-6[1] where 0x2c0
Additionally the FinalizerThread is hung the trace is below.
[1] oracle.jdbc.driver.OracleConnection.isStmtCacheEnabled
(OracleConnection.java:2,333)
[2] oracle.jdbc.driver.OraclePreparedStatement.privateClose
(OraclePreparedStatement.java:275)
[3] oracle.jdbc.driver.OraclePreparedStatement.close
(OraclePreparedStatement.java:235)
[4] org.exolab.castor.jdo.engine.SQLEngine$SQLQuery.close
(SQLEngine.java:1,675)
[5] org.exolab.castor.jdo.engine.OQLQueryImpl.close
(OQLQueryImpl.java:520)
[6] org.exolab.castor.jdo.engine.OQLQueryImpl.finalize
(OQLQueryImpl.java:533)
[7] java.lang.ref.Finalizer.invokeFinalizeMethod (native method)
[8] java.lang.ref.Finalizer.runFinalizer (Finalizer.java:86)
[9] java.lang.ref.Finalizer.access$100 (Finalizer.java:17)
[10] java.lang.ref.Finalizer$FinalizerThread.run (Finalizer.java:163)
Finalizer[1]
If anyone has any ideas they would be very much appreciated.
Thanks
> Alex Winston
> Programmer Analyst, SCP
> CNA Life Department-Information Technology
> Software Applications Services
> [EMAIL PROTECTED]
> 615-886-6947
>
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
