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?
