NutzCN Logo
问答 换成达梦数据库后创建表出现错误
发布于 2247天前 作者 qq_64f81159 4577 次浏览 复制 上一个帖子 下一个帖子
标签:

错误如下

org.nutz.dao.DaoException: !Nutz SQL Error: 'CREATE TABLE cms_site(
id VARCHAR(32),
name VARCHAR(255) COMMENT '名称',
domain VARCHAR(255) COMMENT '域名',
title VARCHAR(255) COMMENT '标题',
template VARCHAR(255) COMMENT '模板',
keyword VARCHAR(255) COMMENT '关键字',
status INT(32) COMMENT '状态',
description VARCHAR(500) COMMENT '描述',
logo VARCHAR(500) COMMENT '背景图',
opBy VARCHAR(32) COMMENT '操作人',
opAt INT(32) COMMENT '操作时间',
delFlag BOOLEAN COMMENT '删除标记',
PRIMARY KEY (id)
) ENGINE=InnoDB CHARSET=utf8'
PreparedStatement: 
'CREATE TABLE cms_site(
id VARCHAR(32),
name VARCHAR(255) COMMENT '名称',
domain VARCHAR(255) COMMENT '域名',
title VARCHAR(255) COMMENT '标题',
template VARCHAR(255) COMMENT '模板',
keyword VARCHAR(255) COMMENT '关键字',
status INT(32) COMMENT '状态',
description VARCHAR(500) COMMENT '描述',
logo VARCHAR(500) COMMENT '背景图',
opBy VARCHAR(32) COMMENT '操作人',
opAt INT(32) COMMENT '操作时间',
delFlag BOOLEAN COMMENT '删除标记',
PRIMARY KEY (id)
) ENGINE=InnoDB CHARSET=utf8'
CaseMessage=第 3 行, 第 19 列[COMMENT]附近出现错误: 
语法分析出错
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:104)
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:66)
	at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22)
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:64)
	at org.nutz.plugins.cache.dao.DaoCacheInterceptor._exec(DaoCacheInterceptor.java:28)
	at org.nutz.plugins.cache.dao.CachedNutDaoExecutor.exec(CachedNutDaoExecutor.java:187)
	at org.nutz.plugins.cache.dao.DaoCacheInterceptor.filter(DaoCacheInterceptor.java:18)
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:64)
	at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:139)
	at org.nutz.dao.impl.sql.run.NutDaoRunner.runCallback(NutDaoRunner.java:158)
	at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithoutTransaction(NutDaoRunner.java:125)
	at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:92)
	at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:81)
	at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:240)
	at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:252)
	at org.nutz.dao.impl.DaoSupport.execute(DaoSupport.java:236)
	at org.nutz.dao.impl.NutDao.execute(NutDao.java:1008)
	at org.nutz.dao.impl.jdbc.mysql.MysqlJdbcExpert.createEntity(MysqlJdbcExpert.java:167)
	at org.nutz.dao.impl.NutDao.create(NutDao.java:812)
	at org.nutz.dao.util.Daos.createTablesInPackage(Daos.java:470)
	at com.kanq.common.core.Setup.initSysData(Setup.java:79)
	at com.kanq.common.core.Setup.init(Setup.java:48)
	at org.nutz.mvc.impl.NutLoading.evalSetup(NutLoading.java:274)
	at org.nutz.mvc.impl.NutLoading.load(NutLoading.java:121)
	at org.nutz.mvc.ActionHandler.<init>(ActionHandler.java:19)
	at org.nutz.mvc.NutFilter._init(NutFilter.java:91)
	at org.nutz.mvc.NutFilter.init(NutFilter.java:69)
	at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:279)
	at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:260)
	at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:105)
	at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4830)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5510)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649)
	at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1245)
	at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1895)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLException: 第 3 行, 第 19 列[COMMENT]附近出现错误: 
语法分析出错
	at dm.jdbc.dbaccess.DBError.throwSQLException(DBError.java:44)
	at dm.jdbc.dbaccess.Request_Response.resp_checkErr(Request_Response.java:2471)
	at dm.jdbc.dbaccess.Request_Response.resp_execute(Request_Response.java:1068)
	at dm.jdbc.dbaccess.Request_Response.resp_prepare(Request_Response.java:672)
	at dm.jdbc.dbaccess.DmdbCSI.prepareSQL(DmdbCSI.java:380)
	at dm.jdbc.driver.DmdbStatement_bs.directExec(DmdbStatement_bs.java:1744)
	at dm.jdbc.driver.DmdbStatement_bs.executeInner(DmdbStatement_bs.java:2129)
	at dm.jdbc.driver.DmdbStatement_bs.execute(DmdbStatement_bs.java:866)
	at dm.jdbc.driver.DmdbStatement.do_execute(DmdbStatement.java:1401)
	at dm.jdbc.filter.FilterChain.Statement_execute(FilterChain.java:921)
	at dm.jdbc.driver.DmdbStatement.execute(DmdbStatement.java:464)
	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:418)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor._runStatement(NutDaoExecutor.java:357)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:60)
	... 42 more
3 回复

是最新版nutz吗

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