Not entirely sure this is a real issue yet, but starting to get quite
suspicious....
I have multiple child classes which inherit from a base class using a Joined
strategy. The sequence is defined in the base class and only in the base
class. I am seeing a 'Sequence already exists' message while running the unit
tests.
Anyone else seeing this or successfully using joined inheritance with sequence
generators with the 2.0 beta?
[Stack trace]
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Sequence already
exists in statement [CREATE SEQUENCE geoindex_idx_seq START WITH 1] {stmnt
1509237029 CREATE SEQUENCE example_seq START WITH 1} [code=-192, state=S1000]
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:254)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:70)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingStatement.executeUpdate(LoggingConnectionDecorator.java:944)
at
org.apache.openjpa.lib.jdbc.DelegatingStatement.executeUpdate(DelegatingStatement.java:136)
at
org.apache.openjpa.jdbc.schema.SchemaTool.executeSQL(SchemaTool.java:1200)
at
org.apache.openjpa.jdbc.schema.SchemaTool.createSequence(SchemaTool.java:976)
at org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java:461)
at org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java:348)
at org.apache.openjpa.jdbc.schema.SchemaTool.run(SchemaTool.java:325)
at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:504)
... 40 more
[Class heirarchy]
@Entity
@Table(name="base_table")
@Inheritance(strategy=InheritanceType.JOINED)
@DiscriminatorColumn(name="reference_type",
discriminatorType=DiscriminatorType.INTEGER)
public abstract class BaseClass {
// IDENTITY RELATED
@SequenceGenerator(name="Seq_Example_Gen", sequenceName="example_seq")
@Id @Column(name="my_index")
@GeneratedValue(generator="Seq_Example_Gen", strategy=GenerationType.SEQUENCE)
private long id;
public long getId() { return id; }
public void setId(long id) { this.id = id; }
... et cetera ...
}
@Entity
@Table(name="child_table_one")
@DiscriminatorValue("1")
public class ChildClassOne extends BaseClass implements Serializable {
... et cetera ...
}
@Entity
@Table(name="child_table_two")
@DiscriminatorValue("2")
public class ChildClassTwo extends BaseClass implements Serializable {
... et cetera ...
}
