Never mind - everything works "as advertised"! I was changing mapping files,
but not actualy using them (conf files were outside web app in another maven
module) - shame on me. :-(
2008/11/4 Borut Bolčina <borut.bolcina@gmail.com>
> Hello,
>
> I am doing something wrong as Cayenne is trying to use auto_pk_suport table
> although I specified PK Generation Strategy to Database generated on User
> and Role db entities. There is a join db entity (UserRole) with default
> strategy, but i guess this is supposed to be set to default as one can not
> select both foreign keys (userId, roleId). I am using mysql.
>
> This happens when first trying to insert a record:
> [INFO] access.QueryLogger LOCK TABLES AUTO_PK_SUPPORT WRITE
> [INFO] access.QueryLogger UNLOCK TABLES
> 2008-11-04 14:40:20.585::WARN: /iopenid-webapp/j_spring_security_check
> org.apache.cayenne.CayenneRuntimeException: [v.3.0M4 May 28 2008 23:57:15]
> Commit Exception
> at
> org.apache.cayenne.access.DataContext.flushToParent(DataContext.java:1192)
> at
> org.apache.cayenne.access.DataContext.commitChanges(DataContext.java:1066)
> Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table
> 'iopenid.auto_pk_support' doesn't exist
>
> Mapping file:
> <?xml version="1.0" encoding="utf-8"?>
> <data-map project-version="3.0">
> <property name="defaultPackage" value="com.interseek.iopenid.model"/>
> <property name="defaultSchema" value="iopenid"/>
> <db-entity name="Role" schema="iopenid">
> <db-attribute name="authority" type="VARCHAR" isMandatory="true"
> length="200"/>
> <db-attribute name="id" type="INTEGER" isPrimaryKey="true"
> isGenerated="true" isMandatory="true"/>
> </db-entity>
> <db-entity name="User" schema="iopenid">
> <db-attribute name="id" type="INTEGER" isPrimaryKey="true"
> isGenerated="true" isMandatory="true"/>
> <db-attribute name="username" type="VARCHAR" isMandatory="true"
> length="32"/>
> </db-entity>
> <db-entity name="UserRole" schema="iopenid">
> <db-attribute name="roleId" type="INTEGER" isPrimaryKey="true"
> isMandatory="true"/>
> <db-attribute name="userId" type="INTEGER" isPrimaryKey="true"
> isMandatory="true"/>
> </db-entity>
> <obj-entity name="Role" className="com.interseek.iopenid.model.Role"
> dbEntityName="Role">
> <obj-attribute name="authority" type="java.lang.String"
> db-attribute-path="authority"/>
> </obj-entity>
> <obj-entity name="User" className="com.interseek.iopenid.model.User"
> dbEntityName="User">
> <obj-attribute name="username" type="java.lang.String"
> db-attribute-path="username"/>
> </obj-entity>
> <db-relationship name="toUserRole" source="Role" target="UserRole"
> toDependentPK="true" toMany="true">
> <db-attribute-pair source="id" target="roleId"/>
> </db-relationship>
> <db-relationship name="toUserRole" source="User" target="UserRole"
> toDependentPK="true" toMany="true">
> <db-attribute-pair source="id" target="userId"/>
> </db-relationship>
> <db-relationship name="toRole" source="UserRole" target="Role"
> toMany="false">
> <db-attribute-pair source="roleId" target="id"/>
> </db-relationship>
> <db-relationship name="toUser" source="UserRole" target="User"
> toMany="false">
> <db-attribute-pair source="userId" target="id"/>
> </db-relationship>
> <obj-relationship name="toUserRole" source="Role" target="User"
> db-relationship-path="toUserRole.toUser"/>
> <obj-relationship name="toUserRole" source="User" target="Role"
> db-relationship-path="toUserRole.toRole"/>
> </data-map>
>
> Please advise,
> Borut
>
> 2008/7/16 Andrus Adamchik <andrus@objectstyle.org>
>
> Yes, auto increment flags are added to PK columns by Cayenne. Just set "PK
>> Generation Strategy" for each entity in question to "Database Generated".
>>
>> Andrus
>>
>>
>> On Jul 16, 2008, at 9:53 AM, Borut Bolčina wrote:
>>
>> Hello,
>>>
>>> is it possible to generate AUTO_INCREMENT with MySQLDbAdapter when
>>> running
>>> DbGenerator via API?
>>>
>>> The goal is to use auto_increment instead of AUTO_PK_SUPPORT table.
>>>
>>> Regards,
>>> Borut
>>>
>>
>>
>
This archive was generated by hypermail 2.0.0 : Wed Nov 05 2008 - 04:38:49 EST