commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dirk Verbeeck <>
Subject Re: FW: [DBCP] rollback not working with MySQL 4.1
Date Thu, 23 Jun 2005 05:59:58 GMT
Try the same test without using a pool to make sure MySQL is 
installed/configured correctly.
If the standalone version works then please post a complete unit test 
showing the problem using BDCP. (also include version number of DBCP/MySQL)

-- Dirk

Graeme wrote:
> Hi,
> I am having problems getting DBCP to rollback to work with MySQL.  Even
> though I create the PoolableConnectionFactory with the constructor’s
> parameter to create connection with defaultAutoCommit set to false
>   i.e. PoolableConnectionFactory poolableConnectionFactory = new
> PoolableConnectionFactory(connectionFactory,connectionPool,new
> StackKeyedObjectPoolFactory(),null,false,false);
> the program persists in committing after the execution of my INSERT
> statement.  I also tried using forcing the autocommit to false via the
> PoolableConnectionFactory’s setDefaultAutoCommit(false) method.  
> Has anybody successfully used DBCP transactions with a MySQL database?  
> Regards,
> Graeme

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message