jfinal 链接数据库问题

Question

严重: Exception starting filter jfinal

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

org.postgresql.util.PSQLException: ERROR: syntax error at or near "`"

  位置：15

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

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

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

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

 at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:281)

 at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:262)

 at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:107)

 at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4775)

 at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5452)

 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:633)

 at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1120)

 at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1678)

 at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)

 at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)

 at java.util.concurrent.FutureTask.run(FutureTask.java:138)

 at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)

 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)

 at java.lang.Thread.run(Thread.java:662)

Caused by: com.jfinal.plugin.activerecord.ActiveRecordException: org.postgresql.util.PSQLException: ERROR: syntax error at or near "`"

  位置：15

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

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

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

 ... 20 more

Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "`"

  位置：15

 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)

 at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)

 at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)

 at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555)

 at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)

 at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:283)

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

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

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

 ... 22 more

2015-11-26 17:42:34 org.apache.catalina.core.StandardContext startInternal

Answer 1

    方言设置不正确，使用提貌似是 sybase 数据库，用的是 oracle 方言。建议使用一下 AnsiSqlDialect： arp.setDialect(new AnsiSqlDialect());