1) Test case 1 - Without OPENJPA_SEQUENCE_TABLE
I don't have this error anymore after deleting the H2 database used for my
example : jdbc:h2:tcp://localhost/~/reportdb
and removing the OPENJPA_SEQUENCE_TABLE that I created previously
Now I see that H2 has created a :
SYSTEM_SEQUENCE_6FC4CBE2_C5C1_48C9_B049_E669E21304D2 which is well
incremented everytime a new record is created
2) Test Case 2 - OPENJPA_SEQUENCE_TABLE
If I use this Sequence Table, then I get the error reported :
CREATE TABLE REPORT.OPENJPA_SEQUENCE_TABLE (
ID BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL
PRIMARY KEY,
SEQUENCE_VALUE BIGINT NOT NULL
);
Unfortunately, even if I set org.apache.openjpa to DEBUG/TRACE level, I
didn't get more info in the stacktrace :
https://gist.github.com/cmoulliard/80d65124c118db2f4737
Here is the persistence config file :
<properties>
<property name="openjpa.jdbc.SynchronizeMappings"
value="buildSchema(SchemaAction='add,deleteTableContents')"/>
<property name="openjpa.Log"
value="DefaultLevel=TRACE, Runtime=TRACE, Tool=TRACE,
SQL=TRACE"/>
<property name="openjpa.jdbc.DBDictionary"
value="h2(useSchemaName=true)"/>
<property name="openjpa.jdbc.Schema"
value="REPORT"/>
</properties>
BTW, I have discovered (probably related how H2 works and when we use
@GeneratedValue(strategy=GenerationType.AUTO)) that sometimes it uses
SEQUENCE SYSTEM and sometimes OPENJPA_SEQUENCE_TABLE
--
View this message in context:
http://openjpa.208410.n2.nabble.com/Issue-with-OPENJPA-SEQUENCE-TABLE-tp7585016p7585029.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.
