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 : <db-entity name="USERPROJECTS" catalog="pgi"> <db-attribute name="CREATIONDATE" type="TIMESTAMP" length="19"/> <db-attribute name="ID" type="INTEGER" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/> <db-attribute name="PGUSER" type="INTEGER" length="10"/> <db-attribute name="PROJECT" type="INTEGER" length="10"/> </db-entity> <obj-entity name="Userprojects" className="com.pgi.common.Userprojects" dbEntityName="USERPROJECTS"> <obj-attribute name="creationdate" type="java.util.Date" db-attribute-path="CREATIONDATE"/> <obj-attribute name="id" type="java.lang.Integer" db-attribute-path="ID"/> </obj-entity> Any ideas? John-
