Re: AUTO_PK_SUPPORT, mysql and join tables

2010-03-28 Thread Andrus Adamchik
Cool. Also I just committed the fix per https://issues.apache.org/jira/browse/CAY-1409 . On Mar 28, 2010, at 10:06 PM, John Armstrong wrote: Thanks Andrus! I have worked around it for now by populating the AUTO_PK_TABLE as required so Cayenne can lock and unlock it (in case anyone else is

Re: AUTO_PK_SUPPORT, mysql and join tables

2010-03-28 Thread John Armstrong
Thanks Andrus! I have worked around it for now by populating the AUTO_PK_TABLE as required so Cayenne can lock and unlock it (in case anyone else is having this problem). John- On Sun, Mar 28, 2010 at 12:00 PM, Andrus Adamchik wrote: > I just wrote a unit test, and it looks like indeed in the c

Re: AUTO_PK_SUPPORT, mysql and join tables

2010-03-28 Thread Andrus Adamchik
I just wrote a unit test, and it looks like indeed in the case of a flattened relationship with "Database-generated" PK, AUTO_PK_TABLE is accessed, although after that Cayenne does the right thing and builds a query based on an auto-incremented PK, ignoring what's returned from AUTO_PK_TABL

Re: AUTO_PK_SUPPORT, mysql and join tables

2010-03-28 Thread John Armstrong
Hi Andrus, I downgraded to 3.0M6 from RC2 a few weeks ago to troubleshoot some problems. I tested this in both M6 and RC2 with the same results. I have a few other join tables that are similar and exhibit the same behavior. Tx! J Tthe flattened relationship is defined as :

Re: AUTO_PK_SUPPORT, mysql and join tables

2010-03-28 Thread Andrus Adamchik
Odd. Join table with its own (non-propagated) PK should work the same as any other table. Which vesrion of Cayenne is this and are you using flattened relationships across the join table? Andrus On Mar 28, 2010, at 9:43 AM, John Armstrong wrote: Hi all, I am using mysql with all database

AUTO_PK_SUPPORT, mysql and join tables

2010-03-27 Thread John Armstrong
Hi all, I am using mysql with all database generated pks and auto_increment. This works fine for all tables except join tables. When accessing a join table cayenne tries to access the AUTO_PK_TABLE rather then relying on the auto_increment. My join tables are configured identically :