Invoking destroy method 'close' on bean with name 'dataSource'

解决Spring Mybatis整合问题
最新推荐文章于 2023-08-25 17:42:59 发布
转载 最新推荐文章于 2023-08-25 17:42:59 发布 · 1w 阅读 · 0 ·
CC 4.0 BY-SA版权
原文链接：http://www.cnblogs.com/renxiuxing/p/9170710.html
文章标签：

#java

本文分享了在Spring与Mybatis整合过程中遇到的一个常见问题——属性配置错误导致的Invoking destory method 'close' on bean with name 'dataSource'异常，并提供了相应的解决方法。

Invoking destroy method 'close' on bean with name 'dataSource'

  • Spring与Mybatis整合时出现的问题，找了一晚上结果是一个属性写错了，在 .xml 中配置属性时，应该格外注意各个标签、各个属性。


    1080293-20180612001110172-719871844.jpg


    1080293-20180612001141600-2018925625.jpg


    1080293-20180612001455732-1851928274.jpg

转载于:https://www.cnblogs.com/renxiuxing/p/9170710.html

Spring启动源码分析以及生命周期
m0_73311735的博客
09-25 2407
的后处理器回调接口。例如下面两个将一些运行时的元数据解析合并到beanDefinition中。例如。
【JAVA】SpringCloud Feign Ribbon Hystrix Nacos 第一次调用服务报错 close wrong [NA] failed to write cache for d
三也_攻城狮
03-21 5984
全部的报错信息如下 [20-03-21 21:30:36:824][INFO ][org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/]][http-nio-9277-exec-1]Initializing Spring DispatcherServlet 'dispatcherServlet' [20-03-2...
springboot定时任务:同时使用定时任务和websocket报错
weixin_43930851的博客
08-25 4564
定时任务与websocket冲突
日志报错“Couldn't find a destroy method named 'close' on bean with name 'dataSourceFund'”
AoDeXiuSi的博客
08-22 2410
<bean id="dataSourceFund" class="org.springframework.jdbc.datasource.DriverManagerDataSource" destroy-method="close"> <property name="driverClassName" value="${jdbc.driver}" /...
Spring容器中的Bean几种初始化方法和销毁方法的先后顺序
热门推荐
caihaijiang的专栏
03-03 8万+
Spring 容器中的 Bean 是有生命周期的，Spring 允许 Bean 在初始化完成后以及销毁前执行特定的操作。下面是常用的三种指定特定操作的方法： 通过实现InitializingBean/DisposableBean 接口来定制初始化之后/销毁之前的操作方法；通过 元素的 init-method/destroy-method属性指定初始化之后 /销毁之前调用的操作方法；在指定方法
彻底弄懂Spring中Bean的解析、创建和使用
前往JAVA架构的路上
06-28 2890
Spring加载Bean、实例化Bean、获取Bean流程 本文旨在通过分析源码的方式，来剖析Spring加载Bean、实例化Bean、获取Bean的流程，部分核心内容会在源码中说明。内容比较枯燥，慎入！ 第一步，启动一个Spring项目 Spring启动入口 从官方文档中我们可以获取到下面这种Spring的启动方式。 我们传入一个text.xml文件 ApplicationContext context = new ClassPathXmlApplicationContext("classpa
2025-10-22 22:02:26 DEBUG DispatcherServlet:865 - DispatcherServlet with name 'springMVC' processing GET request for [/list] 2025-10-22 22:02:26 DEBUG RequestMappingHandlerMapping:310 - Looking up handler method for path /list 2025-10-22 22:02:26 DEBUG RequestMappingHandlerMapping:317 - Returning handler method [public java.lang.String com.yourcompany.controller.UserController.getUserList(org.springframework.ui.Model)] 2025-10-22 22:02:26 DEBUG DefaultListableBeanFactory:251 - Returning cached instance of singleton bean 'userController' 2025-10-22 22:02:26 DEBUG DispatcherServlet:951 - Last-Modified value for [/list] is: -1 22:02:26.568 [http-nio-8080-exec-2] DEBUG org.mybatis.spring.SqlSessionUtils - Creating a new SqlSession 22:02:26.573 [http-nio-8080-exec-2] DEBUG org.mybatis.spring.SqlSessionUtils - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@40a594c4] was not registered for synchronization because synchronization is not active 2025-10-22 22:02:26 DEBUG DataSourceUtils:110 - Fetching JDBC Connection from DataSource 22:02:26.613 [http-nio-8080-exec-2] INFO com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource - Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource -> caller, dataSourceName -> 1hgeirabe3e4xhqer7gp8|3b2a5f67, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, extensions -> {}, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, forceUseNamedDriverClass -> false, identityToken -> 1hgeirabe3e4xhqer7gp8|3b2a5f67, idleConnectionTestPeriod -> 300, initialPoolSize -> 3, jdbcUrl -> jdbc:mysql://localhost:3306/as3?serverTimezone=UTC&seUnicode=true&characterEncoding=utf8&useSSL=false, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 20, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 5, numHelperThreads -> 3, preferredTestQuery -> null, privilegeSpawnedThreads -> false, properties -> {user=******, password=******}, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, userOverrides -> {}, usesTraditionalReflectiveProxies -> false ] 22:02:26.628 [http-nio-8080-exec-2] DEBUG com.mchange.v2.cfg.MConfig - The configuration file for resource identifier '/mchange-commons.properties' could not be found. Skipping. 22:02:26.628 [http-nio-8080-exec-2] DEBUG com.mchange.v2.cfg.MConfig - The configuration file for resource identifier '/mchange-log.properties' could not be found. Skipping. 22:02:26.628 [http-nio-8080-exec-2] DEBUG com.mchange.v2.cfg.MConfig - The configuration file for resource identifier '/c3p0.properties' could not be found. Skipping. 22:02:26.628 [http-nio-8080-exec-2] DEBUG com.mchange.v2.cfg.MConfig - The configuration file for resource identifier 'hocon:/reference,/application,/c3p0,/' could not be found. Skipping. 22:02:26.628 [http-nio-8080-exec-2] WARN com.mchange.v2.resourcepool.BasicResourcePool - Bad pool size config, start 3 < min 5. Using 5 as start. 22:02:26.630 [http-nio-8080-exec-2] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - com.mchange.v2.resourcepool.BasicResourcePool@49a00888 config: [start -> 5; min -> 5; max -> 20; inc -> 3; num_acq_attempts -> 30; acq_attempt_delay -> 1000; check_idle_resources_delay -> 300000; max_resource_age -> 0; max_idle_time -> 0; excess_max_idle_time -> 0; destroy_unreturned_resc_time -> 0; expiration_enforcement_delay -> 0; break_on_acquisition_failure -> false; debug_store_checkout_exceptions -> false; force_synchronous_checkins -> false] 22:02:26.630 [http-nio-8080-exec-2] DEBUG com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager - Created new pool for auth, username (masked): 'ro******'. 22:02:26.630 [http-nio-8080-exec-2] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - acquire test -- pool size: 0; target_pool_size: 5; desired target? 1 22:02:26.630 [http-nio-8080-exec-2] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - awaitAvailable(): [unknown] 22:02:26.843 [http-nio-8080-exec-2] DEBUG org.mybatis.spring.transaction.SpringManagedTransaction - JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@efcbda1 [wrapping: com.mysql.jdbc.JDBC4Connection@7f63eef7]] will not be managed by Spring 22:02:26.849 [http-nio-8080-exec-2] DEBUG com.yourcompany.dao.UserMapper.getAllUsers - ==> Preparing: SELECT * FROM users 22:02:26.870 [http-nio-8080-exec-2] DEBUG com.yourcompany.dao.UserMapper.getAllUsers - ==> Parameters: 22:02:26.893 [http-nio-8080-exec-2] DEBUG com.yourcompany.dao.UserMapper.getAllUsers - <== Total: 1 22:02:26.898 [http-nio-8080-exec-2] DEBUG org.mybatis.spring.SqlSessionUtils - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@40a594c4] 2025-10-22 22:02:26 DEBUG DataSourceUtils:327 - Returning JDBC Connection to DataSource [User{id=1, name='111', email=11111}]jgeydugwu 2025-10-22 22:02:26 DEBUG DefaultListableBeanFactory:1631 - Invoking afterPropertiesSet() on bean with name 'userList' 2025-10-22 22:02:26 DEBUG DispatcherServlet:1251 - Rendering view [org.springframework.web.servlet.view.JstlView: name 'userList'; URL [/userList.html]] in DispatcherServlet with name 'springMVC' 2025-10-22 22:02:26 DEBUG JstlView:432 - Added model object 'userList' of type [java.util.ArrayList] to request in view with name 'userList' 2025-10-22 22:02:26 DEBUG JstlView:166 - Forwarding to resource [/userList.html] in InternalResourceView 'userList' 2025-10-22 22:02:26 DEBUG DispatcherServlet:865 - DispatcherServlet with name 'springMVC' processing GET request for [/userList.html] 2025-10-22 22:02:26 DEBUG RequestMappingHandlerMapping:310 - Looking up handler method for path /userList.html 2025-10-22 22:02:26 DEBUG RequestMappingHandlerMapping:320 - Did not find handler method for [/userList.html] 2025-10-22 22:02:26 DEBUG SimpleUrlHandlerMapping:190 - Matching patterns for request [/userList.html] are [/**] 2025-10-22 22:02:26 DEBUG SimpleUrlHandlerMapping:219 - URI Template variables for request [/userList.html] are {} 2025-10-22 22:02:26 DEBUG SimpleUrlHandlerMapping:140 - Mapping [/userList.html] to HandlerExecutionChain with handler [ResourceHttpRequestHandler [locations=[ServletContext resource [/WEB-INF/views/]], resolvers=[org.springframework.web.servlet.resource.PathResourceResolver@6d15109c]]] and 1 interceptor 2025-10-22 22:02:26 DEBUG DispatcherServlet:951 - Last-Modified value for [/userList.html] is: -1 2025-10-22 22:02:26 DEBUG DispatcherServlet:1044 - Null ModelAndView returned to DispatcherServlet with name 'springMVC': assuming HandlerAdapter completed request handling 2025-10-22 22:02:26 DEBUG DispatcherServlet:1000 - Successfully completed request 2025-10-22 22:02:26 DEBUG DispatcherServlet:1000 - Successfully completed request
最新发布
10-23
由于没有提供具体的日志内容，...- **解决方案**：检查代码中是否存在未正确关闭数据库连接的情况，确保在使用完连接后及时调用`close()`方法，可开启c3p0的连接泄漏检测功能，通过`unreturnedConnectionTimeout`和`...
Spring framework文档第一章读书笔记
轻松囧的专栏
06-04 2072
该文章是我读Spring英文官方文档的读书笔记，方便以后快速的回忆文档里讲述的内容，而不用再去读一遍官方文档。 文章内容精简掉了官方文档的一些比较浅显易懂的用法，一半是翻译，然后加入部分自己的理解，可以使读者快速的了解Spring提供了些什么功能，以及在什么情况下使用。 该文章只适合有一定Spring使用经验的人，因为博客内容不会讲解某一个功能具体怎么使用，而是只列出Spring有某某功能，以...
Spring源码之事物 Transaction官方文档翻译
AnY11的专栏
12-05 1885
官方文档地址： https://docs.spring.io/spring/docs/4.3.21.RELEASE/spring-framework-reference/htmlsingle/#transaction 介绍Spring框架事务管理 全面的事务支持是使用Spring框架的最令人信服的原因之一。Spring框架为事务管理提供了一致的抽象，提供了以下好处: 跨不同事务API(如J...
spring整合myabtis异常之Invocation of destroy method 'close' failed on bean with name 'sqlSessionTemplate'
静若清池，动如涟漪_
07-18 4720
1、异常描述 spring和myabtis整合时，出现以下异常： -Invocation of destroy method 'close' failed on bean with name 'sqlSessionTemplate': java.lang.UnsupportedOperationException: Manual close is not allowed over a Spr...
Invocation of destroy method 'close' failed on bean with name 'sqlSession'
weixin_30652897的博客
04-03 1794
问题解决 配置文件中添加这个属性： scope="prototype"的bean容器在接受到该类型的对象的请求的时候，会每次都重新生成一个新的对象给请求方;scope="singleton"的bean是由容器来保证这种类型的bean在同一个容器内只存在一个共享实例 转载于:https://www.cnblogs.com/cuijiade/p/8707340.html...
JavaEE_Mybatis_SpringMVC_整合开发奇葩问题1：dataSource报错？
迎难而上
12-04 4845
问题 DEBUG日志 DEBUG [main] - Listing file:/D:/Java_Web_Project/SpringMvc_MyBatis_test2/WebRoot/WEB-INF/classes/cn/itcast/ssm/po DEBUG [main] - Find JAR URL: file:/D:/Java_Web_Project/SpringMvc_MyBatis_t
nacos报错Client not connected,current status:STARTING,StatusRuntimeException
赵得C
03-18 1万+
nacos报错Client not connected,current status:STARTING,StatusRuntimeException。降低nacos-client版本。
Linux下Tomcat项目启动报错
Loneliness Ends HUHU
06-10 1499
                            Linux下Tomcat项目启动报错org.springframework.beans.factory.CannotLoadBeanClassException: Error loading class [com.bw.yun.service.impl.UserServiceImpl] for bean with name 'userServ...
linux下项目启动报错,Linux下Tomcat项目启动报错
weixin_39822147的博客
05-13 1075
Linux下Tomcat项目启动报错org.springframework.beans.factory.CannotLoadBeanClassException: Error loading class [com.bw.yun.service.impl.UserServiceImpl] for bean with name 'userServiceImpl' defined in file [/h...
nacos服务注册和服务发现源码解析
jiongsui7605的博客
07-04 1553
1、nacos服务注册 1.1、spring cloud nacos服务注册 1. com.alibaba.cloud.nacos.NacosDiscoveryAutoConfiguration在spring-cloud-alibaba-nacos-discovery的META-INF的spring.factories中增加了spi扩展点 org.springframework.boot.autoconfigure.EnableAutoConfiguration=\ com.alibaba.cloud.
spring技术内幕笔记：ApplicationContext和Bean的初始化及销毁
S-H_A-N
07-19 1247
spring版本：4.3.8.RELEASE ApplicationContex容器自身也有一个初始化和销t毁关闭的过程。ApplicationContext启动的过程是在AbstractApplicationContext中实现的。在使用应用上下文时需要做一些准备工作，这些准备工作在prepareBeanFactory方法中实现，在这个方法中，为容器配置了ClassLoader、Propert
火山引擎对象存储下载Error invoking remote method
07-11
在使用火山引擎对象存储服务时，如果下载文件过程中遇到“Error invoking remote method”错误，通常表明存在与远程方法调用相关的异常。这种错误可能由多种原因引起，包括但不限于网络连接问题、权限配置不当或API...
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符  | 博主筛选后可见
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值