求助:ActiveRecord连接Access,连接不报错,执行任何sql或者映射Model就报错

数据库配置:

blob.png

驱动配置:blob.png

所用jar包:

blob.png

数据库所在位置:

blob.png

数据库表:blob.png

报错:

Can not create Table object, maybe the table collect_area is not exists.


2017-11-09 18:31:42

[ERROR]-[Thread: main]-[com.jfinal.core.Config.startPlugins()]: Plugin start error: com.jfinal.plugin.activerecord.ActiveRecordPlugin. 

java.sql.SQLException: Lexical error: `collect_area` where 1 = 2

com.jfinal.plugin.activerecord.ActiveRecordException: java.sql.SQLException: Lexical error: `collect_area` where 1 = 2

at com.jfinal.plugin.activerecord.TableBuilder.build(TableBuilder.java:50)

at com.jfinal.plugin.activerecord.ActiveRecordPlugin.start(ActiveRecordPlugin.java:209)

at com.jfinal.core.Config.startPlugins(Config.java:107)

at com.jfinal.core.Config.configJFinal(Config.java:53)

at com.jfinal.core.JFinal.init(JFinal.java:63)

at com.jfinal.core.JFinalFilter.init(JFinalFilter.java:49)

at org.eclipse.jetty.servlet.FilterHolder.doStart(FilterHolder.java:119)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)

at org.eclipse.jetty.servlet.ServletHandler.initialize(ServletHandler.java:724)

at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:265)

at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1250)

at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:706)

at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:492)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)

at org.eclipse.jetty.server.handler.HandlerWrapper.doStart(HandlerWrapper.java:95)

at org.eclipse.jetty.server.Server.doStart(Server.java:277)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)

at com.jfinal.server.JettyServerForIDEA.doStart(JettyServerForIDEA.java:133)

at com.jfinal.server.JettyServerForIDEA.start(JettyServerForIDEA.java:72)

at com.jfinal.core.JFinal.start(JFinal.java:171)

at com.hbzxt.common.config.BaseConfig.main(BaseConfig.java:37)

Caused by: java.sql.SQLException: Lexical error: `collect_area` where 1 = 2

at com.hxtt.global.SQLState.SQLException(Unknown Source)

at com.hxtt.sql.dn.for(Unknown Source)

at com.hxtt.sql.e6.new(Unknown Source)

at com.hxtt.a.b.g(Unknown Source)

at com.hxtt.sql.bz.o(Unknown Source)

at com.hxtt.sql.bz.a(Unknown Source)

at com.hxtt.sql.am.a(Unknown Source)

at com.hxtt.sql.am.executeQuery(Unknown Source)

at com.alibaba.druid.pool.DruidPooledStatement.executeQuery(DruidPooledStatement.java:143)

at com.jfinal.plugin.activerecord.TableBuilder.doBuild(TableBuilder.java:66)

at com.jfinal.plugin.activerecord.TableBuilder.build(TableBuilder.java:42)

... 20 more

2017-11-09 18:31:42.032:WARN:oejuc.AbstractLifeCycle:FAILED jfinal: java.lang.RuntimeException: Plugin start error: com.jfinal.plugin.activerecord.ActiveRecordPlugin. |java.sql.SQLException: Lexical error: `collect_area` where 1 = 2

java.lang.RuntimeException: Plugin start error: com.jfinal.plugin.activerecord.ActiveRecordPlugin. |java.sql.SQLException: Lexical error: `collect_area` where 1 = 2

at com.jfinal.core.Config.startPlugins(Config.java:116)

at com.jfinal.core.Config.configJFinal(Config.java:53)

at com.jfinal.core.JFinal.init(JFinal.java:63)

at com.jfinal.core.JFinalFilter.init(JFinalFilter.java:49)

at org.eclipse.jetty.servlet.FilterHolder.doStart(FilterHolder.java:119)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)

at org.eclipse.jetty.servlet.ServletHandler.initialize(ServletHandler.java:724)

at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:265)

at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1250)

at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:706)

at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:492)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)

at org.eclipse.jetty.server.handler.HandlerWrapper.doStart(HandlerWrapper.java:95)

at org.eclipse.jetty.server.Server.doStart(Server.java:277)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)

at com.jfinal.server.JettyServerForIDEA.doStart(JettyServerForIDEA.java:133)

at com.jfinal.server.JettyServerForIDEA.start(JettyServerForIDEA.java:72)

at com.jfinal.core.JFinal.start(JFinal.java:171)

at com.hbzxt.common.config.BaseConfig.main(BaseConfig.java:37)

Caused by: 

com.jfinal.plugin.activerecord.ActiveRecordException: java.sql.SQLException: Lexical error: `collect_area` where 1 = 2

at com.jfinal.plugin.activerecord.TableBuilder.build(TableBuilder.java:50)

at com.jfinal.plugin.activerecord.ActiveRecordPlugin.start(ActiveRecordPlugin.java:209)

at com.jfinal.core.Config.startPlugins(Config.java:107)

at com.jfinal.core.Config.configJFinal(Config.java:53)

at com.jfinal.core.JFinal.init(JFinal.java:63)

at com.jfinal.core.JFinalFilter.init(JFinalFilter.java:49)

at org.eclipse.jetty.servlet.FilterHolder.doStart(FilterHolder.java:119)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)

at org.eclipse.jetty.servlet.ServletHandler.initialize(ServletHandler.java:724)

at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:265)

at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1250)

at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:706)

at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:492)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)

at org.eclipse.jetty.server.handler.HandlerWrapper.doStart(HandlerWrapper.java:95)

at org.eclipse.jetty.server.Server.doStart(Server.java:277)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)

at com.jfinal.server.JettyServerForIDEA.doStart(JettyServerForIDEA.java:133)

at com.jfinal.server.JettyServerForIDEA.start(JettyServerForIDEA.java:72)

at com.jfinal.core.JFinal.start(JFinal.java:171)

at com.hbzxt.common.config.BaseConfig.main(BaseConfig.java:37)

Caused by: 

java.sql.SQLException: Lexical error: `collect_area` where 1 = 2

at com.hxtt.global.SQLState.SQLException(Unknown Source)

at com.hxtt.sql.dn.for(Unknown Source)

at com.hxtt.sql.e6.new(Unknown Source)

at com.hxtt.a.b.g(Unknown Source)

at com.hxtt.sql.bz.o(Unknown Source)

at com.hxtt.sql.bz.a(Unknown Source)

at com.hxtt.sql.am.a(Unknown Source)

at com.hxtt.sql.am.executeQuery(Unknown Source)

at com.alibaba.druid.pool.DruidPooledStatement.executeQuery(DruidPooledStatement.java:143)

at com.jfinal.plugin.activerecord.TableBuilder.doBuild(TableBuilder.java:66)

at com.jfinal.plugin.activerecord.TableBuilder.build(TableBuilder.java:42)

at com.jfinal.plugin.activerecord.ActiveRecordPlugin.start(ActiveRecordPlugin.java:209)

at com.jfinal.core.Config.startPlugins(Config.java:107)

at com.jfinal.core.Config.configJFinal(Config.java:53)

at com.jfinal.core.JFinal.init(JFinal.java:63)

at com.jfinal.core.JFinalFilter.init(JFinalFilter.java:49)

at org.eclipse.jetty.servlet.FilterHolder.doStart(FilterHolder.java:119)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)

at org.eclipse.jetty.servlet.ServletHandler.initialize(ServletHandler.java:724)

at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:265)

at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1250)

at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:706)

at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:492)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)

at org.eclipse.jetty.server.handler.HandlerWrapper.doStart(HandlerWrapper.java:95)

at org.eclipse.jetty.server.Server.doStart(Server.java:277)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)

at com.jfinal.server.JettyServerForIDEA.doStart(JettyServerForIDEA.java:133)

at com.jfinal.server.JettyServerForIDEA.start(JettyServerForIDEA.java:72)

at com.jfinal.core.JFinal.start(JFinal.java:171)

at com.hbzxt.common.config.BaseConfig.main(BaseConfig.java:37)

2017-11-09 18:31:42.048:WARN:oejw.WebAppContext:Failed startup of context o.e.j.w.WebAppContext{/,file:/E:/zero/workspace/gzyp/WebRoot/}

java.lang.RuntimeException: Plugin start error: com.jfinal.plugin.activerecord.ActiveRecordPlugin. |java.sql.SQLException: Lexical error: `collect_area` where 1 = 2

at com.jfinal.core.Config.startPlugins(Config.java:116)

at com.jfinal.core.Config.configJFinal(Config.java:53)

at com.jfinal.core.JFinal.init(JFinal.java:63)

at com.jfinal.core.JFinalFilter.init(JFinalFilter.java:49)

at org.eclipse.jetty.servlet.FilterHolder.doStart(FilterHolder.java:119)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)

at org.eclipse.jetty.servlet.ServletHandler.initialize(ServletHandler.java:724)

at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:265)

at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1250)

at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:706)

at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:492)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)

at org.eclipse.jetty.server.handler.HandlerWrapper.doStart(HandlerWrapper.java:95)

at org.eclipse.jetty.server.Server.doStart(Server.java:277)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)

at com.jfinal.server.JettyServerForIDEA.doStart(JettyServerForIDEA.java:133)

at com.jfinal.server.JettyServerForIDEA.start(JettyServerForIDEA.java:72)

at com.jfinal.core.JFinal.start(JFinal.java:171)

at com.hbzxt.common.config.BaseConfig.main(BaseConfig.java:37)

Caused by: 

com.jfinal.plugin.activerecord.ActiveRecordException: java.sql.SQLException: Lexical error: `collect_area` where 1 = 2

at com.jfinal.plugin.activerecord.TableBuilder.build(TableBuilder.java:50)

at com.jfinal.plugin.activerecord.ActiveRecordPlugin.start(ActiveRecordPlugin.java:209)

at com.jfinal.core.Config.startPlugins(Config.java:107)

at com.jfinal.core.Config.configJFinal(Config.java:53)

at com.jfinal.core.JFinal.init(JFinal.java:63)

at com.jfinal.core.JFinalFilter.init(JFinalFilter.java:49)

at org.eclipse.jetty.servlet.FilterHolder.doStart(FilterHolder.java:119)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)

at org.eclipse.jetty.servlet.ServletHandler.initialize(ServletHandler.java:724)

at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:265)

at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1250)

at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:706)

at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:492)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)

at org.eclipse.jetty.server.handler.HandlerWrapper.doStart(HandlerWrapper.java:95)

at org.eclipse.jetty.server.Server.doStart(Server.java:277)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)

at com.jfinal.server.JettyServerForIDEA.doStart(JettyServerForIDEA.java:133)

at com.jfinal.server.JettyServerForIDEA.start(JettyServerForIDEA.java:72)

at com.jfinal.core.JFinal.start(JFinal.java:171)

at com.hbzxt.common.config.BaseConfig.main(BaseConfig.java:37)

Caused by: 

java.sql.SQLException: Lexical error: `collect_area` where 1 = 2

at com.hxtt.global.SQLState.SQLException(Unknown Source)

at com.hxtt.sql.dn.for(Unknown Source)

at com.hxtt.sql.e6.new(Unknown Source)

at com.hxtt.a.b.g(Unknown Source)

at com.hxtt.sql.bz.o(Unknown Source)

at com.hxtt.sql.bz.a(Unknown Source)

at com.hxtt.sql.am.a(Unknown Source)

at com.hxtt.sql.am.executeQuery(Unknown Source)

at com.alibaba.druid.pool.DruidPooledStatement.executeQuery(DruidPooledStatement.java:143)

at com.jfinal.plugin.activerecord.TableBuilder.doBuild(TableBuilder.java:66)

at com.jfinal.plugin.activerecord.TableBuilder.build(TableBuilder.java:42)

at com.jfinal.plugin.activerecord.ActiveRecordPlugin.start(ActiveRecordPlugin.java:209)

at com.jfinal.core.Config.startPlugins(Config.java:107)

at com.jfinal.core.Config.configJFinal(Config.java:53)

at com.jfinal.core.JFinal.init(JFinal.java:63)

at com.jfinal.core.JFinalFilter.init(JFinalFilter.java:49)

at org.eclipse.jetty.servlet.FilterHolder.doStart(FilterHolder.java:119)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)

at org.eclipse.jetty.servlet.ServletHandler.initialize(ServletHandler.java:724)

at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:265)

at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1250)

at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:706)

at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:492)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)

at org.eclipse.jetty.server.handler.HandlerWrapper.doStart(HandlerWrapper.java:95)

at org.eclipse.jetty.server.Server.doStart(Server.java:277)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)

at com.jfinal.server.JettyServerForIDEA.doStart(JettyServerForIDEA.java:133)

at com.jfinal.server.JettyServerForIDEA.start(JettyServerForIDEA.java:72)

at com.jfinal.core.JFinal.start(JFinal.java:171)

at com.hbzxt.common.config.BaseConfig.main(BaseConfig.java:37)

2017-11-09 18:31:42.048:WARN:oejuc.AbstractLifeCycle:FAILED o.e.j.w.WebAppContext{/,file:/E:/zero/workspace/gzyp/WebRoot/}: java.lang.RuntimeException: Plugin start error: com.jfinal.plugin.activerecord.ActiveRecordPlugin. |java.sql.SQLException: Lexical error: `collect_area` where 1 = 2

java.lang.RuntimeException: Plugin start error: com.jfinal.plugin.activerecord.ActiveRecordPlugin. |java.sql.SQLException: Lexical error: `collect_area` where 1 = 2

at com.jfinal.core.Config.startPlugins(Config.java:116)

at com.jfinal.core.Config.configJFinal(Config.java:53)

at com.jfinal.core.JFinal.init(JFinal.java:63)

at com.jfinal.core.JFinalFilter.init(JFinalFilter.java:49)

at org.eclipse.jetty.servlet.FilterHolder.doStart(FilterHolder.java:119)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)

at org.eclipse.jetty.servlet.ServletHandler.initialize(ServletHandler.java:724)

at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:265)

at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1250)

at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:706)

at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:492)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)

at org.eclipse.jetty.server.handler.HandlerWrapper.doStart(HandlerWrapper.java:95)

at org.eclipse.jetty.server.Server.doStart(Server.java:277)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)

at com.jfinal.server.JettyServerForIDEA.doStart(JettyServerForIDEA.java:133)

at com.jfinal.server.JettyServerForIDEA.start(JettyServerForIDEA.java:72)

at com.jfinal.core.JFinal.start(JFinal.java:171)

at com.hbzxt.common.config.BaseConfig.main(BaseConfig.java:37)

Caused by: 

com.jfinal.plugin.activerecord.ActiveRecordException: java.sql.SQLException: Lexical error: `collect_area` where 1 = 2

at com.jfinal.plugin.activerecord.TableBuilder.build(TableBuilder.java:50)

at com.jfinal.plugin.activerecord.ActiveRecordPlugin.start(ActiveRecordPlugin.java:209)

at com.jfinal.core.Config.startPlugins(Config.java:107)

at com.jfinal.core.Config.configJFinal(Config.java:53)

at com.jfinal.core.JFinal.init(JFinal.java:63)

at com.jfinal.core.JFinalFilter.init(JFinalFilter.java:49)

at org.eclipse.jetty.servlet.FilterHolder.doStart(FilterHolder.java:119)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)

at org.eclipse.jetty.servlet.ServletHandler.initialize(ServletHandler.java:724)

at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:265)

at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1250)

at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:706)

at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:492)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)

at org.eclipse.jetty.server.handler.HandlerWrapper.doStart(HandlerWrapper.java:95)

at org.eclipse.jetty.server.Server.doStart(Server.java:277)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)

at com.jfinal.server.JettyServerForIDEA.doStart(JettyServerForIDEA.java:133)

at com.jfinal.server.JettyServerForIDEA.start(JettyServerForIDEA.java:72)

at com.jfinal.core.JFinal.start(JFinal.java:171)

at com.hbzxt.common.config.BaseConfig.main(BaseConfig.java:37)

Caused by: 

java.sql.SQLException: Lexical error: `collect_area` where 1 = 2

at com.hxtt.global.SQLState.SQLException(Unknown Source)

at com.hxtt.sql.dn.for(Unknown Source)

at com.hxtt.sql.e6.new(Unknown Source)

at com.hxtt.a.b.g(Unknown Source)

at com.hxtt.sql.bz.o(Unknown Source)

at com.hxtt.sql.bz.a(Unknown Source)

at com.hxtt.sql.am.a(Unknown Source)

at com.hxtt.sql.am.executeQuery(Unknown Source)

at com.alibaba.druid.pool.DruidPooledStatement.executeQuery(DruidPooledStatement.java:143)

at com.jfinal.plugin.activerecord.TableBuilder.doBuild(TableBuilder.java:66)

at com.jfinal.plugin.activerecord.TableBuilder.build(TableBuilder.java:42)

at com.jfinal.plugin.activerecord.ActiveRecordPlugin.start(ActiveRecordPlugin.java:209)

at com.jfinal.core.Config.startPlugins(Config.java:107)

at com.jfinal.core.Config.configJFinal(Config.java:53)

at com.jfinal.core.JFinal.init(JFinal.java:63)

at com.jfinal.core.JFinalFilter.init(JFinalFilter.java:49)

at org.eclipse.jetty.servlet.FilterHolder.doStart(FilterHolder.java:119)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)

at org.eclipse.jetty.servlet.ServletHandler.initialize(ServletHandler.java:724)

at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:265)

at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1250)

at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:706)

at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:492)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)

at org.eclipse.jetty.server.handler.HandlerWrapper.doStart(HandlerWrapper.java:95)

at org.eclipse.jetty.server.Server.doStart(Server.java:277)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)

at com.jfinal.server.JettyServerForIDEA.doStart(JettyServerForIDEA.java:133)

at com.jfinal.server.JettyServerForIDEA.start(JettyServerForIDEA.java:72)

at com.jfinal.core.JFinal.start(JFinal.java:171)

at com.hbzxt.common.config.BaseConfig.main(BaseConfig.java:37)

2017-11-09 18:31:42.048:WARN:oejuc.AbstractLifeCycle:FAILED org.eclipse.jetty.server.Server@419146a5: java.lang.RuntimeException: Plugin start error: com.jfinal.plugin.activerecord.ActiveRecordPlugin. |java.sql.SQLException: Lexical error: `collect_area` where 1 = 2

java.lang.RuntimeException: Plugin start error: com.jfinal.plugin.activerecord.ActiveRecordPlugin. |java.sql.SQLException: Lexical error: `collect_area` where 1 = 2

at com.jfinal.core.Config.startPlugins(Config.java:116)

at com.jfinal.core.Config.configJFinal(Config.java:53)

at com.jfinal.core.JFinal.init(JFinal.java:63)

at com.jfinal.core.JFinalFilter.init(JFinalFilter.java:49)

at org.eclipse.jetty.servlet.FilterHolder.doStart(FilterHolder.java:119)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)

at org.eclipse.jetty.servlet.ServletHandler.initialize(ServletHandler.java:724)

at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:265)

at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1250)

at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:706)

at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:492)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)

at org.eclipse.jetty.server.handler.HandlerWrapper.doStart(HandlerWrapper.java:95)

at org.eclipse.jetty.server.Server.doStart(Server.java:277)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)

at com.jfinal.server.JettyServerForIDEA.doStart(JettyServerForIDEA.java:133)

at com.jfinal.server.JettyServerForIDEA.start(JettyServerForIDEA.java:72)

at com.jfinal.core.JFinal.start(JFinal.java:171)

at com.hbzxt.common.config.BaseConfig.main(BaseConfig.java:37)

Caused by: 

com.jfinal.plugin.activerecord.ActiveRecordException: java.sql.SQLException: Lexical error: `collect_area` where 1 = 2

at com.jfinal.plugin.activerecord.TableBuilder.build(TableBuilder.java:50)

at com.jfinal.plugin.activerecord.ActiveRecordPlugin.start(ActiveRecordPlugin.java:209)

at com.jfinal.core.Config.startPlugins(Config.java:107)

at com.jfinal.core.Config.configJFinal(Config.java:53)

at com.jfinal.core.JFinal.init(JFinal.java:63)

at com.jfinal.core.JFinalFilter.init(JFinalFilter.java:49)

at org.eclipse.jetty.servlet.FilterHolder.doStart(FilterHolder.java:119)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)

at org.eclipse.jetty.servlet.ServletHandler.initialize(ServletHandler.java:724)

at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:265)

at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1250)

at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:706)

at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:492)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)

at org.eclipse.jetty.server.handler.HandlerWrapper.doStart(HandlerWrapper.java:95)

at org.eclipse.jetty.server.Server.doStart(Server.java:277)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)

at com.jfinal.server.JettyServerForIDEA.doStart(JettyServerForIDEA.java:133)

at com.jfinal.server.JettyServerForIDEA.start(JettyServerForIDEA.java:72)

at com.jfinal.core.JFinal.start(JFinal.java:171)

at com.hbzxt.common.config.BaseConfig.main(BaseConfig.java:37)

Caused by: 

java.sql.SQLException: Lexical error: `collect_area` where 1 = 2

at com.hxtt.global.SQLState.SQLException(Unknown Source)

at com.hxtt.sql.dn.for(Unknown Source)

at com.hxtt.sql.e6.new(Unknown Source)

at com.hxtt.a.b.g(Unknown Source)

at com.hxtt.sql.bz.o(Unknown Source)

at com.hxtt.sql.bz.a(Unknown Source)

at com.hxtt.sql.am.a(Unknown Source)

at com.hxtt.sql.am.executeQuery(Unknown Source)

at com.alibaba.druid.pool.DruidPooledStatement.executeQuery(DruidPooledStatement.java:143)

at com.jfinal.plugin.activerecord.TableBuilder.doBuild(TableBuilder.java:66)

at com.jfinal.plugin.activerecord.TableBuilder.build(TableBuilder.java:42)

at com.jfinal.plugin.activerecord.ActiveRecordPlugin.start(ActiveRecordPlugin.java:209)

at com.jfinal.core.Config.startPlugins(Config.java:107)

at com.jfinal.core.Config.configJFinal(Config.java:53)

at com.jfinal.core.JFinal.init(JFinal.java:63)

at com.jfinal.core.JFinalFilter.init(JFinalFilter.java:49)

at org.eclipse.jetty.servlet.FilterHolder.doStart(FilterHolder.java:119)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)

at org.eclipse.jetty.servlet.ServletHandler.initialize(ServletHandler.java:724)

at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:265)

at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1250)

at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:706)

at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:492)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)

at org.eclipse.jetty.server.handler.HandlerWrapper.doStart(HandlerWrapper.java:95)

at org.eclipse.jetty.server.Server.doStart(Server.java:277)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)

at com.jfinal.server.JettyServerForIDEA.doStart(JettyServerForIDEA.java:133)

at com.jfinal.server.JettyServerForIDEA.start(JettyServerForIDEA.java:72)

at com.jfinal.core.JFinal.start(JFinal.java:171)

at com.hbzxt.common.config.BaseConfig.main(BaseConfig.java:37)

Disconnected from the target VM, address: '127.0.0.1:52513', transport: 'socket'


2017-11-09 18:31:42

[ERROR]-[Thread: main]-[com.jfinal.kit.LogKit.error()]: Plugin start error: com.jfinal.plugin.activerecord.ActiveRecordPlugin. 

java.sql.SQLException: Lexical error: `collect_area` where 1 = 2

java.lang.RuntimeException: Plugin start error: com.jfinal.plugin.activerecord.ActiveRecordPlugin. 

java.sql.SQLException: Lexical error: `collect_area` where 1 = 2

at com.jfinal.core.Config.startPlugins(Config.java:116)

at com.jfinal.core.Config.configJFinal(Config.java:53)

at com.jfinal.core.JFinal.init(JFinal.java:63)

at com.jfinal.core.JFinalFilter.init(JFinalFilter.java:49)

at org.eclipse.jetty.servlet.FilterHolder.doStart(FilterHolder.java:119)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)

at org.eclipse.jetty.servlet.ServletHandler.initialize(ServletHandler.java:724)

at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:265)

at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1250)

at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:706)

at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:492)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)

at org.eclipse.jetty.server.handler.HandlerWrapper.doStart(HandlerWrapper.java:95)

at org.eclipse.jetty.server.Server.doStart(Server.java:277)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)

at com.jfinal.server.JettyServerForIDEA.doStart(JettyServerForIDEA.java:133)

at com.jfinal.server.JettyServerForIDEA.start(JettyServerForIDEA.java:72)

at com.jfinal.core.JFinal.start(JFinal.java:171)

at com.hbzxt.common.config.BaseConfig.main(BaseConfig.java:37)

Caused by: com.jfinal.plugin.activerecord.ActiveRecordException: java.sql.SQLException: Lexical error: `collect_area` where 1 = 2

at com.jfinal.plugin.activerecord.TableBuilder.build(TableBuilder.java:50)

at com.jfinal.plugin.activerecord.ActiveRecordPlugin.start(ActiveRecordPlugin.java:209)

at com.jfinal.core.Config.startPlugins(Config.java:107)

... 18 more

Caused by: java.sql.SQLException: Lexical error: `collect_area` where 1 = 2

at com.hxtt.global.SQLState.SQLException(Unknown Source)

at com.hxtt.sql.dn.for(Unknown Source)

at com.hxtt.sql.e6.new(Unknown Source)

at com.hxtt.a.b.g(Unknown Source)

at com.hxtt.sql.bz.o(Unknown Source)

at com.hxtt.sql.bz.a(Unknown Source)

at com.hxtt.sql.am.a(Unknown Source)

at com.hxtt.sql.am.executeQuery(Unknown Source)

at com.alibaba.druid.pool.DruidPooledStatement.executeQuery(DruidPooledStatement.java:143)

at com.jfinal.plugin.activerecord.TableBuilder.doBuild(TableBuilder.java:66)

at com.jfinal.plugin.activerecord.TableBuilder.build(TableBuilder.java:42)

... 20 more

报错位置跟踪(TableBuilder.class中):

connection情况:blob.png

再往下一句就报错了

评论区

zeroGray

2017-11-10 11:47

已经找到了问题所在了,
String sql = config.dialect.forTableBuilderDoBuild(table.getName())
拼出来的sql有`表名`,貌似目前的Dialect并没有支持access的实现,看来我得自己去实现拓展了

热门反馈

扫码入社