【数据库连接异常】MySQLNonTransientConnectionException: Could not crea
https://i-blog.csdnimg.cn/blog_migrate/9cd73edfd60b66c9ff8f5f38b5199e9d.png#pic_centerhttps://i-blog.csdnimg.cn/blog_migrate/64d223bda69a0f23ba0e2e2e2f7fa4e3.gif#pic_center
个人简介：Java领域新星创作者；阿里云技能博主、星级博主、专家博主；正在Java学习的路上摸爬滚打，记录学习的过程~
个人主页：.29.的博客
学习社区：进去逛一逛~
https://i-blog.csdnimg.cn/blog_migrate/ee8b9619374c0f72fad375c4f32de55b.png#pic_center
一、报错内容
在JDBC连接数据库时，代码没有错，运行却出现报错信息：
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.
at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at org.junit.runners.ParentRunner 2. e v a l u a t e ( P a r e n t R u n n e r . j a v a : 268 ) a t j a v a . l a n g . r e f l e c t . C o n s t r u c t o r . n e w I n s t a n c e ( C o n s t r u c t o r . j a v a : 423 ) a t o r g . j u n i t . r u n n e r s . P a r e n t R u n n e r . r u n ( P a r e n t R u n n e r . j a v a : 363 ) a t c o m . m y s q l . j d b c . U t i l . h a n d l e N e w I n s t a n c e ( U t i l . j a v a : 404 ) a t o r g . j u n i t . r u n n e r . J U n i t C o r e . r u n ( J U n i t C o r e . j a v a : 137 ) a t c o m . m y s q l . j d b c . U t i l . g e t I n s t a n c e ( U t i l . j a v a : 387 ) a t c o m . i n t e l l i j . j u n i t 4. J U n i t 4 I d e a T e s t R u n n e r . s t a r t R u n n e r W i t h A r g s ( J U n i t 4 I d e a T e s t R u n n e r . j a v a : 69 ) a t c o m . m y s q l . j d b c . S Q L E r r o r . c r e a t e S Q L E x c e p t i o n ( S Q L E r r o r . j a v a : 919 ) a t c o m . i n t e l l i j . r t . j u n i t . I d e a T e s t R u n n e r 2.evaluate(ParentRunner.java:268) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at org.junit.runners.ParentRunner.run(ParentRunner.java:363) at com.mysql.jdbc.Util.handleNewInstance(Util.java:404) at org.junit.runner.JUnitCore.run(JUnitCore.java:137) at com.mysql.jdbc.Util.getInstance(Util.java:387) at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:69) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919) at com.intellij.rt.junit.IdeaTestRunner 2.evaluate(ParentRunner.java:268)atjava.lang.reflect.Constructor.newInstance(Constructor.java:423)atorg.junit.runners.ParentRunner.run(ParentRunner.java:363)atcom.mysql.jdbc.Util.handleNewInstance(Util.java:404)atorg.junit.runner.JUnitCore.run(JUnitCore.java:137)atcom.mysql.jdbc.Util.getInstance(Util.java:387)atcom.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:69)atcom.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)atcom.intellij.rt.junit.IdeaTestRunnerRepeater 1. e x e c u t e ( I d e a T e s t R u n n e r . j a v a : 38 ) a t c o m . m y s q l . j d b c . S Q L E r r o r . c r e a t e S Q L E x c e p t i o n ( S Q L E r r o r . j a v a : 898 ) a t c o m . i n t e l l i j . r t . e x e c u t i o n . j u n i t . T e s t s R e p e a t e r . r e p e a t ( T e s t s R e p e a t e r . j a v a : 11 ) a t c o m . m y s q l . j d b c . S Q L E r r o r . c r e a t e S Q L E x c e p t i o n ( S Q L E r r o r . j a v a : 887 ) a t c o m . i n t e l l i j . r t . j u n i t . I d e a T e s t R u n n e r 1.execute(IdeaTestRunner.java:38) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898) at com.intellij.rt.execution.junit.TestsRepeater.repeat(TestsRepeater.java:11) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887) at com.intellij.rt.junit.IdeaTestRunner 1.execute(IdeaTestRunner.java:38)atcom.mysql.jdbc.SQLError.createSQLException(SQLError.java:898)atcom.intellij.rt.execution.junit.TestsRepeater.repeat(TestsRepeater.java:11)atcom.mysql.jdbc.SQLError.createSQLException(SQLError.java:887)atcom.intellij.rt.junit.IdeaTestRunnerRepeater.startRunnerWithArgs(IdeaTestRunner.java:35)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:862)
at com.intellij.rt.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:235)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2331)
at com.intellij.rt.junit.JUnitStarter.main(JUnitStarter.java:54)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2084)
Caused by: java.lang.NullPointerException: null
二、分析与解决
我出现这个问题后，找到的缘故原由是：Maven添加管理的mysql-connector-java依赖版本与下载使用的MySQL版本不划一导致的无法获取数据库连接对象。
[*]Maven添加的版本：5.1.37
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.37</version>
</dependency>
…
[*]现实下载使用的MySQL版本：8.0.31
https://i-blog.csdnimg.cn/blog_migrate/ea8033f791a0ba741bd44bc0de566d1c.png
解决方案：
[*]将IDEA项目中Maven的pom.xml配置文件中添加的依赖版本改为本身正在使用的MySQL版本即可：
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.31</version>
</dependency>
**改完后记得重启IDEA**
测试：
@Test
public void testGetConnection(){
Connection connection = JDBCUtils.getConnection();
System.out.println("connection = " + connection);
}
}
乐成获取连接对象，问题解决：
https://i-blog.csdnimg.cn/blog_migrate/855bba5b8305526be09d819163380239.png
https://i-blog.csdnimg.cn/blog_migrate/dbb549e8f8578d41d8a5e25974bf20be.png#pic_center
免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！更多信息从访问主页：qidao123.com:ToB企服之家，中国第一个企服评测及商务社交产业平台。
页:
[1]