Re: Sequoia, Cayenne, MySql 5 with AUTO_PK_SUPPORT

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Fri Aug 18 2006 - 09:49:22 EDT

  • Next message: Andrus Adamchik (JIRA): "[JIRA] Created: (CAY-632) RefreshQuery - a common mechanism for object and object list invalidation"

    Custom PkGenerator can be a solution now.

    Also we discussed an "optimistic" pk generator some time back:

    http://objectstyle.org/cayenne/lists/cayenne-user/2006/07/0067.html

    Andrus

    On Aug 18, 2006, at 5:24 AM, Tobias SCHOESSLER wrote:

    > I am trying to get Cayenne 1.2 work with Sequoia ( former CJDB
    > http://sequoia.continuent.org ) with MySql 5.
    >
    > Sequoia is implementing a clustered JDBC Driver which is
    > broadcasting all
    > JDBC traffic to a cluster of connected databases.
    >
    > We are using AUTO_PK_SUPPORT of cayenne because we like the database
    > independency of the solution and would like to keep using this in
    > this set
    > up.
    >
    > Unfortunately Sequoia seems to have problems with the
    >
    > LOCK TABLES AUTO_PK_SUPPORT WRITE
    >
    > commands Cayenne's MySql Adapter is firing when retrieving new IDs
    > from the
    > AUTO_PK_SUPPORT TABLE. I could not verify that this is a known
    > issue with
    > Sequoia and MySql yet.
    >
    > I wondered if there is a way around these LOCK TABLES - why is not a
    > transaction used to retrieve the IDs like in the Sybase adapter?
    >
    > Has someone experience with a similar set up?
    >
    >



    This archive was generated by hypermail 2.0.0 : Fri Aug 18 2006 - 09:49:47 EDT