oracle自动建表失败,自动建表oracle数据库有这个如下问题。

Caused by: org.nutz.dao.DaoException: !Nutz SQL Error: 'CREATE TABLE spfmis_facilities_info(

id NUMBER(16) primary key ,

team_name VARCHAR2(80),

sort VARCHAR2(20),

facilities_name VARCHAR2(120),

type VARCHAR2(100),

pf_range VARCHAR2(100),

serial_number VARCHAR2(50),

manufacturer VARCHAR2(100),

cast_time DATE,

number NUMBER(8),

check_repair_date DATE,

check_repair_unit VARCHAR2(120),

certificateNumber VARCHAR2(80),

next_check_repair_date DATE,

retestingPeriod NUMBER(8),

current_state VARCHAR2(20),

remark VARCHAR2(300),

creater VARCHAR2(50),

create_time DATE)'

PreparedStatement:

'CREATE TABLE spfmis_facilities_info(

id NUMBER(16) primary key ,

team_name VARCHAR2(80),

sort VARCHAR2(20),

facilities_name VARCHAR2(120),

type VARCHAR2(100),

pf_range VARCHAR2(100),

serial_number VARCHAR2(50),

manufacturer VARCHAR2(100),

cast_time DATE,

number NUMBER(8),

check_repair_date DATE,

check_repair_unit VARCHAR2(120),

certificateNumber VARCHAR2(80),

next_check_repair_date DATE,

retestingPeriod NUMBER(8),

current_state VARCHAR2(20),

remark VARCHAR2(300),

creater VARCHAR2(50),

create_time DATE)'

at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:90)

at org.nutz.dao.impl.DaoSupport$DaoExec.invoke(DaoSupport.java:249)

at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:64)

... 45 more

Caused by: java.sql.SQLException: ORA-00904: : 标识符无效

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)

at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:754)

at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)

at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:963)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1192)

at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1731)

at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1701)

at com.alibaba.druid.filter.FilterChainImpl.statement_execute(FilterChainImpl.java:2489)

at com.alibaba.druid.filter.FilterAdapter.statement_execute(FilterAdapter.java:2451)

at com.alibaba.druid.filter.FilterEventAdapter.statement_execute(FilterEventAdapter.java:188)

at com.alibaba.druid.filter.FilterChainImpl.statement_execute(FilterChainImpl.java:2487)

at com.alibaba.druid.proxy.jdbc.StatementProxyImpl.execute(StatementProxyImpl.java:137)

at com.alibaba.druid.pool.DruidPooledStatement.execute(DruidPooledStatement.java:421)

at org.nutz.dao.impl.sql.run.NutDaoExecutor._runStatement(NutDaoExecutor.java:312)

at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:50)

... 47 more

下面是实体：

@table("spfmis_facilities_info")

public class FacilitiesModel implements Serializable {

private static final long serialVersionUID = 1L;

/**

* 主键

*/

@Id

@Comment("ID主键")

private long id;

/**

* 队号

*/

@Column("team_name")

@Comment("队号")

@ColDefine(width = 80)

private String teamName;

/**

* 设备序号

*/

@Column("sort")

@Comment("设备序号")

@ColDefine(width = 20)

private int sort;

/**

* 设备名称

*/

@Column("facilities_name")

@Comment("设备名称")

@ColDefine(width = 120)

private String facilitiesName;

/**

* 设备型号

*/

@Column("type")

@Comment("设备型号")

@ColDefine(width = 100)

private String type;

/**

* 量程

*/

@Column("pf_range")

@Comment("量程")

@ColDefine(width = 100)

private String range;

/**

* 出厂编号

*/

@Column("serial_number")

@Comment("出厂编号")

@ColDefine(width = 50)

private String serialNumber;

/**

* 制造商

*/

@Column

@Comment("制造商")

@ColDefine(width = 100)

private String manufacturer;

/**

* 投用日期

*/

@Column("cast_time")

@ColDefine(type = ColType.DATE, update = true)

@Comment("投用日期")

@JsonField(dateFormat = "yyyy-MM-dd")

private Date castTime;

/**

* 数量

*/

@Column

@Comment("数量")

private int number;

/**

* 检维修日期

*/

@Column("check_repair_date")

@ColDefine(type = ColType.DATE)

@Comment("检维修日期")

@JsonField(dateFormat = "yyyy-MM-dd")

private Date checkAndRepairDate;

/**

* 检维修单位

*/

@Column("check_repair_unit")

@Comment("检维修单位")

@ColDefine(width = 120)

private String checkAndRepairUnit;

/**

* 证书编号

*/

@Column

@Comment("证书编号")

@ColDefine(width = 80)

private String certificateNumber;

/**

* 下次检维修日期

*/

@Column("next_check_repair_date")

@ColDefine(type = ColType.DATE, update = true)

@Comment("下次检维修日期")

@JsonField(dateFormat = "yyyy-MM-dd")

private Date nextCheckAndRepairDate;

/**

* 检定周期

*/

@Column

@Comment("检定周期")

private int retestingPeriod;

/**

* 当前状态

*/

@Column("current_state")

@Comment("当前状态")

@ColDefine(width = 20)

private String currentState;

/**

* 备注信息

*/

@Column("remark")

@Comment("备注信息")

@ColDefine(width = 300)

private String remark;

/**

* 创建人

*/

@Column

@Comment("创建人")

private String creater;

/**

* 创建日期

*/

@Column("create_time")

@ColDefine(type = ColType.DATE, update = false)

@Comment("创建日期")

@JsonField(dateFormat = "yyyy-MM-dd")

private Date createTime;