xautlx / s2jh

A Java/J2EE development framework for enterprise system based on Struts/Spring/JPA/Hibernate and jquery/bootstrap
GNU Lesser General Public License v3.0
321 stars 242 forks source link

t_auth_user 在oracle下有问题 原因 uid是oracle关键字 #64

Closed xiaolongyuan closed 10 years ago

xiaolongyuan commented 10 years ago

create table t_auth_user ( sid number(19,0) not null, acl_code varchar2(20 char), acl_type varchar2(255 char), created_by varchar2(255 char), created_dt timestamp, updated_by varchar2(255 char), updated_dt timestamp, version number(10,0), account_expire_time timestamp, account_non_locked char(1 char), credentials_expire_time timestamp, email varchar2(128 char), enabled char(1 char), last_logon_failure_time timestamp, last_logon_host varchar2(128 char), last_logonip varchar2(128 char), last_logon_time timestamp, logon_failure_times number(10,0), logon_times number(10,0), nick varchar2(64 char), password varchar2(128 char), random_code varchar2(255 char), user_id varchar2(30 char) not null, signup_time timestamp, uid varchar2(64 char) not null, user_pin varchar2(50 char), department_id varchar2(40 char), primary key (sid));

xiaolongyuan commented 10 years ago

uid varchar2(64 char) not null, uid是oracle关键字

xautlx commented 10 years ago

感谢反馈。请自行本地调整hibernate映射: @Column(name = "user_uid", updatable = false, length = 64, unique = true, nullable = false) public String getUid() { return uid; }

我会在适当时候把此修正提交到master

xiaolongyuan commented 10 years ago

OK 请注意sql脚本中也需要调整