commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dirk Verbeeck <dirk.verbe...@pandora.be>
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: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org


Mime
View raw message