Message Title

Binoy Shah created an issue

Issue Type:	Bug
Affects Versions:	5.1.2, 5.2.3
Assignee:	Unassigned
Components:	hibernate-core
Created:	09/Nov/2016 09:34 AM
Priority:	Minor
Reporter:	Binoy Shah

MySQL version - 5.7.15
Hibernate version - hibernate-core | 5.2.3.Final
Implementation - JPA 2.1

persistence.xml file

 
                                                                    <persistence-unit name="defaultPU" transaction-type="RESOURCE_LOCAL">
        <provider>org.hibernate.jpa.HibernatePersistenceProvider</provider>
        <non-jta-data-source>DefaultDS</non-jta-data-source>
        <shared-cache-mode>ENABLE_SELECTIVE</shared-cache-mode>
        <properties>
            <!--Hibernate properties-->
            <property name="hibernate.show_sql" value="true"/>
            <property name="hibernate.format_sql" value="true"/>
            <property name="hibernate.hbm2ddl.auto" value="update"/>
            <property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5InnoDBDialect" />
            <property name="hibernate.id.new_generator_mappings" value="false"/>
            <property name="hibernate.connection.CharSet" value="UTF-8"/>
            <property name="hibernate.connection.characterEncoding" value="utf8"/>
            <property name="hibernate.connection.useUnicode" value="true"/>

        </properties>
    </persistence-unit>
 
                                                            

 
                                                                @Entity
@Table(name = "CUSTOMER")
public class Customer {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "CUSTOMER_ACCOUNT_NUMBER")
    public Long customerAccountNumber;

    @Basic
    @Column(name = "CUSTOMER_ID", unique = true)
    public String customerId;

    @Basic
    @Column(name = "BILLING_ADDRESS")
    public String billingAddress;

    public Customer() {}
}
 
                                                            

During startup it generates following error in the logs

 
                                                                    alter table CUSTOMER 
        drop constraint UK_8eumjccoobf7t6psn9exu4gnh
Hibernate: 
    
    alter table CUSTOMER 
        add constraint UK_8eumjccoobf7t6psn9exu4gnh unique (CUSTOMER_ID)
[error] o.j.StatementLogger - java.sql.Statement.execute: 
    alter table CUSTOMER 
        drop constraint UK_8eumjccoobf7t6psn9exu4gnh;
throws exception: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'constraint UK_8eumjccoobf7t6psn9exu4gnh' at line 2
java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'constraint UK_8eumjccoobf7t6psn9exu4gnh' at line 2
        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:536)
        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:513)
        at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:115)
        at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:1983)
        at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:1936)
        at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:891)
        at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:795)
        at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:95)
        at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java)
        at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
[info] o.j.StatementLogger - java.sql.Statement.execute: 
    alter table CUSTOMER 
        add constraint UK_8eumjccoobf7t6psn9exu4gnh unique (CUSTOMER_ID);
 
                                                            

Add Comment

This message was sent by Atlassian JIRA