create connection SQLException, url: jdbc:mysql://localhost_3306/test, errorCode 0, state 08S01
严重: create connection SQLException, url: jdbc:mysql://localhost_3306/test, errorCode 0, state 08S01
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failureThe last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990)at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:342)at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2197)at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2230)at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2025)at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:778)at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386)at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1652)at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1718)at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2785)
Caused by: java.net.UnknownHostException: 不知道这样的主机。 (localhost_3306)at java.base/java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method)at java.base/java.net.InetAddress$PlatformNameService.lookupAllHostAddr(InetAddress.java:929)at java.base/java.net.InetAddress.getAddressesFromNameService(InetAddress.java:1515)at java.base/java.net.InetAddress$NameServiceAddresses.get(InetAddress.java:848)at java.base/java.net.InetAddress.getAllByName0(InetAddress.java:1505)at java.base/java.net.InetAddress.getAllByName(InetAddress.java:1364)at java.base/java.net.InetAddress.getAllByName(InetAddress.java:1298)at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:188)at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:301)... 15 more
解决办法:
就是value值写错了,导致连接不上:一定要好好检查
<property name="url" value="jdbc:mysql://localhost_3306/test"></property><property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
正确代码:
<property name="url" value="jdbc:mysql://localhost:3306/test"></property><property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
本文来自互联网用户投稿,文章观点仅代表作者本人,不代表本站立场,不承担相关法律责任。如若转载,请注明出处。 如若内容造成侵权/违法违规/事实不符,请点击【内容举报】进行投诉反馈!
