Re: Duplicate Key Problem

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Thu Jul 13 2006 - 13:15:05 EDT

  • Next message: Christian Mittendorf: "Re: Duplicate Key Problem"

    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."

    This archive was generated by hypermail 2.0.0 : Thu Jul 13 2006 - 13:15:50 EDT