"ERROR: ORA-00911: invalid character " for create tables by Hibernate JPA

Question

I want create two tables with Hibernate JPA . I use Oracle 11g and JDBC 6 & 7 (Because I'm not sure which one is suitable for 11g :) ).

my library : hibernate-release-4.2.0.Final & hibernate-jpa-2.0-api-1.0.1 & Tomcat-8 lib & JDK 1.8.0-172

I create two Entities but when I run the program , the tables are not created and present this error :

Nov 12, 2018 10:15:35 AM org.hibernate.tool.hbm2ddl.SchemaExport perform
ERROR: HHH000389: Unsuccessful: create table "PICTURE" ("PID" `NUMBER` not null, " CAPTION " `LONG `, " LIKES_COUNTER " ` NUMBER `, " PIC_ADRESS " `     NVARCHAR2(50) ` not null,  FK_USERS `NUMBER`, primary key ("PID"))
Nov 12, 2018 10:15:35 AM org.hibernate.tool.hbm2ddl.SchemaExport perform
ERROR: ORA-00911: invalid character

Nov 12, 2018 10:15:35 AM org.hibernate.tool.hbm2ddl.SchemaExport perform
ERROR: HHH000389: Unsuccessful: create table "USERS" ("UID" `NUMBER` not null, " EMAIL " ` NVARCHAR2(40)` not null, " USER_PASSWORD " ` NVARCHAR2(32)` not null, " USER_SEX " ` NVARCHAR2(20)`, " UPICADD " ` NVARCHAR2(50)`, " USERNAME " ` NVARCHAR2(30)` not null, primary key ("UID"))
Nov 12, 2018 10:15:35 AM org.hibernate.tool.hbm2ddl.SchemaExport perform
ERROR: ORA-00911: invalid character

I run these queries directly on SQL PLUS for testing. Tables were created correctly. even when I used <property name="hibernate.hbm2ddl.auto" value="create-drop"/> , The tables that I created directly , dropped but weren't rebuilt.

my entities :

@Entity (name = "person")
@Table(name = "USERS")
@EntityListeners(value = PersonManager.class)
public class Person implements Serializable
{
    @Id 
    @Column(name="UID" ,columnDefinition = "NUMBER" )
    @SequenceGenerator(name = "mySeq" , sequenceName = "DB_MYSEQ")
    @GeneratedValue(strategy=GenerationType.AUTO ,generator="mySeq")
    private long uId;

//--------define relation------

    @OneToMany(cascade = CascadeType.ALL , fetch = FetchType.EAGER)
    @JoinColumn(name = " FK_USERS" )
    private List<Pictures> picturesList;

    @Basic
    @Column (name = " USERNAME " , columnDefinition = " NVARCHAR2(30)" , nullable = false )
    private String username ;

    @Basic
    @Column (name = " USER_PASSWORD " , columnDefinition = " NVARCHAR2(32)" , nullable = false )
    private String  password ;

    @Basic
    @Column (name = " EMAIL " , columnDefinition = " NVARCHAR2(40)" , nullable = false)
    private String email;

    @Basic // user picture for profile
    @Column (name = " UPICADD " , columnDefinition = " NVARCHAR2(50)" )
    private String userPic;

    @Basic
    @Column (name = " USER_SEX " , columnDefinition = " NVARCHAR2(20)")
    private String sex ;


    public Person(String username, String password, String email ,String sex, String userPic ) {
       this.picturesList = picturesList;
       this.sex = sex;
       this.userPic = userPic;
       this.email = email;
       this.password = password;
       this.username = username;
    }

   //--------------------------------------------------------

    public void setUsername(String username) {
       this.username = username;
    }

    public void setPassword(String password) {
       this.password = password;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    public void setUserPic(String userPic) {
        this.userPic = userPic;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public void setuId(long uId) {this.uId = uId;}
    public void setPicturesList(List<Pictures> picturesList) {
        this.picturesList = picturesList;
    }


//--------------------------------------------------------

    public String getUsername() {
       return username;
   }

    public String getPassword() {
       return password;
    }

    public String getUserPic() {
        return userPic;
    }

    public String getEmail() {
        return email;
    }

     public String getUser_Sex() {
        return sex;
   }
    public long getuId() {return uId;}

     public List<Pictures> getPicturesList() {
        return picturesList;
    }
}

and

 @Entity(name = "picture")
 @Table(name = "PICTURE")

public class Pictures implements Serializable
{
@Id // create id and fill auto by sequence in database
@Column(name="PID" ,columnDefinition = "NUMBER" )
@SequenceGenerator(name = "mySeq2" , sequenceName = "DB_MYSEQ2")
@GeneratedValue(strategy=GenerationType.AUTO ,generator="mySeq2")
private long pId;


@Basic
@Column (name = "PICADRESS" , columnDefinition = "NVARCHAR2(50)" , nullable = false)
private String  picAdress ;

@Basic
@Column (name = "CAPTION" , columnDefinition = "LONG")
private String caption;

@Basic 
@Column (name = "LIKE_COUNTER" , columnDefinition = "NUMBER")
private int likes;

//--------------------------------------------------------
public Pictures(){}

public Pictures( String picAdress, String caption, int likes) {
    this.picAdress = picAdress;
    this.caption = caption;
    this.likes = likes;
}
//--------------------------------------------------------

public void setPid(long pid) {
    this.pId = pid;
}

public void setLikes(int likes) {
    this.likes = likes;
}

public void setPicAdress(String picAdress) {
    this.picAdress = picAdress;
}

public void setCaption(String caption) {
    this.caption = caption;
}

//--------------------------------------------------------

public int getLikes() {
    return likes;
}

public String getCaption() {
    return caption;
}

public String getPicAdress() {
    return picAdress;
}

public long getPid() {
    return pId;
}
}

and persistence.xml :

<persistence-unit name="MyConnection" transaction-type="RESOURCE_LOCAL">
    <provider>org.hibernate.ejb.HibernatePersistence</provider>
    <properties>
        <property name="hibernate.dialect" value="org.hibernate.dialect.Oracle10gDialect"/>
        <property name="hibernate.connection.driver_class" value="oracle.jdbc.driver.OracleDriver"/>
        <property name="hibernate.connection.username" value="midas"/>
        <property name="hibernate.connection.password" value="midas123"/>
        <property name="hibernate.connection.url" value="jdbc:oracle:thin:@localhost:1521:orcl"/>
        <property name="hibernate.hbm2ddl.auto" value="create"/>
        <property name="show_sql" value="true"></property>
        <property name="hibernate.globally_quoted_identifiers" value="true"/>
    </properties>
</persistence-unit>

How can I fix it?

Answer 1

I finally discovered the problem. this property <property name="hibernate.globally_quoted_identifiers" value="true"/> in persistence.xml , add single Quotation for any data_type instead of name column!

I deleted it and solved problem. :)