Jfinal关于h2数据库操作出现sql语句多个双引号的语法错误问题

Dreampie 发布于 2014/07/07 14:23
阅读 1K+
收藏 0

http://localhost:9090/tosignup?token=509f2442-bb13-4616-bc41-e22e1816aaaf( http://localhost:9090 可换成 www.dreampie.cn)   

sql语句为:SELECT `token`.*  FROM sec_token `token`  WHERE `token`.uuid='509f2442-bb13-4616-bc41-e22e1816aaaf'  AND `token`.expiration_at>'2014-07-07 14:21:49' AND `token`.used_to=0

使用的h2数据库   

http://www.oschina.net/p/dreampie-jfinal   开源项目地址  

可以下载下来看看    或者直接访问http://www.dreampie.cn  账户admin:dreampie 
@JFinal

加载中
1
JFinal
JFinal
sql 语法有错误,目测是等于号是全角的 "=",所以表面上看不出来是哪里出错了
2
JFinal
JFinal
jfinal activerecord 默认使用 MysqlDialect 方言,该方言在生成 sql 的时候是会加上这个字符的,换成 AnsiSqlDialect 即可: arp.setDialect(new AnsiSqlDialec())
0
Dreampie
Dreampie

引用来自“JFinal”的评论

jfinal activerecord 默认使用 MysqlDialect 方言,该方言在生成 sql 的时候是会加上这个字符的,换成 AnsiSqlDialect 即可: arp.setDialect(new AnsiSqlDialec())
错误还是和之前没区别 @JFinal 只是这一个表查询有问题  
@TableBind(tableName = "sec_token", pkName = "uuid")  //model 的pkName不是id
//配置druid连接池
        DruidXAPlugin druidDefault = new DruidXAPlugin(getProperty("db.default.url"), getProperty("db.default.user"), getProperty("db.default.password"), getProperty("db.default.driver"));
        // StatFilter提供JDBC层的统计信息
        druidDefault.addFilter(new StatFilter());
        // WallFilter的功能是防御SQL注入攻击
        WallFilter wallDefault = new WallFilter();
        wallDefault.setDbType("h2");
        druidDefault.addFilter(wallDefault);

        druidDefault.setInitialSize(getPropertyToInt("db.default.poolInitialSize"));
        druidDefault.setMaxPoolPreparedStatementPerConnectionSize(getPropertyToInt("db.default.poolMaxSize"));
        druidDefault.setTimeBetweenConnectErrorMillis(getPropertyToInt("db.default.connectionTimeoutMillis"));
        plugins.add(druidDefault);

        //Model自动绑定表插件
        AutoMultiSourceTableBindPlugin tableBindDefault = new AutoMultiSourceTableBindPlugin(druidDefault, SimpleNameStyles.LOWER);
        tableBindDefault.setContainerFactory(new CaseInsensitiveContainerFactory(true)); //忽略字段大小写
//    tableBindDefault.addExcludePaths("cn.dreampie.function.shop");
        tableBindDefault.setShowSql(getPropertyToBoolean("devMode", false));
        //非mysql的数据库方言
        tableBindDefault.setDialect(new AnsiSqlDialect());
        plugins.add(tableBindDefault);

DROP TABLE IF EXISTS sec_token;
CREATE TABLE sec_token (
  uuid          VARCHAR(255) NOT NULL  COMMENT '用户编码' PRIMARY KEY,
  username      VARCHAR(255)  NOT NULL  COMMENT '用户名',
  created_at    TIMESTAMP    NOT NULL COMMENT '创建时间',
  expiration_at TIMESTAMP    NOT NULL  COMMENT '结束时间',
  used_to    INT NOT NULL  COMMENT '0是注册,1是手机验证'
);
表结构

JFinal
JFinal
driverCalss 也换成 h2 的
0
Dreampie
Dreampie

引用来自“王仁辉(java)”的评论

引用来自“JFinal”的评论

jfinal activerecord 默认使用 MysqlDialect 方言,该方言在生成 sql 的时候是会加上这个字符的,换成 AnsiSqlDialect 即可: arp.setDialect(new AnsiSqlDialec())
错误还是和之前没区别 @JFinal 只是这一个表查询有问题  
@TableBind(tableName = "sec_token", pkName = "uuid")  //model 的pkName不是id
//配置druid连接池
        DruidXAPlugin druidDefault = new DruidXAPlugin(getProperty("db.default.url"), getProperty("db.default.user"), getProperty("db.default.password"), getProperty("db.default.driver"));
        // StatFilter提供JDBC层的统计信息
        druidDefault.addFilter(new StatFilter());
        // WallFilter的功能是防御SQL注入攻击
        WallFilter wallDefault = new WallFilter();
        wallDefault.setDbType("h2");
        druidDefault.addFilter(wallDefault);

        druidDefault.setInitialSize(getPropertyToInt("db.default.poolInitialSize"));
        druidDefault.setMaxPoolPreparedStatementPerConnectionSize(getPropertyToInt("db.default.poolMaxSize"));
        druidDefault.setTimeBetweenConnectErrorMillis(getPropertyToInt("db.default.connectionTimeoutMillis"));
        plugins.add(druidDefault);

        //Model自动绑定表插件
        AutoMultiSourceTableBindPlugin tableBindDefault = new AutoMultiSourceTableBindPlugin(druidDefault, SimpleNameStyles.LOWER);
        tableBindDefault.setContainerFactory(new CaseInsensitiveContainerFactory(true)); //忽略字段大小写
//    tableBindDefault.addExcludePaths("cn.dreampie.function.shop");
        tableBindDefault.setShowSql(getPropertyToBoolean("devMode", false));
        //非mysql的数据库方言
        tableBindDefault.setDialect(new AnsiSqlDialect());
        plugins.add(tableBindDefault);

DROP TABLE IF EXISTS sec_token;
CREATE TABLE sec_token (
  uuid          VARCHAR(255) NOT NULL  COMMENT '用户编码' PRIMARY KEY,
  username      VARCHAR(255)  NOT NULL  COMMENT '用户名',
  created_at    TIMESTAMP    NOT NULL COMMENT '创建时间',
  expiration_at TIMESTAMP    NOT NULL  COMMENT '结束时间',
  used_to    INT NOT NULL  COMMENT '0是注册,1是手机验证'
);
表结构

DruidPlugin druidDefault = new DruidPlugin(getProperty("db.default.url"), getProperty("db.default.user"), getProperty("db.default.password"), getProperty("db.default.driver"));


db.default.driver=org.h2.Driver
db.default.url=jdbc:h2:file:./db/dreampie
//设置的了的,还是不行   @JFinal
JFinal
JFinal
具体什么错误?
0
Dreampie
Dreampie

引用来自“王仁辉(java)”的评论

引用来自“JFinal”的评论

jfinal activerecord 默认使用 MysqlDialect 方言,该方言在生成 sql 的时候是会加上这个字符的,换成 AnsiSqlDialect 即可: arp.setDialect(new AnsiSqlDialec())
错误还是和之前没区别 @JFinal 只是这一个表查询有问题  
@TableBind(tableName = "sec_token", pkName = "uuid")  //model 的pkName不是id
//配置druid连接池
        DruidXAPlugin druidDefault = new DruidXAPlugin(getProperty("db.default.url"), getProperty("db.default.user"), getProperty("db.default.password"), getProperty("db.default.driver"));
        // StatFilter提供JDBC层的统计信息
        druidDefault.addFilter(new StatFilter());
        // WallFilter的功能是防御SQL注入攻击
        WallFilter wallDefault = new WallFilter();
        wallDefault.setDbType("h2");
        druidDefault.addFilter(wallDefault);

        druidDefault.setInitialSize(getPropertyToInt("db.default.poolInitialSize"));
        druidDefault.setMaxPoolPreparedStatementPerConnectionSize(getPropertyToInt("db.default.poolMaxSize"));
        druidDefault.setTimeBetweenConnectErrorMillis(getPropertyToInt("db.default.connectionTimeoutMillis"));
        plugins.add(druidDefault);

        //Model自动绑定表插件
        AutoMultiSourceTableBindPlugin tableBindDefault = new AutoMultiSourceTableBindPlugin(druidDefault, SimpleNameStyles.LOWER);
        tableBindDefault.setContainerFactory(new CaseInsensitiveContainerFactory(true)); //忽略字段大小写
//    tableBindDefault.addExcludePaths("cn.dreampie.function.shop");
        tableBindDefault.setShowSql(getPropertyToBoolean("devMode", false));
        //非mysql的数据库方言
        tableBindDefault.setDialect(new AnsiSqlDialect());
        plugins.add(tableBindDefault);

DROP TABLE IF EXISTS sec_token;
CREATE TABLE sec_token (
  uuid          VARCHAR(255) NOT NULL  COMMENT '用户编码' PRIMARY KEY,
  username      VARCHAR(255)  NOT NULL  COMMENT '用户名',
  created_at    TIMESTAMP    NOT NULL COMMENT '创建时间',
  expiration_at TIMESTAMP    NOT NULL  COMMENT '结束时间',
  used_to    INT NOT NULL  COMMENT '0是注册,1是手机验证'
);
表结构

引用来自“王仁辉(java)”的评论

DruidPlugin druidDefault = new DruidPlugin(getProperty("db.default.url"), getProperty("db.default.user"), getProperty("db.default.password"), getProperty("db.default.driver"));


db.default.driver=org.h2.Driver
db.default.url=jdbc:h2:file:./db/dreampie
//设置的了的,还是不行   @JFinal
Sql:  SELECT `token`.*  FROM sec_token `token`  WHERE `token`.uuid='27659633-e8ff-436e-9158-daf49dd1ad7a'  AND `token`.expiration_at>'2014-07-07 21:51:53' AND `token`.used_to=0
76962 [qtp1684580278-57] ERROR com.jfinal.core.ActionHandler - /tosignup?token=27659633-e8ff-436e-9158-daf49dd1ad7a
com.jfinal.plugin.activerecord.ActiveRecordException: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement " SELECT ""TOKEN"".*  FROM SEC_TOKEN ""TOKEN""  WHERE ""TOKEN"".UUID='27659633-e8ff-436e-9158-daf49dd1ad7a'  AND ""TOKEN"".EXPIRATION_AT>'2014-07-07 21:51:53' AND ""TOKEN"".USED_TO[*]=0 "; SQL statement:
 SELECT `token`.*  FROM sec_token `token`  WHERE `token`.uuid='27659633-e8ff-436e-9158-daf49dd1ad7a'  AND `token`.expiration_at>'2014-07-07 21:51:53' AND `token`.used_to=0 [42000-178]
	at com.jfinal.plugin.activerecord.Model.find(Model.java:455) ~[jfinal-1.8.jar:na]
	at com.jfinal.plugin.activerecord.Model.findFirst(Model.java:484) ~[jfinal-1.8.jar:na]
	at cn.dreampie.common.web.model.Model.findFirstBy(Model.java:36) ~[classes/:na]
	at cn.dreampie.common.web.controller.Controller.tosignup(Controller.java:62) ~[classes/:na]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_05]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_05]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_05]
	at java.lang.reflect.Method.invoke(Method.java:483) ~[na:1.8.0_05]
	at com.jfinal.core.ActionInvocation.invoke(ActionInvocation.java:55) ~[jfinal-1.8.jar:na]
	at cn.dreampie.common.web.interceptor.UrlInterceptor.intercept(UrlInterceptor.java:29) ~[classes/:na]
	at com.jfinal.core.ActionInvocation.invoke(ActionInvocation.java:51) ~[jfinal-1.8.jar:na]
	at com.jfinal.ext.interceptor.SessionInViewInterceptor.intercept(SessionInViewInterceptor.java:44) ~[jfinal-1.8.jar:na]
	at com.jfinal.core.ActionInvocation.invoke(ActionInvocation.java:51) ~[jfinal-1.8.jar:na]
	at cn.dreampie.common.plugin.shiro.plugin.ShiroInterceptor.intercept(ShiroInterceptor.java:44) ~[classes/:na]
	at com.jfinal.core.ActionInvocation.invoke(ActionInvocation.java:51) ~[jfinal-1.8.jar:na]
	at com.jfinal.core.ActionHandler.handle(ActionHandler.java:73) ~[jfinal-1.8.jar:na]
	at cn.dreampie.common.web.handler.xss.AttackHandler.handle(AttackHandler.java:15) [classes/:na]
	at cn.dreampie.common.web.handler.SkipHandler.handle(SkipHandler.java:27) [classes/:na]
	at cn.dreampie.common.web.handler.ResourceHandler.handle(ResourceHandler.java:28) [classes/:na]
	at cn.dreampie.common.web.handler.AccessDeniedHandler.handle(AccessDeniedHandler.java:30) [classes/:na]
	at cn.dreampie.common.web.handler.FakeStaticHandler.handle(FakeStaticHandler.java:25) [classes/:na]
	at com.jfinal.core.JFinalFilter.doFilter(JFinalFilter.java:72) [jfinal-1.8.jar:na]
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1632) [jetty-servlet-9.1.1.v20140108.jar:9.1.1.v20140108]
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61) [shiro-web-1.2.3.jar:1.2.3]
	at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108) [shiro-web-1.2.3.jar:1.2.3]
	at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137) [shiro-web-1.2.3.jar:1.2.3]
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) [shiro-web-1.2.3.jar:1.2.3]
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66) [shiro-web-1.2.3.jar:1.2.3]
	at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449) [shiro-web-1.2.3.jar:1.2.3]
	at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365) [shiro-web-1.2.3.jar:1.2.3]
	at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90) [shiro-core-1.2.3.jar:1.2.3]
	at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83) [shiro-core-1.2.3.jar:1.2.3]
	at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383) [shiro-core-1.2.3.jar:1.2.3]
	at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362) [shiro-web-1.2.3.jar:1.2.3]
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) [shiro-web-1.2.3.jar:1.2.3]
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1632) [jetty-servlet-9.1.1.v20140108.jar:9.1.1.v20140108]
	at cn.dreampie.common.web.filter.CommonFilter.doFilter(CommonFilter.java:44) [classes/:na]
	at cn.dreampie.common.web.filter.HttpFilter.doFilter(HttpFilter.java:55) [classes/:na]
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1624) [jetty-servlet-9.1.1.v20140108.jar:9.1.1.v20140108]
	at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:550) [jetty-servlet-9.1.1.v20140108.jar:9.1.1.v20140108]
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) [jetty-server-9.1.1.v20140108.jar:9.1.1.v20140108]
	at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:568) [jetty-security-9.1.1.v20140108.jar:9.1.1.v20140108]
	at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:221) [jetty-server-9.1.1.v20140108.jar:9.1.1.v20140108]
	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1110) [jetty-server-9.1.1.v20140108.jar:9.1.1.v20140108]
	at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:479) [jetty-servlet-9.1.1.v20140108.jar:9.1.1.v20140108]
	at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:183) [jetty-server-9.1.1.v20140108.jar:9.1.1.v20140108]
	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1044) [jetty-server-9.1.1.v20140108.jar:9.1.1.v20140108]
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) [jetty-server-9.1.1.v20140108.jar:9.1.1.v20140108]
	at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:199) [jetty-server-9.1.1.v20140108.jar:9.1.1.v20140108]
	at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:109) [jetty-server-9.1.1.v20140108.jar:9.1.1.v20140108]
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97) [jetty-server-9.1.1.v20140108.jar:9.1.1.v20140108]
	at org.eclipse.jetty.server.Server.handle(Server.java:459) [jetty-server-9.1.1.v20140108.jar:9.1.1.v20140108]
	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:281) [jetty-server-9.1.1.v20140108.jar:9.1.1.v20140108]
	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:232) [jetty-server-9.1.1.v20140108.jar:9.1.1.v20140108]
	at org.eclipse.jetty.io.AbstractConnection$1.run(AbstractConnection.java:505) [jetty-io-9.1.1.v20140108.jar:9.1.1.v20140108]
	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:607) [jetty-util-9.1.1.v20140108.jar:9.1.1.v20140108]
	at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:536) [jetty-util-9.1.1.v20140108.jar:9.1.1.v20140108]
	at java.lang.Thread.run(Thread.java:745) [na:1.8.0_05]
Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement " SELECT ""TOKEN"".*  FROM SEC_TOKEN ""TOKEN""  WHERE ""TOKEN"".UUID='27659633-e8ff-436e-9158-daf49dd1ad7a'  AND ""TOKEN"".EXPIRATION_AT>'2014-07-07 21:51:53' AND ""TOKEN"".USED_TO[*]=0 "; SQL statement:
 SELECT `token`.*  FROM sec_token `token`  WHERE `token`.uuid='27659633-e8ff-436e-9158-daf49dd1ad7a'  AND `token`.expiration_at>'2014-07-07 21:51:53' AND `token`.used_to=0 [42000-178]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:344) ~[h2-1.4.178.jar:1.4.178]
	at org.h2.message.DbException.get(DbException.java:178) ~[h2-1.4.178.jar:1.4.178]
	at org.h2.message.DbException.get(DbException.java:154) ~[h2-1.4.178.jar:1.4.178]
	at org.h2.message.DbException.getSyntaxError(DbException.java:190) ~[h2-1.4.178.jar:1.4.178]
	at org.h2.command.Parser.getSyntaxError(Parser.java:517) ~[h2-1.4.178.jar:1.4.178]
	at org.h2.command.Parser.getSpecialType(Parser.java:3664) ~[h2-1.4.178.jar:1.4.178]
	at org.h2.command.Parser.read(Parser.java:3184) ~[h2-1.4.178.jar:1.4.178]
	at org.h2.command.Parser.readColumnIdentifier(Parser.java:3072) ~[h2-1.4.178.jar:1.4.178]
	at org.h2.command.Parser.readTermObjectDot(Parser.java:2579) ~[h2-1.4.178.jar:1.4.178]
	at org.h2.command.Parser.readTerm(Parser.java:2698) ~[h2-1.4.178.jar:1.4.178]
	at org.h2.command.Parser.readFactor(Parser.java:2244) ~[h2-1.4.178.jar:1.4.178]
	at org.h2.command.Parser.readSum(Parser.java:2231) ~[h2-1.4.178.jar:1.4.178]
	at org.h2.command.Parser.readConcat(Parser.java:2201) ~[h2-1.4.178.jar:1.4.178]
	at org.h2.command.Parser.readCondition(Parser.java:2051) ~[h2-1.4.178.jar:1.4.178]
	at org.h2.command.Parser.readAnd(Parser.java:2025) ~[h2-1.4.178.jar:1.4.178]
	at org.h2.command.Parser.readExpression(Parser.java:2015) ~[h2-1.4.178.jar:1.4.178]
	at org.h2.command.Parser.parseSelectSimple(Parser.java:1972) ~[h2-1.4.178.jar:1.4.178]
	at org.h2.command.Parser.parseSelectSub(Parser.java:1853) ~[h2-1.4.178.jar:1.4.178]
	at org.h2.command.Parser.parseSelectUnion(Parser.java:1674) ~[h2-1.4.178.jar:1.4.178]
	at org.h2.command.Parser.parseSelect(Parser.java:1662) ~[h2-1.4.178.jar:1.4.178]
	at org.h2.command.Parser.parsePrepared(Parser.java:434) ~[h2-1.4.178.jar:1.4.178]
	at org.h2.command.Parser.parse(Parser.java:306) ~[h2-1.4.178.jar:1.4.178]
	at org.h2.command.Parser.parse(Parser.java:282) ~[h2-1.4.178.jar:1.4.178]
	at org.h2.command.Parser.prepareCommand(Parser.java:243) ~[h2-1.4.178.jar:1.4.178]
	at org.h2.engine.Session.prepareLocal(Session.java:442) ~[h2-1.4.178.jar:1.4.178]
	at org.h2.engine.Session.prepareCommand(Session.java:384) ~[h2-1.4.178.jar:1.4.178]
	at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1188) ~[h2-1.4.178.jar:1.4.178]
	at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:73) ~[h2-1.4.178.jar:1.4.178]
	at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:276) ~[h2-1.4.178.jar:1.4.178]
	at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:449) ~[druid-0.2.25.jar:0.2.25]
	at com.alibaba.druid.wall.WallFilter.connection_prepareStatement(WallFilter.java:230) ~[druid-0.2.25.jar:0.2.25]
	at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:446) ~[druid-0.2.25.jar:0.2.25]
	at com.alibaba.druid.filter.FilterAdapter.connection_prepareStatement(FilterAdapter.java:928) ~[druid-0.2.25.jar:0.2.25]
	at com.alibaba.druid.filter.FilterEventAdapter.connection_prepareStatement(FilterEventAdapter.java:122) ~[druid-0.2.25.jar:0.2.25]
	at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:446) ~[druid-0.2.25.jar:0.2.25]
	at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.prepareStatement(ConnectionProxyImpl.java:342) ~[druid-0.2.25.jar:0.2.25]
	at com.alibaba.druid.pool.DruidPooledConnection.prepareStatement(DruidPooledConnection.java:311) ~[druid-0.2.25.jar:0.2.25]
	at sun.reflect.GeneratedMethodAccessor19.invoke(Unknown Source) ~[na:na]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_05]
	at java.lang.reflect.Method.invoke(Method.java:483) ~[na:1.8.0_05]
	at com.jfinal.plugin.activerecord.SqlReporter.invoke(SqlReporter.java:58) ~[jfinal-1.8.jar:na]
	at com.sun.proxy.$Proxy34.prepareStatement(Unknown Source) ~[na:na]
	at com.jfinal.plugin.activerecord.Model.find(Model.java:434) ~[jfinal-1.8.jar:na]
	at com.jfinal.plugin.activerecord.Model.find(Model.java:453) ~[jfinal-1.8.jar:na]
	... 57 common frames omitted

@JFinal    错误



返回顶部
顶部