当前位置:网站首页>Nacos程序连接MySQL8.0+ NullPointerException
Nacos程序连接MySQL8.0+ NullPointerException
2022-04-23 15:06:00 【JUST DO YOU LIKE】
1、报错问题:Nacos改用MySQL存储后,启动Nacos服务出现报错
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
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.Util.getInstance(Util.java:408)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:918)
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.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2330)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2083)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:806)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
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:410)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:328)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at JDBC.Demo.main(Demo.java:15)
Caused by: java.lang.NullPointerException
at com.mysql.jdbc.ConnectionImpl.getServerCharset(ConnectionImpl.java:2997)
at com.mysql.jdbc.MysqlIO.sendConnectionAttributes(MysqlIO.java:1934)
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1863)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1226)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2253)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2284)
... 13 more
2、报错原因: mysql-connector-java mysql的Java驱动需要更新到8.0+
3、解决方案
- 在Pom中换到8.0+即可解决问题
<!-- mysql数据库驱动包 --> <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java --> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>8.0.21</version> </dependency>
- 改用低版本,如5.7+,注意Nacos支持5.65版本以上的MySQL
版权声明
本文为[JUST DO YOU LIKE]所创,转载请带上原文链接,感谢
https://blog.csdn.net/qq_36777191/article/details/124335708
边栏推荐
- Async void caused the program to crash
- 分享3个使用工具,在家剪辑5个作品挣了400多
- Llvm - generate local variables
- 多语言通信基础 06 go实现grpc的四种数据流模式实现
- Tencent has written a few words, Ali has written them all for a month
- UML学习_day2
- Lotus DB design and Implementation - 1 Basic Concepts
- Have you learned the basic operation of circular queue?
- Select receives both normal data and out of band data
- 3、 Gradient descent solution θ
猜你喜欢
LeetCode165-比较版本号-双指针-字符串
1 - first knowledge of go language
22年了你还不知道文件包含漏洞?
Explain TCP's three handshakes in detail
Five data types of redis
Advanced version of array simulation queue - ring queue (real queuing)
Leetcode165 compare version number double pointer string
我的 Raspberry Pi Zero 2W 折腾笔记,记录一些遇到的问题和解决办法
win10 任务栏通知区图标不见了
Leetcode162 - find peak - dichotomy - array
随机推荐
Detailed explanation of C language knowledge points -- first understanding of C language [1] - vs2022 debugging skills and code practice [1]
【thymeleaf】处理空值和使用安全操作符
分享3个使用工具,在家剪辑5个作品挣了400多
JS -- realize click Copy function
C language super complete learning route (collection allows you to avoid detours)
多语言通信基础 06 go实现grpc的四种数据流模式实现
Realization of four data flow modes of grpc based on Multilingual Communication
UML learning_ Day2
Frame synchronization implementation
Have you really learned the operation of sequence table?
Nuxt project: Global get process Env information
MySQL error packet out of order
Basic operation of sequential stack
Provided by Chengdu control panel design_ It's detailed_ Introduction to the definition, compilation and quotation of single chip microcomputer program header file
买卖股票的最佳时机系列问题
A series of problems about the best time to buy and sell stocks
Swift protocol Association object resource name management multithreading GCD delay once
Vous ne connaissez pas encore les scénarios d'utilisation du modèle de chaîne de responsabilité?
我的树莓派 Raspberry Pi Zero 2W 折腾笔记,记录一些遇到的问题和解决办法
Detailed analysis of SQL combat of Niuke database (26-30)