Hi Joe, Your wording on #2 and #3 was a little curious to me. I don't know if you used Cayenne Modeler to generate your schema or if you are using an existing schema. Cayenne (at runtime) doesn't really instruct the database (MySQL) to auto-generate keys. Cayenne will nont provide a value for "oid" when inserting the record and that essentially instructs MySQL to auto-generate a key. You set this up when you create your product table, for example. The database needs to know that it is responsible for auto-generating the keys -- Cayenne won't tell it at runtime (other than leaving the key out on insert).
Maybe I'm a bit off on what you were asking, but it seems like you are expecting Cayenne to tell MySQL to generate the keys when it actually works the other way around: MySQL is supposed to know to generate the key and Cayenne then asks it for the key it generated. mrg PS. BTW, your settings are correct to use the auto-generated key feature in MySQL, just be sure the table was created to auto-generate on your "oid" column. On Mon, Apr 19, 2010 at 8:03 PM, Joe Baldwin <[email protected]> wrote: > I apologize for this, but I am being forced to verify a configuration that is > pretty obvious. > > Please refer to the attached CM configuration panel for an Entity. > > 1. The Primary Key "PK Generation Strategy" is set to "Database-Generated". > Please verify that this means that the PK Generation Strategy is Database > Generated. > 2. The Primary Key "Auto Increment" is set to "oid (INTEGER)". Please verify > that the field being auto-incremented is "oid". > 3. Please verify that (with the DBMS set to MySQL) that the two previous > parameters instruct MySQL to use its auto_increment feature to create a new > "oid" value for inserted records. > > Thanks > Joe > > >
