Puhhh... good to know ;-)
Am 13.07.2006 um 19:15 schrieb 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."
