[jira] [Created] (OPENJPA-2797) SynchronizedMapping does not detect existing sequence

["Christophe Noel (Jira)" <ji...@apache.org>]

Christophe Noel created OPENJPA-2797:
----------------------------------------

             Summary: SynchronizedMapping does not detect existing sequence
                 Key: OPENJPA-2797
                 URL: https://issues.apache.org/jira/browse/OPENJPA-2797
             Project: OpenJPA
          Issue Type: Bug
          Components: jdbc
    Affects Versions: 3.1.0
         Environment: TomEE 8.0, PostGreSQL 10
            Reporter: Christophe Noel


When doing the JDBC Synchronization, the existing sequence are not detected and an ReportingSQLException is reported.

The SequenceGenerator and column definition is shown below. Note that the database is PostGreSQL 10 and the tables/sequences are located in a dedicated YYY schema.

 
{code:java}
@Id
@SequenceGenerator(name="XXX_SEQUENCE",sequenceName="XXX_SEQ", initialValue=SequenceConstants.INITIAL_SEQUENCE_VALUE, schema = "YYY")
 @GeneratedValue(strategy = GenerationType.SEQUENCE, generator="XXX_SEQUENCE")
 @Column(name = "ID")
 private long id;{code}
 

Properties:

 
{code:java}
<property name="javax.persistence.schema-generation.database.action" value="create"/>
 <property name="openjpa.jdbc.SynchronizeMappings" value="buildSchema(ForeignKeys=true)"/>{code}
 

Exception reported:

 
{code:java}
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: ERROR: relation "xxx_seq" already exists {stmnt 392461001 CREATE SEQUENCE information_schema.XXX_SEQ START WITH 1000 INCREMENT BY 50} [code=0, state=42P07]
	at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219)
	at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:203)
	at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:58)
	at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingStatement.executeUpdate(LoggingConnectionDecorator.java:955)
	at org.apache.openjpa.lib.jdbc.DelegatingStatement.executeUpdate(DelegatingStatement.java:123)
	at org.apache.openjpa.jdbc.schema.SchemaTool.executeSQL(SchemaTool.java:1377)
	at org.apache.openjpa.jdbc.schema.SchemaTool.createSequence(SchemaTool.java:1137)
	at org.apache.openjpa.jdbc.schema.SchemaTool.buildSchema(SchemaTool.java:580)
	at org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java:562)
	at org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java:401)
	at org.apache.openjpa.jdbc.schema.SchemaTool.run(SchemaTool.java:373)
{code}
 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)