//Pojo类
@Table("t_user_profile")
public class UserProfile extends BasePojo {
/**关联的用户id*/
@Id(auto=false)
@Column("uid")
protected int userId;
/**用户昵称*/
@Column
protected String nickname;
/**用户邮箱*/
@Column
protected String email;
/**邮箱是否已经验证过*/
@Column("email_checked")
protected boolean emailChecked;
/**头像的byte数据*/
@Column
@JsonField(ignore=true)
protected byte[] avatar;
/**性别*/
@Column
protected String gender;
/**自我介绍*/
@Column("dt")
protected String description;
@Column("loc")
protected String location;
}
用mssql2000创建表时报org.nutz.dao.DaoException。
详细异常如下:
严重: Exception starting filter nutz
org.nutz.mvc.LoadingException: org.nutz.dao.DaoException: !Nutz SQL Error: 'CREATE TABLE t_user_profile(
uid NUMERIC(8),
nickname VARCHAR(128),
email VARCHAR(128),
email_checked BIT,
avatar varbinary(max),
gender VARCHAR(128),
dt VARCHAR(128),
loc VARCHAR(128),
ct DATETIME,
ut DATETIME,
PRIMARY KEY (uid)
)'
PreparedStatement:
'CREATE TABLE t_user_profile(
uid NUMERIC(8),
nickname VARCHAR(128),
email VARCHAR(128),
email_checked BIT,
avatar varbinary(max),
gender VARCHAR(128),
dt VARCHAR(128),
loc VARCHAR(128),
ct DATETIME,
ut DATETIME,
PRIMARY KEY (uid)
)'
CaseMessage=第 6 行: 'max' 附近有语法错误。
```