Rollback Causes Errors

["Brown, Melonie S. - Contractor" <Me...@forscom.army.mil>]

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: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org