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?
