AUTO_PK_SUPPORT, mysql and join tables

From: John Armstrong (siberia..iberian.org)
Date: Sun Mar 28 2010 - 02:43:08 EDT

  • Next message: Andrus Adamchik: "Re: AUTO_PK_SUPPORT, mysql and join tables"

    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-

    This archive was generated by hypermail 2.0.0 : Sun Mar 28 2010 - 02:43:52 EDT