运用hibernate自动建表报错

0 0

运用hibernate自动建表报错5

运用hibernate自动建表报错如下:

org.hibernate.tool.hbm2ddl.SchemaUpdate - Unsuccessful: create table showcase@localhost.t_auth_privilege (sid bigint not null auto_increment, acl_code varchar(20), acl_type varchar(16), create_by varchar(64), create_dt datetime, updated_by varchar(64), updated_dt datetime, version integer not null, category varchar(128) not null, code varchar(64) not null unique, description longtext, name longtext not null, order_rank integer, state varchar(32) not null, type varchar(128) not null, url longtext, primary key (sid))
org.hibernate.tool.hbm2ddl.SchemaUpdate - 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 '@localhost.t_auth_privilege (sid bigint not null auto_increment, acl_code varcha' at line 1
org.hibernate.tool.hbm2ddl.SchemaUpdate - Unsuccessful: create table showcase@localhost.t_auth_role (sid bigint not null auto_increment, acl_code varchar(20), acl_type varchar(16), create_by varchar(64), create_dt datetime, updated_by varchar(64), updated_dt datetime, version integer not null, code varchar(64) not null unique, description longtext, locked_flag char(1), name longtext not null, state varchar(32) not null, primary key (sid))
org.hibernate.tool.hbm2ddl.SchemaUpdate - 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 '@localhost.t_auth_role (sid bigint not null auto_increment, acl_code varchar(20)' at line 1
org.hibernate.tool.hbm2ddl.SchemaUpdate - Unsuccessful: create table showcase@localhost.t_auth_role_r2_privilege (sid bigint not null auto_increment, acl_code varchar(20), acl_type varchar(16), create_by varchar(64), create_dt datetime, updated_by varchar(64), updated_dt datetime, version integer not null, privilege_sid bigint not null, role_sid bigint not null, primary key (sid), unique (privilege_sid, role_sid))
org.hibernate.tool.hbm2ddl.SchemaUpdate - 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 '@localhost.t_auth_role_r2_privilege (sid bigint not null auto_increment, acl_cod' at line 1
org.hibernate.tool.hbm2ddl.SchemaUpdate - Unsuccessful: create table showcase@localhost.t_auth_user (sid bigint not null auto_increment, acl_code varchar(20), acl_type varchar(16), create_by varchar(64), create_dt datetime, updated_by varchar(64), updated_dt datetime, version integer not null, email varchar(30), enabled bit, home_phone varchar(30), mobile_phone varchar(30), office_phone varchar(30), password longtext not null, user_id varchar(30) not null, user_name varchar(100) not null, user_pin varchar(50) not null, primary key (sid), unique (user_pin), unique (acl_code, user_id))
org.hibernate.tool.hbm2ddl.SchemaUpdate - 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 '@localhost.t_auth_user (sid bigint not null auto_increment, acl_code varchar(20)' at line 1
org.hibernate.tool.hbm2ddl.SchemaUpdate - Unsuccessful: create table showcase@localhost.t_auth_user_r2_role (sid bigint not null auto_increment, acl_code varchar(20), acl_type varchar(16), create_by varchar(64), create_dt datetime, updated_by varchar(64), updated_dt datetime, version integer not null, role_sid bigint not null, user_sid bigint not null, primary key (sid), unique (user_sid, role_sid))
org.hibernate.tool.hbm2ddl.SchemaUpdate - 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 '@localhost.t_auth_user_r2_role (sid bigint not null auto_increment, acl_code var' at line 1
org.hibernate.tool.hbm2ddl.SchemaUpdate - Unsuccessful: alter table showcase@localhost.t_auth_role_r2_privilege add index FKF4F7A1AFD0169CF5 (role_sid), add constraint FKF4F7A1AFD0169CF5 foreign key (role_sid) references showcase@localhost.t_auth_role (sid)
org.hibernate.tool.hbm2ddl.SchemaUpdate - 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 '@localhost.t_auth_role_r2_privilege add index FKF4F7A1AFD0169CF5 (role_sid), add' at line 1
org.hibernate.tool.hbm2ddl.SchemaUpdate - Unsuccessful: alter table showcase@localhost.t_auth_role_r2_privilege add index FKF4F7A1AF162A0A37 (privilege_sid), add constraint FKF4F7A1AF162A0A37 foreign key (privilege_sid) references showcase@localhost.t_auth_privilege (sid)
org.hibernate.tool.hbm2ddl.SchemaUpdate - 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 '@localhost.t_auth_role_r2_privilege add index FKF4F7A1AF162A0A37 (privilege_sid)' at line 1
org.hibernate.tool.hbm2ddl.SchemaUpdate - Unsuccessful: alter table showcase@localhost.t_auth_user_r2_role add index FKBBCB50DD0169CF5 (role_sid), add constraint FKBBCB50DD0169CF5 foreign key (role_sid) references showcase@localhost.t_auth_role (sid)
org.hibernate.tool.hbm2ddl.SchemaUpdate - 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 '@localhost.t_auth_user_r2_role add index FKBBCB50DD0169CF5 (role_sid), add const' at line 1
org.hibernate.tool.hbm2ddl.SchemaUpdate - Unsuccessful: alter table showcase@localhost.t_auth_user_r2_role add index FKBBCB50DD019C11F (user_sid), add constraint FKBBCB50DD019C11F foreign key (user_sid) references showcase@localhost.t_auth_user (sid)
org.hibernate.tool.hbm2ddl.SchemaUpdate - 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 '@localhost.t_auth_user_r2_role add index FKBBCB50DD019C11F (user_sid), add const' at line 1

数据库是mysql
问题出在"create table showcase@localhost.t_auth_privilege "showcase是数据库用户名
但是不知道怎么改求解。。。