业务系统迁移到 ProxySql 以后,部分业务mysql查询报错:
Caused by: java.sql.SQLException: ##2800 Query: REPLACE INTO ... values(?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [...]
at org.apache.commons.dbutils.AbstractQueryRunner.rethrow(AbstractQueryRunner.java:392)
at org.apache.commons.dbutils.QueryRunner.insertBatch(QueryRunner.java:701)
at org.apache.commons.dbutils.QueryRunner.insertBatch(QueryRunner.java:652)
经排查解决方案如下:
将 mysql-connector-java-5.1.35.jar 升级至 mysql-connector-java-5.1.41.jar 后问题解决