Hibernate Automatic Update table error building table or adding columns, prompting for invalid identifiers

such as an error in the Oracle database:

CREATE TABLE Db_meta_web.user (ID varchar2 (255 char) NOT NULL, account VARCHAR2 (255 char), Department VARCHAR2 (255 Char), Email varchar2 (255 char), mobile varchar2 (255 char), name VARCHAR2 (255 char), password varchar2 (255 char), PRIMARY key (ID ))

The table name user and field name password fields Here are reserved keywords, so the error identifier is invalid.

In this case, you need to put the DDL statement in the Database Connection tool, with the corresponding identifiers quoted in the database, such as MySQL is ', Oracle is '. To run it yourself, you need to note that the field is case-sensitive and the field name you define is consistent.

For the above example, the DDL statement should read:

CREATE TABLE Db_meta_web. " USER "(ID varchar2 (255 char) NOT NULL, account VARCHAR2 (255 char), Department VARCHAR2 (255 Char), email varchar2 (255 char) , Mobile VARCHAR2 (255 char), name VARCHAR2 (255 char), "PASSWORD" varchar2 (255 char), primary key (ID))

Hibernate Automatic Update table error building table or adding columns, prompting for invalid identifiers