1、分页插件问题
修改配置问题
# PageHelper分页插件
pagehelper:
helperDialect: postgresql
reasonable: true
supportMethodsArguments: true
params: count=countSql
2、flyway报错 com.alibaba.druid.sql.parser.ParserException
09:08:44.859 [restartedMain] ERROR c.a.d.f.s.StatFilter - [mergeSql,150] - merge sql error, dbType postgresql, druid-1.2.16, sql : ALTER TABLE "qrtz_blob_triggers" ADD CONSTRAINT "QRTZ_BLOB_TRIGGERS_ibfk_1" FOREIGN KEY ("sched_name", "trigger_name", "trigger_group") REFERENCES "qrtz_triggers" ("sched_name", "trigger_name", "trigger_group") ON DELETE RESTRICT ON UPDATE RESTRICT
com.alibaba.druid.sql.parser.ParserException: syntax error, expect SET, actual RESTRICT pos 229, line 1, column 222, token RESTRICT
at com.alibaba.druid.sql.parser.SQLExprParser.accept(SQLExprParser.java:4610)
com.alibaba.druid解析pg语法出现的错误,暂时没有好的处理方法。能规避错误的方法是修改配置文件中的filter.stat.merge-sql=false
filter:
stat:
enabled: true
# 慢SQL记录
log-slow-sql: true
slow-sql-millis: 1000
merge-sql: false
3、连接函数SQL报错
# 配置检测连接是否有效
validationQuery: SELECT version()