ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Givler, Eric" <egiv...@state.pa.us>
Subject Connections and Transactions with JNDI DataSource - possible leak?
Date Fri, 02 Oct 2009 15:13:28 GMT
I have an OC4J container and am experiencing a connection leak log in my server logs:

09/09/29 17:46:10 OrionCMTConnection not closed, check your code!
09/09/29 17:46:10 Logical connection not closed, check your code!
09/09/29 17:46:10 (Use -Djdbc.connection.debug=true to find out where the leaked connection
was created)

I don't want to point fingers, but when I turn on -Dtransaction.debug trace, it will show
the stack trace of what caused the leak:

09/10/01 13:04:35 Thr[thread 5]-OrionCMTConnection.isClosed(): end---this.closed = false
09/10/01 13:04:35 Thr[thread 5]-OrionCMTConnection.isClosed(): end
09/10/01 13:04:35 Thr[thread 5]-OrionCMTConnection.finalize(): begin---this:: com.evermind.sql.OrionCMTConnectionFinalize@2dbcf0
 is NOT Closed
09/10/01 13:04:35 OrionCMTConnection not closed, check your code!
09/10/01 13:04:35 Logical connection not closed, check your code!
09/10/01 13:04:35 Created at:
09/10/01 13:04:35 java.lang.Throwable: OrionCMTConnection created
09/10/01 13:04:35       at com.evermind.sql.OrionCMTConnection.<init>(OrionCMTConnection.java:121)
09/10/01 13:04:35       at com.evermind.sql.OrionCMTConnectionFinalize.<init>(OrionCMTConnectionFinalize.java:42)
09/10/01 13:04:35       at com.evermind.util.ClassOptimizerFactory.getOrionCMTConnection(ClassOptimizerFactory.java:80)
09/10/01 13:04:35       at com.evermind.sql.OrionCMTDataSource.getConnection(OrionCMTDataSource.java:237)
09/10/01 13:04:35       at com.evermind.sql.OrionCMTDataSource.getConnection(OrionCMTDataSource.java:217)
09/10/01 13:04:35       at com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.init(JdbcTransaction.java:48)
09/10/01 13:04:35       at com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java:89)
09/10/01 13:04:35       at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithRowHandler(GeneralStatement.java:133)
09/10/01 13:04:35       at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryWithRowHandler(SqlMapExecutorDelegate.java:649)
09/10/01 13:04:35       at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryWithRowHandler(SqlMapSessionImpl.java:156)
09/10/01 13:04:35       at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryWithRowHandler(SqlMapClientImpl.java:133)
09/10/01 13:04:35       at model.persistence.dao.ApplicationDaoImpl.getUnderminedDetails(ApplicationDaoImpl.java:335)
09/10/01 13:04:35       at view.LOVCreator.contextInitialized(LOVCreator.java:52)
09/10/01 13:04:35       at com.evermind.server.http.HttpApplication.initDynamic(HttpApplication.java:1009)
09/10/01 13:04:35       at com.evermind.server.http.HttpApplication.<init>(HttpApplication.java:549)
09/10/01 13:04:35       at com.evermind.server.Application.getHttpApplication(Application.java:890)
09/10/01 13:04:35       at com.evermind.server.http.HttpServer.getHttpApplication(HttpServer.java:707)
09/10/01 13:04:35       at com.evermind.server.http.HttpSite.initApplications(HttpSite.java:625)
09/10/01 13:04:35       at com.evermind.server.http.HttpSite.setConfig(HttpSite.java:278)
09/10/01 13:04:35       at com.evermind.server.http.HttpServer.setSites(HttpServer.java:278)
09/10/01 13:04:35       at com.evermind.server.http.HttpServer.setConfig(HttpServer.java:179)
09/10/01 13:04:35       at com.evermind.server.ApplicationServer.initializeHttp(ApplicationServer.java:2394)
09/10/01 13:04:35       at com.evermind.server.ApplicationServer.setConfig(ApplicationServer.java:1551)
09/10/01 13:04:35       at com.evermind.server.ApplicationServerLauncher.run(ApplicationServerLauncher.java:92)
09/10/01 13:04:35       at java.lang.Thread.run(Thread.java:619)
09/10/01 13:04:35 Thr[thread 5]-OrionCMTConnection.close(): begin---this = com.evermind.sql.OrionCMTConnectionFinalize@2dbcf0
09/10/01 13:04:35 Thr[thread 5]-OrionCMTConnection.close(): begin
09/10/01 13:04:35 Thr[thread 5]-OrionCMTConnection.close(): begin---this.closed = false
09/10/01 13:04:35 Thr[thread 5]-OrionCMTConnection.close(): end---Already closed:: com.evermind.sql.OrionCMTConnectionFinalize@2dbcf0
09/10/01 13:04:35 Thr[thread 5]-OrionCMTConnection.finalize(): end


getUnderminedDetails is using a RowHandler if that makes any difference.

This is with IBATIS 2.3.0.677 (the latest one we can use against our current Java 1.4.2 Oracle
10G 10.1.2 Application Server).  The database is an Oracle 10gR2 instance as well.

Any help would be appreciated.  I tried stepping the code, and I'm just not clear as to what's
going on regarding the JdbcTransaction and how the connections are being started/ended automatically.

The SQLMapConfig.xml's tx entry looks like this:

    <transactionManager type="JDBC">
        <dataSource type="JNDI">
            <property name="DataSource" value="java:comp/env/jdbc/MyUserDS" />
        </dataSource>
    </transactionManager>

Thanks,

Eric

Eric Givler
Application Developer
Department of Environmental Protection/BIT
400 Market Street/3rd Floor
PO Box 8761
Harrisburg, PA 17105-8761
PH (717) 772-0138, FAX (717) 772-1676
egivler@state.pa.us<mailto:egivler@state.pa.us>




Mime
View raw message