[ https://issues.apache.org/jira/browse/DBCP-417?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Phil Steitz resolved DBCP-417. ------------------------------ Resolution: Fixed Patch committed in r1592132 > BasicManagedDataSource does not free connection after transaction is commited > ----------------------------------------------------------------------------- > > Key: DBCP-417 > URL: https://issues.apache.org/jira/browse/DBCP-417 > Project: Commons Dbcp > Issue Type: Bug > Affects Versions: 2.0 > Environment: Geronimo TM and JOTM, H2Database JDBC Driver > Reporter: Balazs Zsoldos > Priority: Blocker > Fix For: 2.0.1 > > Attachments: DBCP-417.patch, test-dbcp2-BasicManagedDataSource.zip > > > When a JTA Transaction is commited, the Managed connection is not available > again. The pool is becomes exhausted. > To reproduce: > {code:java} > Jotm jotm = new Jotm(true, false); > JdbcDataSource h2DataSource = new JdbcDataSource(); > h2DataSource.setUrl("jdbc:h2:mem:test_mem"); > BasicManagedDataSource basicManagedDataSource = new BasicManagedDataSource(); > basicManagedDataSource.setTransactionManager(jotm.getTransactionManager()); > basicManagedDataSource.setXaDataSourceInstance(h2DataSource); > basicManagedDataSource.setMaxTotal(2); > basicManagedDataSource.setMaxIdle(2); > UserTransaction userTransaction = jotm.getUserTransaction(); > userTransaction.begin(); > Connection connection = basicManagedDataSource.getConnection(); > connection.close(); > userTransaction.commit(); > userTransaction.begin(); > connection = basicManagedDataSource.getConnection(); > connection.close(); > userTransaction.commit(); > // The managed datasource will block here as there is no available connection > userTransaction.begin(); > connection = basicManagedDataSource.getConnection(); > connection.close(); > userTransaction.commit(); > {code} > Set the priority to Blocker as BasicManagedDataSource cannot be used at all > with the bug. > Tested with Geronimo Transaction Manager and JOTM. > This worked well with version 1.4. -- This message was sent by Atlassian JIRA (v6.2#6252)