错误如下
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