更换新版druid连接池报错

springboot -druid连接池的application配置文件

datasource:
 druid:
  driver-class-name:com.ibm.db2.jcc.DB2Driver
  url:jdbc:db2://~~~~~~~~~~~~~~~~~~~~;
  username:~~
  password:~~
  initial-size:5
  min-idle:5
  max-active:20
  max-wait:60000
  time-between-eviction-runs-millis:60000
  min-evictable-idle-time-mills:30000
  validation-query:select 1 from sysibm,sysdummy 1
  test-while-idle:true
  test-on-borrow:false
  test-on-return:false
  pool-prepared-statements:true
  max-pool-prepared-statement-per-connection-size:20
  filters:stat,wall,slf4j
  connection-properties:druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000
  use-global-data-source-stat:true
  filter:
    config:
       enabled:true
 web-stat-filter:
     enabled:true
  start-view-servlet:
     enabled:true

1、其中filters配置中的wall一旦加上，如果mapper.xml 文件中有批量注入的list 变量，就会sql报错，提示依赖注入有误，而且sql中不能有注释。所以需要将wall删掉。
2、若是有表的别名起的和sql关键字一样，比如desc 则会报mergesql的错，需要将connection-properties:druid.stat.mergeSql=true 改成false。