[ABI 5.2] 应用服务器连接mysql成功,ABI连接数据库失败

9087
1

jun2020 小试身手Lv3

发表于2021-9-27 09:43

悬赏1

已解决

楼主
问了客服没解决,报错日志如下:



QueryObj ERROR:/abi/edatasource/jdbc.do?name=springbootv2&desc=wljt_综合应用&jdbcUrl=jdbc:mysql://xx.xx.xx.xx:3306/springbootv2?useUnicode=true&characterEncoding=utf8&username=xxx&password=xxxx&driverClassName=com.mysql.jdbc.Driver&extprops={"catalog":"","maxActive":"20","maxWait":"10000","logLevel":"DEBUG"}&action=testjdbc
java.lang.RuntimeException: 测试失败,无法获得数据库链接.
jdbc:mysql://xx.xx.xx.xx:3306/springbootv2?useUnicode=true&characterEncoding=utf8
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 4 milliseconds ago. The last packet sent successfully to the server was 1 milliseconds ago.
at com.esen.jdbc.SqlFunc.testDataSource(SqlFunc.java:1528)
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: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 4 milliseconds ago. The last packet sent successfully to the server was 1 milliseconds ago.
at sun.reflect.GeneratedConstructorAccessor1184.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.SQLError.createCommunicationsException(SQLError.java:989)
at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:175)
at com.mysql.jdbc.MysqlIO.negotiateSSLConnection(MysqlIO.java:4901)
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1659)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1226)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2194)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2225)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2024)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:779)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.GeneratedConstructorAccessor285.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 com.esen.jdbc.SqlFunc.testDataSource(SqlFunc.java:1525)
... 7 more
Caused by: javax.net.ssl.SSLException: Received fatal alert: protocol_version
at sun.security.ssl.Alerts.getSSLException(Alerts.java:208)
at sun.security.ssl.Alerts.getSSLException(Alerts.java:154)
at sun.security.ssl.SSLSocketImpl.recvAlert(SSLSocketImpl.java:2020)
at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:1127)
at sun.security.ssl.SSLSocketImpl.performInitialHandshake(SSLSocketImpl.java:1367)
at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1395)
at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1379)
at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:160)
... 22 more



JavaScript StackTrace:
Error: 测试失败,无法获得数据库链接.
jdbc:mysql://xx.xx.xx.xx:3306/springbootv2?useUnicode=true&characterEncoding=utf8
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 4 milliseconds ago. The last packet sent successfully to the server was 1 milliseconds ago.
--detailmessage--
QueryObj ERROR:/abi/edatasource/jdbc.do?name=springbootv2&desc=wljt_%E7%BB%BC%E5%90%88%E5%BA%94%E7%94%A8&jdbcUrl=jdbc%3Amysql%3A%2F%2Fxx.xx.xx.xx%3A3306%2Fspringbootv2%3FuseUnicode%3Dtrue%26characterEncoding%3Dutf8&username=xxx&password=xxxx&driverClassName=com.mysql.jdbc.Driver&extprops=%7B%22catalog%22%3A%22%22%2C%22maxActive%22%3A%2220%22%2C%22maxWait%22%3A%2210000%22%2C%22logLevel%22%3A%22DEBUG%22%7D&action=testjdbc
java.lang.RuntimeException: 测试失败,无法获得数据库链接.
jdbc:mysql://xx.xx.xx.xx:3306/springbootv2?useUnicode=true&characterEncoding=utf8
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 4 milliseconds ago. The last packet sent successfully to the server was 1 milliseconds ago.
at com.esen.jdbc.SqlFunc.testDataSource(SqlFunc.java:1528)
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: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 4 milliseconds ago. The last packet sent successfully to the server was 1 milliseconds ago.
at sun.reflect.GeneratedConstructorAccessor1184.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.SQLError.createCommunicationsException(SQLError.java:989)
at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:175)
at com.mysql.jdbc.MysqlIO.negotiateSSLConnection(MysqlIO.java:4901)
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1659)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1226)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2194)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2225)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2024)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:779)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.GeneratedConstructorAccessor285.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 com.esen.jdbc.SqlFunc.testDataSource(SqlFunc.java:1525)
... 7 more
Caused by: javax.net.ssl.SSLException: Received fatal alert: protocol_version
at sun.security.ssl.Alerts.getSSLException(Alerts.java:208)
at sun.security.ssl.Alerts.getSSLException(Alerts.java:154)
at sun.security.ssl.SSLSocketImpl.recvAlert(SSLSocketImpl.java:2020)
at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:1127)
at sun.security.ssl.SSLSocketImpl.performInitialHandshake(SSLSocketImpl.java:1367)
at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1395)
at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1379)
at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:160)
... 22 more

--messageInfo--
rootExceptionClass=javax.net.ssl.SSLException
at Object.throwError (http://10.2.7.8:15080/abi/eui/eui.js:2598:19)
at QueryObj.checkResult (http://10.2.7.8:15080/abi/eui/eui.js:3945:9)
at QueryObj._onreadystatechange (http://10.2.7.8:15080/abi/eui/eui.js:3602:11)
at XMLHttpRequest.hp.onreadystatechange (http://10.2.7.8:15080/abi/eui/eui.js:3674:10)

最近看过此主题的会员

esen_5D0MZG98LS

最佳答案
MYSQL8.0没有和ABI522做过兼容性测试
1个回答

只看楼主

果冻出场 数据小白Lv1

发表于2021-9-27 09:43

只看该作者

取消 关注该作者的回复

板凳

MYSQL8.0没有和ABI522做过兼容性测试

登录后可回答问题,请登录注册

快速回复 返回顶部 返回列表

小时

全天响应

分钟

快速处理问题

工程师强势助力

明星产品
解决方案
联系合作

400咨询:400-0011-866

技术支持QQ:400-0011-866(工作日9:00-18:00)

产品建议邮箱yixin@esensoft.com

关注我们

扫TA学习更多干货

一对一专家交流

版权所有© 2006-2024 北京亿信华辰软件有限责任公司 京ICP备07017321号 京公网安备11010802016281号