NutzCN Logo
问答 h2升级2.1.210后创建表异常
发布于 928天前 作者 Hamming 1661 次浏览 复制 上一个帖子 下一个帖子
标签:

求赐教

        <dependency>
            <groupId>com.h2database</groupId>
            <artifactId>h2</artifactId>
            <version>2.1.210</version>
        </dependency>
class=io.nutz.nutzsite.module.sys.models.Dict
java.lang.RuntimeException: class=io.nutz.nutzsite.module.sys.models.Dict
	at org.nutz.dao.util.Daos.createTables(Daos.java:572)
	at org.nutz.dao.util.Daos.createTablesInPackage(Daos.java:485)
	at io.nutz.nutzsite.MainLauncher.initSysData(MainLauncher.java:189)
	at io.nutz.nutzsite.MainLauncher.init(MainLauncher.java:113)
	at io.nutz.nutzsite.MainLauncher$FM$init$ef5ffd5b410b11cae41777f9874670a0.invoke(MainLauncher.java)
	at org.nutz.ioc.impl.ObjectMakerImpl$2.trigger(ObjectMakerImpl.java:181)
	at org.nutz.ioc.weaver.DefaultWeaver.onCreate(DefaultWeaver.java:89)
	at org.nutz.ioc.impl.ObjectMakerImpl.make(ObjectMakerImpl.java:141)
	at org.nutz.ioc.impl.NutIoc.get(NutIoc.java:241)
	at org.nutz.ioc.impl.NutIoc.get(NutIoc.java:271)
	at org.nutz.ioc.impl.NutIoc.get(NutIoc.java:161)
	at org.nutz.boot.NbApp.execute(NbApp.java:214)
	at org.nutz.boot.NbApp.run(NbApp.java:182)
	at io.nutz.nutzsite.MainLauncher.main(MainLauncher.java:72)
Caused by: org.nutz.dao.DaoException: !Nutz SQL Error: 'CREATE TABLE sys_dict(
id VARCHAR(32),
value VARCHAR(128),
label VARCHAR(128),
type VARCHAR(128),
description VARCHAR(128),
sort NUMERIC(32),
parent_id VARCHAR(128),
remarks VARCHAR(128),
del_flag BOOLEAN,
create_by VARCHAR(128),
create_time TIMESTAMP,
update_by VARCHAR(128),
update_time TIMESTAMP,
CONSTRAINT sys_dict_pkey PRIMARY KEY (id)
)'
PreparedStatement: 
'CREATE TABLE sys_dict(
id VARCHAR(32),
value VARCHAR(128),
label VARCHAR(128),
type VARCHAR(128),
description VARCHAR(128),
sort NUMERIC(32),
parent_id VARCHAR(128),
remarks VARCHAR(128),
del_flag BOOLEAN,
create_by VARCHAR(128),
create_time TIMESTAMP,
update_by VARCHAR(128),
update_time TIMESTAMP,
CONSTRAINT sys_dict_pkey PRIMARY KEY (id)
)'
CaseMessage=Syntax error in SQL statement "CREATE TABLE sys_dict(\000aid VARCHAR(32),\000a[*]value VARCHAR(128),\000alabel VARCHAR(128),\000atype VARCHAR(128),\000adescription VARCHAR(128),\000asort NUMERIC(32),\000aparent_id VARCHAR(128),\000aremarks VARCHAR(128),\000adel_flag BOOLEAN,\000acreate_by VARCHAR(128),\000acreate_time TIMESTAMP,\000aupdate_by VARCHAR(128),\000aupdate_time TIMESTAMP,\000aCONSTRAINT sys_dict_pkey PRIMARY KEY (id)\000a)"; expected "identifier"; SQL statement:
CREATE TABLE sys_dict(
id VARCHAR(32),
value VARCHAR(128),
label VARCHAR(128),
type VARCHAR(128),
description VARCHAR(128),
sort NUMERIC(32),
parent_id VARCHAR(128),
remarks VARCHAR(128),
del_flag BOOLEAN,
create_by VARCHAR(128),
create_time TIMESTAMP,
update_by VARCHAR(128),
update_time TIMESTAMP,
CONSTRAINT sys_dict_pkey PRIMARY KEY (id)
) [42001-210]
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:110)
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:65)
	at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22)
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:63)
	at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:138)
	at org.nutz.dao.impl.sql.run.NutDaoRunner.runCallback(NutDaoRunner.java:163)
	at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithoutTransaction(NutDaoRunner.java:130)
	at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:97)
	at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:86)
	at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:242)
	at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:254)
	at org.nutz.dao.impl.DaoSupport.execute(DaoSupport.java:238)
	at org.nutz.dao.impl.NutDao.execute(NutDao.java:1291)
	at org.nutz.dao.impl.jdbc.psql.PsqlJdbcExpert.createEntity(PsqlJdbcExpert.java:110)
	at org.nutz.dao.impl.NutDao.create(NutDao.java:1009)
	at org.nutz.dao.util.Daos.createTables(Daos.java:569)
	... 13 more
Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "CREATE TABLE sys_dict(\000aid VARCHAR(32),\000a[*]value VARCHAR(128),\000alabel VARCHAR(128),\000atype VARCHAR(128),\000adescription VARCHAR(128),\000asort NUMERIC(32),\000aparent_id VARCHAR(128),\000aremarks VARCHAR(128),\000adel_flag BOOLEAN,\000acreate_by VARCHAR(128),\000acreate_time TIMESTAMP,\000aupdate_by VARCHAR(128),\000aupdate_time TIMESTAMP,\000aCONSTRAINT sys_dict_pkey PRIMARY KEY (id)\000a)"; expected "identifier"; SQL statement:
CREATE TABLE sys_dict(
id VARCHAR(32),
value VARCHAR(128),
label VARCHAR(128),
type VARCHAR(128),
description VARCHAR(128),
sort NUMERIC(32),
parent_id VARCHAR(128),
remarks VARCHAR(128),
del_flag BOOLEAN,
create_by VARCHAR(128),
create_time TIMESTAMP,
update_by VARCHAR(128),
update_time TIMESTAMP,
CONSTRAINT sys_dict_pkey PRIMARY KEY (id)
) [42001-210]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:521)
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:496)
	at org.h2.message.DbException.getSyntaxError(DbException.java:265)
	at org.h2.command.Parser.readIdentifier(Parser.java:5759)
	at org.h2.command.Parser.parseTableColumnDefinition(Parser.java:9355)
	at org.h2.command.Parser.parseCreateTable(Parser.java:9298)
	at org.h2.command.Parser.parseCreate(Parser.java:6779)
	at org.h2.command.Parser.parsePrepared(Parser.java:746)
	at org.h2.command.Parser.parse(Parser.java:674)
	at org.h2.command.Parser.parse(Parser.java:644)
	at org.h2.command.Parser.prepareCommand(Parser.java:551)
	at org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:615)
	at org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:553)
	at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1116)
	at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:237)
	at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:223)
	at com.alibaba.druid.filter.FilterChainImpl.statement_execute(FilterChainImpl.java:3010)
	at com.alibaba.druid.filter.FilterAdapter.statement_execute(FilterAdapter.java:2484)
	at com.alibaba.druid.filter.FilterEventAdapter.statement_execute(FilterEventAdapter.java:188)
	at com.alibaba.druid.filter.FilterChainImpl.statement_execute(FilterChainImpl.java:3008)
	at com.alibaba.druid.proxy.jdbc.StatementProxyImpl.execute(StatementProxyImpl.java:147)
	at com.alibaba.druid.pool.DruidPooledStatement.execute(DruidPooledStatement.java:633)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor._runStatement(NutDaoExecutor.java:360)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:66)
	... 28 more
[DEBUG] 11:58:46.362 org.nutz.ioc.impl.ScopeContext.remove(ScopeContext.java:85) - Remove object 'mainLauncher' from [app] 
[ERROR] 11:58:46.362 org.nutz.boot.NbApp.execute(NbApp.java:224) - something happen!!
org.nutz.ioc.IocException: IocBean[mainLauncher] throw Exception when creating
	at org.nutz.ioc.impl.ObjectMakerImpl.make(ObjectMakerImpl.java:153)
	at org.nutz.ioc.impl.NutIoc.get(NutIoc.java:241)
	at org.nutz.ioc.impl.NutIoc.get(NutIoc.java:271)
	at org.nutz.ioc.impl.NutIoc.get(NutIoc.java:161)
	at org.nutz.boot.NbApp.execute(NbApp.java:214)
	at org.nutz.boot.NbApp.run(NbApp.java:182)
	at io.nutz.nutzsite.MainLauncher.main(MainLauncher.java:72)
Caused by: java.lang.RuntimeException: class=io.nutz.nutzsite.module.sys.models.Dict
2 回复

value 是关键字 换了 解决了

添加回复
请先登陆
回到顶部