Mybatis : DEBUG [main] - PooledDataSource forcefully closed/removed all connections.

最新推荐文章于 2023-04-01 01:25:38 发布
原创 最新推荐文章于 2023-04-01 01:25:38 发布 · 1.4w 阅读 · 4 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。

本文分享了在运行MyBatis代码时遇到的日志级别问题及解决方法，详细介绍了错误的日志配置与正确的日志配置的区别，指出关键在于日志级别设置及特定的logger配置。

出现错误：

  1. DEBUG [main] - Logging initialized using 'class org.apache.ibatis.logging.slf4j.Slf4jImpl' adapter.
  2. DEBUG [main] - Class not found: org.jboss.vfs.VFS
  3. DEBUG [main] - JBoss 6 VFS API is not available in this environment.
  4. DEBUG [main] - Class not found: org.jboss.vfs.VirtualFile
  5. DEBUG [main] - VFS implementation org.apache.ibatis.io.JBoss6VFS is not valid in this environment.
  6. DEBUG [main] - Using VFS adapter org.apache.ibatis.io.DefaultVFS
  7. DEBUG [main] - Find JAR URL: file:/D:/software%20install/chapter09/build/classes/com/company/po
  8. DEBUG [main] - Not a JAR: file:/D:/software%20install/chapter09/build/classes/com/company/po
  9. DEBUG [main] - Reader entry: idCard.class
  10. DEBUG [main] - Reader entry: Person.class
  11. DEBUG [main] - Listing file:/D:/software%20install/chapter09/build/classes/com/company/po
  12. DEBUG [main] - Find JAR URL: file:/D:/software%20install/chapter09/build/classes/com/company/po/idCard.class
  13. DEBUG [main] - Not a JAR: file:/D:/software%20install/chapter09/build/classes/com/company/po/idCard.class
    ----------------------------部分乱字符无法复制
  14. DEBUG [main] - Checking to see if class com.company.po.idCard matches criteria [is assignable to Object]
  15. DEBUG [main] - Checking to see if class com.company.po.Person matches criteria [is assignable to Object]
  16. DEBUG [main] - PooledDataSource forcefully closed/removed all connections.
  17. DEBUG [main] - PooledDataSource forcefully closed/removed all connections.
  18. DEBUG [main] - PooledDataSource forcefully closed/removed all connections.
  19. DEBUG [main] - PooledDataSource forcefully closed/removed all connections.
  20. DEBUG [main] - Opening JDBC Connection
  21. DEBUG [main] - Created connection 1800890735.
  22. DEBUG [main] - Setting autocommit to false on JDBC Connection [com.mysql.jdbc.JDBC4Connection@6b57696f]
  23. DEBUG [main] - ==>  Preparing: select * from tb_person where id=? 
  24. DEBUG [main] - ==> Parameters: 2(Integer)
  25. DEBUG [main] - ====>  Preparing: select * from tb_idcard where id=? 
  26. DEBUG [main] - ====> Parameters: 2(Integer)
  27. DEBUG [main] - <====      Total: 1
  28. DEBUG [main] - <==      Total: 1
  29. Person [id=2, name=Tom, age=29, sex=male, card=idCard [id=2, code=440883199808082121]]
  30. DEBUG [main] - Resetting autocommit to true on JDBC Connection [com.mysql.jdbc.JDBC4Connection@6b57696f]
  31. DEBUG [main] - Closing JDBC Connection [com.mysql.jdbc.JDBC4Connection@6b57696f]
  32. DEBUG [main] - Returned connection 1800890735 to pool.
     

本人在运行mybatis相关代码时，因为这个问题弄了很久才发现，在网上相关的资料比较少，在此分享给大家！欢迎吐槽！！！

错误日志配置：

  1. # Global logging configuration
  2. log4j.rootLogger=DEBUG, stdout
  3. # Console output...
  4. log4j.appender.stdout=org.apache.log4j.ConsoleAppender
  5. log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
  6. log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n

 

正确日志配置：

  1. # Global logging configuration
  2. log4j.rootLogger=ERROR, stdout
  3. # MyBatis logging configuration...
  4. log4j.logger.com.company=DEBUG
  5. # Console output...
  6. log4j.appender.stdout=org.apache.log4j.ConsoleAppender
  7. log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
  8. log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n

原因：少配置的部分是（正确配置部分）第三/第四行代码，以及第二行DEBUG（错误）和ERROR（正确）不同

 

 

 

关注公众号ITCBL，即可得到更多分享哦！

DEBUG [main] - PooledDataSource forcefully closed/removed all connections.
wangshiqi666的博客
04-28 461
日志报错
PooledDataSource forcefully closed/removed all connections解决
热门推荐
lovey030821的博客
05-10 1万+
解决方法： 1，很可能是配置的一些错误，在mybatis的核心配置文件里检查错误 2，MySql8.0的时候，配置的url如下： <property name="url" value="jdbc:mysql://localhost:3306/java505?useSSL=false&amp;serverTimezone=UTC&amp;...
PooledDataSource forcefully closed/removed all connections的解决
weixin_56342559的博客
04-01 2143
PooledDataSource forcefully closed/removed all connections
PooledDataSource类
weixin_34409357的博客
09-01 309
PooledDataSource主要涉及到两个类PooledConnection以及PoolState PooledConnection：PooledDataSource中创建的数据库连接，可以获得实际的realConnection和proxyConnection链接对象，重点说明PooledConnection实现了InvocationHandler（即实现Aop时用到的一种动态代理）接口 ...
"C:\Program Files\Java\jdk-22\bin\java.exe" "-javaagent:C:\Users\Administrator\AppData\Local\JetBrains\IntelliJIdea2025.2\captureAgent\debugger-agent.jar=file:///C:/Users/ADMINI~1/AppData/Local/Temp/capture6298041499272897976.props" -ea -Didea.test.cyclic.buffer.size=1048576 "-javaagent:C:\Program Files\JetBrains\IntelliJ IDEA 2025.2\lib\idea_rt.jar=63160" -Dkotlinx.coroutines.debug.enable.creation.stack.trace=false -Ddebugger.agent.enable.coroutines=true -Dkotlinx.coroutines.debug.enable.flows.stack.trace=true -Dkotlinx.coroutines.debug.enable.mutable.state.flows.stack.trace=true -Dfile.encoding=UTF-8 -Dsun.stdout.encoding=UTF-8 -Dsun.stderr.encoding=UTF-8 -classpath "C:\Program Files\JetBrains\IntelliJ IDEA 2025.2\lib\idea_rt.jar;C:\Program Files\JetBrains\IntelliJ IDEA 2025.2\plugins\junit\lib\junit5-rt.jar;C:\Program Files\JetBrains\IntelliJ IDEA 2025.2\plugins\junit\lib\junit-rt.jar;C:\Users\Administrator\IdeaProjects\Mybatis2\target\test-classes;C:\Users\Administrator\IdeaProjects\Mybatis2\target\classes;C:\Users\Administrator\.m2\repository\mysql\mysql-connector-java\8.0.11\mysql-connector-java-8.0.11.jar;C:\Users\Administrator\.m2\repository\com\google\protobuf\protobuf-java\2.6.0\protobuf-java-2.6.0.jar;C:\Users\Administrator\.m2\repository\org\mybatis\mybatis\3.4.5\mybatis-3.4.5.jar;C:\Users\Administrator\.m2\repository\junit\junit\4.13\junit-4.13.jar;C:\Users\Administrator\.m2\repository\org\hamcrest\hamcrest-core\1.3\hamcrest-core-1.3.jar;C:\Users\Administrator\.m2\repository\org\slf4j\slf4j-api\1.7.20\slf4j-api-1.7.20.jar;C:\Users\Administrator\.m2\repository\ch\qos\logback\logback-classic\1.2.3\logback-classic-1.2.3.jar;C:\Users\Administrator\.m2\repository\ch\qos\logback\logback-core\1.2.3\logback-core-1.2.3.jar" com.intellij.rt.junit.JUnitStarter -ideVersion5 -junit4 MyTest,testFindUserByUnameandAge [DEBUG] [main] o.a.i.l.LogFactory - Logging initialized using 'class org.apache.ibatis.logging.slf4j.Slf4jImpl' adapter. [DEBUG] [main] o.a.i.d.p.PooledDataSource - PooledDataSource forcefully closed/removed all connections. [DEBUG] [main] o.a.i.d.p.PooledDataSource - PooledDataSource forcefully closed/removed all connections. [DEBUG] [main] o.a.i.d.p.PooledDataSource - PooledDataSource forcefully closed/removed all connections. [DEBUG] [main] o.a.i.d.p.PooledDataSource - PooledDataSource forcefully closed/removed all connections. org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for UserMapper.findUserByUnameandAge ### Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for UserMapper.findUserByUnameandAge 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 MyTest.testFindUserByUnameandAge(MyTest.java:20) at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103) at java.base/java.lang.reflect.Method.invoke(Method.java:580) at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:59) at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:56) at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17) at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306) at org.junit.runners.BlockJUnit4ClassRunner$1.evaluate(BlockJUnit4ClassRunner.java:100) at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:366) at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:103) at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:63) at org.junit.runners.ParentRunner$4.run(ParentRunner.java:331) at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:79) at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:329) at org.junit.runners.ParentRunner.access$100(ParentRunner.java:66) at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:293) at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306) at org.junit.runners.ParentRunner.run(ParentRunner.java:413) at org.junit.runner.JUnitCore.run(JUnitCore.java:137) at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:69) at com.intellij.rt.junit.IdeaTestRunner$Repeater$1.execute(IdeaTestRunner.java:38) at com.intellij.rt.execution.junit.TestsRepeater.repeat(TestsRepeater.java:11) at com.intellij.rt.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:35) at com.intellij.rt.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:231) at com.intellij.rt.junit.JUnitStarter.main(JUnitStarter.java:55) Caused by: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for UserMapper.findUserByUnameandAge at org.apache.ibatis.session.Configuration$StrictMap.get(Configuration.java:888) at org.apache.ibatis.session.Configuration.getMappedStatement(Configuration.java:721) at org.apache.ibatis.session.Configuration.getMappedStatement(Configuration.java:714) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) ... 27 more 进程已结束，退出代码为 -1
10-23
这个异常意味着MyBatis在配置中找不到id为"UserMapper.findUserByUnameandAge"的映射语句（Mapped Statement）。 可能的原因及解决方案： 1. **映射文件未加载**： - 确保`UserMapper.xml`映射文件位于类路径...
C:\Users\zhoux\.jdks\openjdk-25\bin\java.exe --enable-preview "-javaagent:C:\Program Files\JetBrains\IntelliJ IDEA 2025.1.3\lib\idea_rt.jar=50074" -Dfile.encoding=UTF-8 -Dsun.stdout.encoding=UTF-8 -Dsun.stderr.encoding=UTF-8 -classpath D:\code\untitled2\out\production\untitled2;C:\Users\zhoux\.m2\repository\org\mybatis\mybatis\3.5.19\mybatis-3.5.19.jar com.unit15.entity.test.test Logging initialized using 'class org.apache.ibatis.logging.stdout.StdOutImpl' adapter. PooledDataSource forcefully closed/removed all connections. PooledDataSource forcefully closed/removed all connections. PooledDataSource forcefully closed/removed all connections. PooledDataSource forcefully closed/removed all connections. Opening JDBC Connection org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: java.sql.SQLException: Error setting driver on UnpooledDataSource. ### The error may exist in mapper/UserMapper.xml ### The error may involve mapper.UserMapper.findAllUser ### The error occurred while executing a query ### Cause: java.sql.SQLException: Error setting driver on UnpooledDataSource. at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:156) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:137) at com.unit15.entity.test.test.main(test.java:22) Caused by: java.sql.SQLException: Error setting driver on UnpooledDataSource. at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.initializeDriver(UnpooledDataSource.java:252) at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.doGetConnection(UnpooledDataSource.java:228) at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.doGetConnection(UnpooledDataSource.java:224) at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.getConnection(UnpooledDataSource.java:97) at org.apache.ibatis.datasource.pooled.PooledDataSource.popConnection(PooledDataSource.java:452) at org.apache.ibatis.datasource.pooled.PooledDataSource.getConnection(PooledDataSource.java:100) at org.apache.ibatis.transaction.jdbc.JdbcTransaction.openConnection(JdbcTransaction.java:145) at org.apache.ibatis.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java:67) at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:348) at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:89) at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:64) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:336) at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:90) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154) ... 4 more Caused by: java.lang.ClassNotFoundException: Cannot find class: #{db.driver} at org.apache.ibatis.io.ClassLoaderWrapper.classForName(ClassLoaderWrapper.java:226) at org.apache.ibatis.io.ClassLoaderWrapper.classForName(ClassLoaderWrapper.java:103) at org.apache.ibatis.io.Resources.classForName(Resources.java:322) at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.lambda$initializeDriver$0(UnpooledDataSource.java:242) at java.base/java.util.concurrent.ConcurrentHashMap.computeIfAbsent(ConcurrentHashMap.java:1724) at org.apache.ibatis.util.MapUtil.computeIfAbsent(MapUtil.java:36) at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.initializeDriver(UnpooledDataSource.java:236) ... 19 more
最新发布
10-24
`java.lang.ClassNotFoundException: Cannot find class: #{db.driver}` 错误通常表示 MyBatis 在尝试加载数据库驱动类时未能找到该类，以下是可能的解决方案： #### 1. 检查依赖 确保项目中已经正确添加了 MySQL ...
mybatis入门
张先森
08-10 1238
MyBatis 保姆式
【MyBatis框架】MyBatis入门程序第二部分
盐汽水的博客
10-11 425
我们通过写一个简单的MyBatis小项目来在实战中学习MyBatis,接着上一篇继续 我们开始实现需求中的添加和删除用户功能 (1)向数据库中添加用户数据 使用User.xml，加入添加用户的sql语句。 <!-- 添加用户 parameterType：指定输入参数类型是pojo(包括用户信息) #{}中指定POJO的属性名，接收到POJO对象的属性值，mybatis通过
结构型-适配器adapter
openCpu
01-11 451
使用适配器模式也是无奈之举，优点亡羊补牢的感觉，主要用于统一接口。通常是软件开发或维护期再考虑使用它。
日常报错记录2： MyBatis：DEBUG [main] - Logging initialized using 'class org.apache.ibatis.logging.slf4j.Slf...
anliu1687的博客
03-14 5392
直接上干货： 报错归纳1： DEBUG [main] - Logging initialized using 'class org.apache.ibatis.logging.slf4j.Slf4jImpl' adapter. 原因：xml里面不能有java方不存在的类，它是会去找的，找不到就报错，所以，万一删掉java类了，xml里面的相对应映射的字段也要注释掉。...
日志工厂配置
weixin_44976835的博客
12-20 821
日志工厂： 如果一个数据库操作出现了异常，我们需要排错，所以要用到日志 logImpl：指定MyBatis所用日志的具体实现，未指定时自动查找 SLF4J LOG4J (常用日志) LOG4J2 JDK_LOGGING COMMONS_LOGGING STDOUT_LOGGING (标准日志工厂) NO_LOGGING 1.STDOUT_LOGGING 在MyBatis中，具体使用那个日志实现，在mybatis-config.xml设置中设定 <settings> <setting n
MyBatis学习笔记(5)
youhebke52011的博客
02-26 446
MyBatis入门之延迟加载resultMap可以实现高级映射（使用association、collection实现一对一及一对多映射），association、collection具备延迟加载功能。延迟加载：先从单表查询、需要时再从关联表去关联查询，大大提高数据库性能，因为查询单表要比关联查询多张表速度要快。使用association实现延迟加载 mapper.xml 需要定义两个mapper
DEBUG [%nt] - Logging initialized using 'class org.apache.ibatis.logging.log4j.Log4jImpl' adapter.DE
LjhBang的博客
12-05 1416
DEBUG [%nt] - Logging initialized using ‘class org.apache.ibatis.logging.log4j.Log4jImpl’ adapter.DEBUG [%nt] - Class not found: org.jboss.vfs.VFSDEBUG [%nt] - JBoss 6 VFS API is not available in this...
mybatis中的坑（可以查询到结果但是不能输出）
kay三石
08-21 2457
通过Junit测试出现错误： java.lang.AbstractMethodError: Method com/mysql/jdbc/PreparedStatement.isClosed()Z is abstract     at com.mysql.jdbc.PreparedStatement.isClosed(PreparedStatement.java)     at sun.refle...
评论 2
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值