Safe, High performance, reuseable

Friday, September 19, 2008

JPA error: Attempt to update the sequence table "OPENJPA_SEQUENCE_TABLE" failed

OpenJPA uses OPENJPA_SEQUENCE_TABLE to generate primary keys for entities that use datastore identity or application identity with auto-generation strategy. The table is created automatically when persistence.xml configuration specifies to build the schema. The other option is to create the table directly via DDL CREATE TABLE openjpa_sequence_table (ID tinyint(4) NOT NULL, SEQUENCE_VALUE bigint(20) default NULL, PRIMARY KEY (ID))

http://www.oracle.com/technology/products/ias/toplink/jpa/howto/id-generation.html

No comments: