Hi, I have some classes configured with JPA2 annotations. They work fine with PostgreSQL, but unit testing with H2 gives the following error message:
Caused by: org.h2.jdbc.JdbcSQLException: Attempt to define a second primary key; SQL statement: create table concepts (concept_id integer not null, concept_type varchar(255), created timestamp, created_by integer, definition varchar(255), deprecated timestamp, deprecated_by i nteger, editorial_note varchar(255), external_id serial, modified timestamp, modified_by integer, note varchar(255), replaced_by integer, scope_note varchar(255), used_by_libs varc har(255), vocab_id varchar(255), primary key (concept_id)) [90017-196] I can't see anything wrong with the SQL statement, which has been automatically generated. Any ideas? Best regards, Erik -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
