It seems like every transaction generates a rollback whether it's needed or not. Can this be turned off? The reason why - it generates errors when I do a delete.
See p6spy output: p6spy - 1057694346163|0|0|statement|DELETE FROM usertable WHERE user_id = ? |DELETE FROM usertable WHERE user_id = 'Oliver' p6spy - 1057694346163|0|0|rollback|| ERROR Date = 2003-07-08 15:59:06,163 [Thread-6] org.apache.ojb.broker.accesslayer.ConnectionManagerImpl Line = ? - Rollback on the underlying connection failed java.sql.SQLException: General error: Warning: Some non-transactional changed tables couldn't be rolled back According to http://www.mysql.com/doc/en/Non-transactional_tables.html, this error is caused by: If you get the error/warning: Warning: Some non-transactional changed tables couldn't be rolled back when trying to do a ROLLBACK, this means that some of the tables you used in the transaction didn't support transactions. These non-transactional tables will not be affected by the ROLLBACK statement. Snippet from repository: <jdbc-connection-descriptor platform="MySQL" jdbc-level="2.0" driver="com.p6spy.engine.spy.P6SpyDriver" protocol="jdbc" subprotocol="mysql" dbalias="//localhost:3306/someName" username="id" password="pwd" jcd-alias="default" default-connection="true" eager-release=false batch-mode="false" useAutoCommit="1" ignoreAutoCommitExceptions="false" > </jdbc-connection-descriptor> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
