Could not get JDBC Connection--java

最新推荐文章于 2023-07-12 14:58:01 发布
最新推荐文章于 2023-07-12 14:58:01 发布
阅读量528 收藏
点赞数
文章标签： java 测试 数据库
原文链接：http://www.cnblogs.com/lizhaoE/p/9597568.html
版权

postMan上调用合同服务，后台运行错误，如下：

{
    "timestamp": 1536203887641,
    "status": 500,
    "error": "Internal Server Error",
    "exception": "org.mybatis.spring.MyBatisSystemException",
    "message": "nested exception is org.apache.ibatis.exceptions.PersistenceException: \n### Error querying database.  Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure\n\nThe last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.)\n### The error may exist in file [/Users/lizhao/Documents/code/retail-seal/seal-server/target/classes/mappers/ContractTemplateDetailMapper.xml]\n### The error may involve tech.fullink.stone.seal.server.dao.mappers.ContractTemplateDetailMapper.selectByContractCode\n### The error occurred while executing a query\n### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure\n\nThe last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.)",
    "path": "/retail-seal/api/v1/seal"
}

网上针对“jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection”关键字搜索一番之后，发现并不匹配目前的情况。仔细检查了下数据库连接的各种配置，发现准确无误。

 

实在无解的情况下，针对查询语句写单元测试，发现了不同的错误提示：

### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.)
    at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:150)
    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:77)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)
    ... 40 more
Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.)
    at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
    at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:82)
    at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:68)
    at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:338)
    at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:84)
    at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
    at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:326)
    at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
    at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
    at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)
    at com.github.pagehelper.SqlUtil._processPage(SqlUtil.java:401)
    at com.github.pagehelper.SqlUtil.processPage(SqlUtil.java:374)
    at com.github.pagehelper.PageHelper.intercept(PageHelper.java:254)
    at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
    at com.sun.proxy.$Proxy140.query(Unknown Source)
    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)
    ... 47 more
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.)
    at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
    at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
    at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
    at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
    at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
    ... 67 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the 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:408)
    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1137)
    at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:356)
    at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2504)
    at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2541)
    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2323)
    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:832)
    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
    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:408)
    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:417)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:344)
    at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
    at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
    at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
    at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
    ... 71 more
Caused by: java.net.UnknownHostException: saas.database: nodename nor servname provided, or not known
    at java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method)
    at java.net.InetAddress$2.lookupAllHostAddr(InetAddress.java:928)
    at java.net.InetAddress.getAddressesFromNameService(InetAddress.java:1323)
    at java.net.InetAddress.getAllByName0(InetAddress.java:1276)
    at java.net.InetAddress.getAllByName(InetAddress.java:1192)
    at java.net.InetAddress.getAllByName(InetAddress.java:1126)
    at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:250)
    at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:306)
    ... 87 more

看到提示瞬间明白，因为本服务是其他服务改造的，本地配置没有起作用，删掉云配置ok。

 

总结：单元测试很重要。现有服务改造的服务注意云配置。

转载于:https://www.cnblogs.com/lizhaoE/p/9597568.html

diedun2462
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
sqlite-jdbc-3.34.0.jar
03-24
sqlite-jdbc-3.34.0.jar，支持M1芯片了，Android Studio可以正常链接手机了
protobuf-java-3.4.0.jar包
06-05
Protocol Buffers（简称protobuf）是谷歌的一项技术，用于将结构化的数据序列化、反序列化，经常用于网络传输。
javaweb 项目 Could not get ‘jdbc’ connection 无法连接数据库问题
weixin_44273231的博客
08-03 4070
javaweb项目无法连接数据库问题 1、出错：在导入运行javaweb项目时，数据库一直连接不成功。 2、检测：检查项目路径，代码等等，确保没有出错的地方，db.properties数据库配置文件里各参数（连接数据库名、用户名、密码等等）也正确，但就是一直连接不成功。 3、原因：可能是数据库版本不匹配而导致的。 在进行javaweb课程时，老师给的数据库连接包是 mysql-connector-java-5.0.14.jar（记不清，但是是5.xx的版本），在课程前段时间用这个数据库连接包是没有发生任何问
Could not get JDBC Connection
Ltp_Ltp的博客
01-02 1万+
项目环境： JDK1.6+Tomcat7.078 部分报错信息： Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedExc...
Could not get JDBC Connection; nested exception is java.sql.SQLException: Connections could not
qq892628217的博客
05-01 2万+
1.版本不正确 在检查mysql-connector-java.jar包版本时我发现自己引入的是8.0.11版本的，网上都是5.x的，瞬间感觉不妙了，因为版本问题真的让人头大。 果不其然就是版本问题。 有两种解决方法： 1.退回到5.x版本,其他配置不变 2.修改jdbc.properties文件 jdbc.driver=com.mysql.cj.jdbc.Driver jdbc.url=jdb...
报Could not get JDBC Connection的错误
AnAnCow
03-21 1万+
之前用的都是mysql数据库，这次的项目需要用到Oracle数据库 ，在搭好环境后进行数据库连接测试时报Could not get JDBC Connection;的错误，详细错误如下： ### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nes...
Could not get JDBC Connection nested exception is java.sql.SQLException解决办法
追梦小明
06-06 3万+
一般有两种情况会报这种错 第一种,连接地址写错,缺符合,打错字母都有可能 eg:难以发现的错误实例: 正确写法: 第二种情况,版本不同driver配置不同 6.0以下: 6.0以上多了个cj: 最后这些都没问题的话,那就是jdbc版本和mysql版本差距太大导致的 如果对你有帮助的话,麻烦帮忙点个赞呗. 我是小明,专注于解决日常bug ...
Springboot+MySQL，出现Could not get JDBC Connection
12-14
Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Access denied for user ''@'localhost' (using password: NO) ...
解决Could not get resource 最笨最实用的方法
01-20
解决Could not get resource 最笨最实用的方法 当你在千度万度，找不到方法的时候，静下心来，和我一起： **第一** 找到问题的所在； 编译器描述没有找到文件，我们按照他的路径去搜索文件，关键字（lint） ...
mssql-jdbc-10.2.0.jre8.jar jre11，jre17
03-18
java jdbc方式连接mysql的驱动，来自MS官网下载地址。 https://docs.microsoft.com/zh-cn/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver15
解决问题--Could not get JDBC Connection
dongzhensong的博客
08-24 5530
有的时候包这个错误并非真是用户名密码错误导致的！ 1.查看日志是否是因为服务端口被占用，导致工具类bean未创建成功 解决方式:杀掉占用相应端口的进城、重启PC、修改端口号
Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection；
热门推荐
cm777的博客
01-18 4万+
这几天在用maven写项目 过程中遇到一个坑 是本人粗心大意了 一直报错No suitable driver 然后就一心去找这个错误 网上找了很多遍 大部分都是说oracle驱动问题 于是我怀疑是不是我在maven命令中加入oracle驱动出了问题 但事实证明没有错误 （maven命令下面附图） 驱动换了好几个 依然报错 ojdbc6-11.1.0.6.0这个驱动 会多报一个错 说是这个...
java web jdbc mysql数据库Could not get JDBC Connection异常的一种原因
xcl_language的博客
04-16 1348
java web -- jdbc 关于org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications...
无法获取JDBC连接，eclipse里找不到数据库，navicat可以连接，Could not get JDBC Connection； Unknown database
undefine
12-11 3833
Exceptioninthread"main"org.springframework.jdbc.CannotGetJdbcConnectionException:CouldnotgetJDBCConnection;nestedexceptionisjava.sql.SQLSyntaxErrorException:Unknowndatabase'spring' 今天做java项目的时候，发现了一个错误，连接不上数据库，去网上找了很多方法都不行，后来发现是因为端口的问题。现在发...
Could not get JDBC Connection; nested exception is java.sql.SQLException: Connections could not be a
daa114的博客
06-30 3805
jdbc.driver=com.mysql.cj.jdbc.Driver jdbc.url=jdbc:mysql://localhost:3306/AppStore?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=UTC&rewriteBatchedStatements=true
jdbc配置问题（MySql)
qq_43320246的博客
02-18 1038
Could not get JDBC Connection 错误信息为： Exception in thread “main” org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.mysql.jdbc.exceptions....
(已解决)org.springframework.jdbc.CannotGetJdbcConnectionException:Could not get JDBC Connection；nest
qq_50765135的博客
05-12 2万+
记录一个让人气死的错误 ### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (Access denied for user 'root'@'lo
javaweb报错：Could not get JDBC Connection； nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLNo
dlrb_beautiful的博客
07-06 7160
报错内容： Could not get JDBC Connection; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. 原因：mysql-connecter的jar包太老，mysql版本太新 解决：换个新版本的jar包 ...
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection； nested exc
weixin_45484504的博客
07-12 1584
通过Message file 'oracle.net.mesg.Message' is missing.可以感觉是数据的驱动 或者是数据源没有设置好。在测试环境启动后，页面正常打开，查询数据库请求时，会报这个问题。在查询数据库的时候会报这个错，
Could not get JDBC Connection;
最新发布
07-28
引用\[1\]中提到了一个错误信息："Could not get JDBC Connection; nested exception is java.sql.SQLException: Unknown initial character set index ‘255’ received from server. Initial client character set...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值