[jira] Created: (OPENJPA-1788) Problem in Firebird 2.1 with sequence creation

[Diego Cattelan (JIRA)]

Problem in Firebird 2.1  with sequence creation
-----------------------------------------------

                 Key: OPENJPA-1788
                 URL: https://issues.apache.org/jira/browse/OPENJPA-1788
             Project: OpenJPA
          Issue Type: Bug
          Components: jdbc
    Affects Versions: 2.0.1
         Environment: FirebirdSQL 2.1.3
jaybird 2.1.6
            Reporter: Diego Cattelan


Create a simple entity

@Entity
public class ana_anagrafica implements Serializable {
    private static final long serialVersionUID = 1L;

    private Long id;

    @SequenceGenerator(name="ANA_ANAGRAFICA_GEN")
    @Id
    @GeneratedValue(strategy = 
GenerationType.SEQUENCE,generator="ANA_ANAGRAFICA_GEN")
    public Long getId() {
        return id;
    }

    public void setId(Long id) {
        this.id = id;
    }
} 

in the sequence creation the SQL returned from FirebirdDictionary is wrong,
method

@Override
    protected String getSequencesSQL(DBIdentifier schemaName, DBIdentifier 
sequenceName) {
        StringBuilder buf = new StringBuilder(sequenceSQL);
        if (sequenceName != null)
            buf.append(sequenceNameSQL);
        return buf.toString();
    } 

should be

@Override
    protected String getSequencesSQL(DBIdentifier schemaName, DBIdentifier 
sequenceName) {
        StringBuilder buf = new StringBuilder(sequenceSQL);
        if(!DBIdentifier.isNull(sequenceName)){
            buf.append(sequenceNameSQL);
        }
        return buf.toString();
    } 

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.