cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From John Armstrong <>
Subject AUTO_PK_SUPPORT, mysql and join tables
Date Sun, 28 Mar 2010 06:43:08 GMT
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

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"/>
<obj-entity name="Userprojects" className="com.pgi.common.Userprojects"
<obj-attribute name="creationdate" type="java.util.Date"
<obj-attribute name="id" type="java.lang.Integer" db-attribute-path="ID"/>

Any ideas?


  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message