Re: Build failed in Hudson: Cayenne-trunk h2,JDK 1.5 (latest),Ubuntu #372

From: Michael Gentry (mgentr..asslight.net)
Date: Tue Oct 05 2010 - 13:53:58 UTC

  • Next message: Michael Gentry: "Re: Build failed in Hudson: Cayenne-trunk h2,JDK 1.5 (latest),Ubuntu #372"

    One issue it is failing with:

    SEVERE: Error generating schema...
    org.h2.jdbc.JdbcSQLException: Attempt to define a second primary key;
    SQL statement:
    CREATE TABLE GENERATED_COLUMN_COMP_KEY (AUTO_PK INTEGER NOT NULL,
    GENERATED_COLUMN INTEGER NOT NULL AUTO_INCREMENT, NAME VARCHAR(100)
    NULL, PROPAGATED_PK INTEGER NOT NULL, PRIMARY KEY (AUTO_PK,
    GENERATED_COLUMN, PROPAGATED_PK)) [90017-64]

    The test map has the following:

     <db-entity name="GENERATED_COLUMN_COMP_KEY">
             <db-attribute name="AUTO_PK" type="INTEGER"
    isPrimaryKey="true" isMandatory="true"/>
             <db-attribute name="GENERATED_COLUMN" type="INTEGER"
    isPrimaryKey="true" isGenerated="true" isMandatory="true"/>
             <db-attribute name="NAME" type="VARCHAR" length="100"/>
             <db-attribute name="PROPAGATED_PK" type="INTEGER"
    isPrimaryKey="true" isMandatory="true"/>
     </db-entity>

    I'm guessing that H2 doesn't allow multiple/compound PKs if one of
    them is autogenerated. Thoughts?

    Thanks,

    mrg



    This archive was generated by hypermail 2.0.0 : Tue Oct 05 2010 - 13:54:51 UTC