openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Denis Nedelyaev (JIRA)" <j...@apache.org>
Subject [jira] Commented: (OPENJPA-756) Mapping tool fails with duplicate unique constraint on @Id field if @Column(unique=true)
Date Wed, 14 Oct 2009 07:28:31 GMT

    [ https://issues.apache.org/jira/browse/OPENJPA-756?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12765447#action_12765447
] 

Denis Nedelyaev commented on OPENJPA-756:
-----------------------------------------

1.2.1 is also affected.

> Mapping tool fails with duplicate unique constraint on @Id field if @Column(unique=true)
> ----------------------------------------------------------------------------------------
>
>                 Key: OPENJPA-756
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-756
>             Project: OpenJPA
>          Issue Type: Bug
>          Components: sql
>    Affects Versions: 2.0.0-M2
>         Environment: Derby, Oracle, possibly other DBs
>            Reporter: Jeremy Bauer
>            Priority: Minor
>
> The runtime mapping tool (openjpa.jdbc.SynchronizeMappings=buildSchema) fails to create
a table if the @Column annotation with unique=true attribute is specified on a field tagged
with @Id.  ex:
>     @Id
>     @Column(name="uniqueid", unique=true)
>     private int id;
> OpenJPA generates a unique constraint on the field along with the primary key constraint.
 Derby, Oracle, and possibly other databases fail with a message to the effect that  OpenJPA
is trying to create a duplicate constraint.  Primary keys are unique by definition so OpenJPA
should not create the unnecessary extra unique constraint.
> Here's an example of the failure using Derby:
> Constraints 'UNQ_' and 'SQL081030035840490' have the same set of columns, which is not
allowed.  {stmnt 2175170 CREATE TABLE UniqueIDEntity (uniqueid INTEGER NOT NULL, name VARCHAR(255),
PRIMARY KEY (uniqueid), CONSTRAINT UNQ_ UNIQUE (uniqueid))} [code=30000, state=42Z93]
> Some database may allow/require this behavior, so investigation will need to be done
to determine if there will be special handling for some databases vs. others.
> The simple workaround is to remove the unique attribute on an @Id column.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message