Re: Duplicate Key Problem

[Andrus Adamchik]

Actually Cayenne transaction resets all connections to  
"autocommit=false" internally, so this shouldn't be an issue.

Andrus

On Jul 13, 2006, at 12:50 PM, Christian Mittendorf wrote:

Yes, it seems to behave differently and I think that our DB is
running with AUTOCOMMIT=1, which is the default setting:

"The correct way to use LOCK TABLES with transactional tables,
such as InnoDB tables, is to set AUTOCOMMIT = 0 and not to call
UNLOCK TABLES until you commit the transaction explicitly."