Re: Duplicate Key Problem

From: Christian Mittendorf (christian.mittendor..reenet.de)
Date: Thu Jul 13 2006 - 13:17:41 EDT

  • Next message: Andrus Adamchik: "Re: Duplicate Key Problem"

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



    This archive was generated by hypermail 2.0.0 : Thu Jul 13 2006 - 13:18:07 EDT