Could not open JDBC Connection for transaction~~~Io 异常: The Network Adapter could not establish the

最新推荐文章于 2023-09-02 09:12:08 发布
最新推荐文章于 2023-09-02 09:12:08 发布
阅读量1.1k 收藏
点赞数
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/dhk_0425/article/details/80496866
版权 
org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Io 异常: The Network Adapter could not establish the connection)
	at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:238)
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:374)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:263)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:101)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
	at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:635)
	at cn.com.yto56.coresystem.module.core.frameworkimpl.security.biz.impl.UrlSecurityCheckerImpl$$EnhancerByCGLIB$$1ff72e02.hasPrivilege(<generated>)
	at com.ibm.gbs.ai.portal.framework.server.security.UserSecurity.hasPrivilege(UserSecurity.java:42)
	at com.ibm.gbs.ai.portal.framework.server.interceptor.SecurityInterceptor.isAccessable(SecurityInterceptor.java:422)
	at com.ibm.gbs.ai.portal.framework.server.interceptor.SecurityInterceptor.intercept(SecurityInterceptor.java:213)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
	at com.ibm.gbs.ai.portal.framework.server.interceptor.CommonInterceptor.intercept(CommonInterceptor.java:36)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
	at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:161)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
	at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:265)
	at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)
	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
	at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:138)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
	at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:239)
	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
	at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:191)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
	at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:252)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
	at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:100)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
	at com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:141)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
	at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:145)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
	at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:171)
	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
	at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
	at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:193)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
	at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:189)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
	at com.ibm.gbs.ai.portal.framework.server.interceptor.ErrorInterceptor.intercept(ErrorInterceptor.java:38)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
	at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54)
	at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:563)
	at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)
	at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:99)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:96)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
	at java.lang.Thread.run(Thread.java:662)
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Io 异常: The Network Adapter could not establish the connection)
	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.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:200)
	... 70 more
Caused by: java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
	at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:439)
	at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
	at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
	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)
	... 73 more

第一：没有连接上数据库
第二：少jar包

Mr_Dong先生
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
【异常】GenericJDBCException: cannot open connection
本本本添哥
04-12 274
之前写蓝凌OA的时候，经常会出现这个报错、
Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Connectio
mybwu_com的专栏
10-11 2800
严重: StandardWrapper.Throwableorg.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Connections co...
org.springframework.transaction.CannotCreateTransactionException: 解决方法
Leacode的博客
04-09 1330
org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The server time zone value ‘Öйú±ê×¼Ê
spring+mybatis报错org.springframework.transaction.CannotCreateTransactionException: Could not open JDB
m0_62780794的博客
03-27 6517
Spring+SpringMvc+Mybatis整合出现的报错
mysql 错 Could not open JDBC Connection for transaction； nested exception is java.sql.SQLExceptio
xuexi_gan的博客
03-17 2835
将MySQL的Maven依赖升为5.1.6版本 <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.46</version> </dependency>
单元测试 报 Could not open JDBC Connection for transaction； nested exception is com.mysql.jdbc.exceptions
u010241767的博客
09-02 1433
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.
dbcp 连接池不合理的锁导致连接耗尽解决方案
01-20
DBCP（Database Connection Pool）是Apache的一个开源项目，提供了一个基于Java的数据源连接池实现。在上述问题中，应用程序遇到了由于连接池不合理的锁机制导致的连接耗尽问题，表现为无法从连接池获取新的数据库...
Could not roll back Hibernate transaction.doc
12-08
Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: JDBC rollback failed 这表明Hibernate事务回滚操作失败，导致事务不能正确回滚。 二、问题原因 该问题的...
laravel 解决多库下的DB::transaction()事务失效问题
10-16
在 Laravel 框架中，`DB::transaction()` 是用于执行数据库事务的一种便捷方式，它确保在一组数据库操作中，所有操作要么全部成功，要么全部失败。然而，在处理多数据库环境时，可能会遇到 `DB::transaction()` 事务...
fabric:error validating channel creation transaction for new channel ‘mychannel’
01-20
关键的错误信息是“policy for [Group] /Channel/Application not satisfied: implicit policy evaluation failed – 0 sub-policies were satisfied, but this policy requires 1 of the ‘Admins’ sub-policies ...
kotlin-coroutines-jdbc：用于使用Kotlin Coroutines与阻止JDBC驱动程序进行交互的库
02-06
在kotlin-coroutines-jdbc中，你可以利用`withTransaction`函数来包裹一组数据库操作，形成一个原子性的事务，保证数据的一致性和完整性。即使在事务内部出现异常，所有更改也会被回滚，保持数据库状态的完整。 ...
Could not open JDBC Connection for transaction； nested exception is : Communications link failure
wangxuelei036的博客
08-06 1万+
CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet successfully received from the server was 2,297,746.
org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for
技匠而已
01-22 2万+
博客来源：SSM中本来可以连接数据库。部署上之后长时间不操作不能连接数据库 MessageRequest processing failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is com.mysql.cj.jdbc.exception..
Could not open JDBC Connection for transaction； nested exception is com.alibaba.druid.pool.DataSourc
热门推荐
帝上无天的博客
07-08 2万+
项目中使用了阿里的 Druid 数据库，刚开始很正常，后来发现出现了问题，问题如下： 日志比较多，重点有以下几个： 其他的我们截图看看： 上图打码的地方是公司的dao层查数据库的代码。意思很明白了，就是因为在进行查询的时候，连接已经关闭了，而且会一直刷出这样的日志。综合网上大家的意见，可能原因主要有以下几点： 博主给的答案是： 参考：Druid连接池自动关闭其实这个答案和上面一个的说法一致，不过这个给出了解决方案：是否在定时器中手动获取了 DataSource，然后使用后关闭了或者用完后长期不再用被连接池自
Oracle：IO异常 The Network Adapter could not establish the connection 的三种解决方法
瓦莉拉啦啦的博客
08-08 1万+
Io 异常 The Network Adapter could not establish the connection的三种解决方法
[Oracle]关于Oracle连接Io 异常: The Network Adapter could not establish the connection解决方案
weixin_43303530的博客
11-25 7280
在搭建springboot+redis做缓存时，Oracle居然连接不上，甚至报无法加载驱动类，让我一度以为是jar问题，下面让我们来看看该Oracle连接问题。 首先： 查看报错信息： Registered driver with driverClassName=oracle.jdbc.driver.OracleDriver was not found, trying direct inst......
异常: The Network Adapter could not establish the connection
快乐向日葵
08-27 842
Io 异常: The Network Adapter could not establish the connection 这个异常的出现一般与数据库 设置 和你的计算机的设置 有关，一般程序逻辑是没有问题的。 这种异常的出现大致上有下面4种：   1、oracle配置 oracle9i2中把C:\oracle\ora92\network\admin 目录下的...
Could not open JDBC Connection for transaction;
最新发布
11-23
"Could not open JDBC Connection for transaction"是一个常见的错误，通常是由于数据库连接池中的连接已经关闭或无法创建新连接导致的。以下是可能导致此错误的一些原因和解决方法： 1. 数据库连接池中的连接已经关闭：检查数据库连接池的配置，确保连接池中的连接没有被过早关闭。可以尝试增加连接池的大小或减少连接的最大空闲时间。 2. 数据库连接池中的连接已经用尽：检查数据库连接池的配置，确保连接池中有足够的连接可用。可以尝试增加连接池的大小或减少连接的最大空闲时间。 3. 数据库服务器宕机或网络故障：检查数据库服务器是否正常运行，并确保网络连接正常。 4. 数据库连接参数错误：检查数据库连接参数是否正确，例如数据库URL、用户名和密码等。 5. 数据库驱动版本不兼容：检查数据库驱动版本是否与数据库服务器兼容。 以下是一个可能的解决方案： ```java import javax.sql.DataSource; import org.springframework.jdbc.datasource.DataSourceUtils; import org.springframework.transaction.annotation.Transactional; @Transactional public class MyService { private DataSource dataSource; public void setDataSource(DataSource dataSource) { this.dataSource = dataSource; } public void doSomething() { Connection conn = DataSourceUtils.getConnection(dataSource); try { // do something with the connection } finally { DataSourceUtils.releaseConnection(conn, dataSource); } } } ```

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值