[ABI 5.1] 不支持连接mysql的utf8mb4字符集数据库

这个稍等，需要确认一下~

http://bbs.esensoft.com/thread-135434-1-1.html参考一下这个帖子的url示例

不是连接的问题，是字符集的问题，系统提示不支持utf8mb4

项目有点急，请问排查时间需要多久呢！

报错详情完整复制粘贴到txt发一下

本帖最后由 jun2020 于 2020-5-13 14:42 编辑

{"catalog":"","maxActive":"20","maxWait":"10000","logLevel":"ERROR"}&action=testjdbc
java.lang.RuntimeException: 测试失败,无法获得数据库链接.
jdbc:mysql://112.15.65.96:3306/dbname?useUnicode=true&characterEncoding=utf8mb4
java.sql.SQLException: Unsupported character encoding 'utf8mb4'.
  at com.esen.jdbc.SqlFunc.testDataSource(SqlFunc.java:1471)
  at com.esen.edatasource.api.util.JdbcUtils$1.call(JdbcUtils.java:168)
  at com.esen.edatasource.api.util.JdbcUtils$1.call(JdbcUtils.java:164)
  at com.esen.scheduling.LocaleTask.call(LocaleTask.java:56)
  at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLException: Unsupported character encoding 'utf8mb4'.
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:897)
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:886)
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860)
  at com.mysql.jdbc.ConnectionPropertiesImpl.postInitialization(ConnectionPropertiesImpl.java:2543)
  at com.mysql.jdbc.ConnectionPropertiesImpl.initializeProperties(ConnectionPropertiesImpl.java:2513)
  at com.mysql.jdbc.ConnectionImpl.initializeDriverProperties(ConnectionImpl.java:3142)
  at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:763)
  at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:47)
  at sun.reflect.GeneratedConstructorAccessor395.newInstance(Unknown Source)
  at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
  at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:389)
  at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
  at java.sql.DriverManager.getConnection(DriverManager.java:664)
  at java.sql.DriverManager.getConnection(DriverManager.java:247)
  at com.esen.jdbc.SqlFunc.testDataSource(SqlFunc.java:1468)
  ... 7 more




java.lang.RuntimeException: 测试失败,无法获得数据库链接.
jdbc:mysql://112.15.65.96:3306/dbname?useUnicode=true&characterEncoding=utf8mb4
java.sql.SQLException: Unsupported character encoding 'utf8mb4'.
  at com.esen.jdbc.SqlFunc.testDataSource(SqlFunc.java:1471)
  at com.esen.edatasource.api.util.JdbcUtils$1.call(JdbcUtils.java:168)
  at com.esen.edatasource.api.util.JdbcUtils$1.call(JdbcUtils.java:164)
  at com.esen.scheduling.LocaleTask.call(LocaleTask.java:56)
  at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLException: Unsupported character encoding 'utf8mb4'.
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:897)
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:886)
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860)
  at com.mysql.jdbc.ConnectionPropertiesImpl.postInitialization(ConnectionPropertiesImpl.java:2543)
  at com.mysql.jdbc.ConnectionPropertiesImpl.initializeProperties(ConnectionPropertiesImpl.java:2513)
  at com.mysql.jdbc.ConnectionImpl.initializeDriverProperties(ConnectionImpl.java:3142)
  at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:763)
  at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:47)
  at sun.reflect.GeneratedConstructorAccessor395.newInstance(Unknown Source)
  at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
  at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:389)
  at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
  at java.sql.DriverManager.getConnection(DriverManager.java:664)
  at java.sql.DriverManager.getConnection(DriverManager.java:247)
  at com.esen.jdbc.SqlFunc.testDataSource(SqlFunc.java:1468)
  ... 7 more

--messageInfo--
rootExceptionClass=java.sql.SQLException
at Object.throwError (http://10.20.21.200:8080/abi/eui/eui.js:2598:19)
at QueryObj.checkResult (http://10.20.21.200:8080/abi/eui/eui.js:3942:9)
at QueryObj._onreadystatechange (http://10.20.21.200:8080/abi/eui/eui.js:3599:11)
at XMLHttpRequest.hp.onreadystatechange (http://10.20.21.200:8080/abi/eui/eui.js:3671:10)

发不了附件

好的，我这边问下研发大佬，看研发怎么回复

需要多久啊，有点急，谢谢！