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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
