[jira] [Created] (OFBIZ-7346) connection pooling not working

["Gareth Carter (JIRA)" <ji...@apache.org>]

Gareth Carter created OFBIZ-7346:
------------------------------------

             Summary: connection pooling not working
                 Key: OFBIZ-7346
                 URL: https://issues.apache.org/jira/browse/OFBIZ-7346
             Project: OFBiz
          Issue Type: Bug
          Components: ALL COMPONENTS
    Affects Versions: Trunk
            Reporter: Gareth Carter
            Priority: Minor


Connection pooling does not seem to work. Connections are created fine but as the close() method is called (outside of transaction) or the transaction is committed the connections are closed to the db server and not returned to the pool.

I believe the issue is with org.apache.commons.dbcp2.PoolableConnectionFactory passivateObject method. This will call rollback() when rollbackOnReturn is set to true even if the transaction is committed. This is because any connection wrappers extending org.apache.commons.dbcp2.DelegatingConnection cache autoCommit status. At some point, this cached autoCommit is different from the underlying connection autoCommit. The rollback() method will throw an exception and the connection is destroyed rather than put back to the pool



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)