mybatis-plus p6spy 报错，java.lang.NoClassDefFoundError: Could not initialize class com.p6spy.engine.sp_com.p6spy.engine.spy.p6drivernotfounderror: error -优快云博客

本文链接：https://blog.youkuaiyun.com/xiaxiaorui2003/article/details/110493487

在按照mybatis-plus官方文档集成p6spy进行SQL分析时，遇到两个错误。错误信息包括`NoClassDefFoundError: Could not initialize class com.p6spy.engine.spy.SpyModule`。排查过程中，确认了pom.xml中依赖正确，配置文件如yml和spy.properties也无误。最终发现是spy.properties文件中的数字2后面多了一个空格导致解析错误，修正后问题解决。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

按照 mybatis-plus的文档来加入 p6spy 后，执行单元测试出现两个错误，

https://baomidou.com/guide/p6spy.html

执行 SQL 分析打印

该功能依赖 p6spy 组件，完美的输出打印 SQL 及执行时长 3.1.0 以上版本

错误1：

java.lang.NoClassDefFoundError: Could not initialize class com.p6spy.engine.spy.P6ModuleManager
	at com.p6spy.engine.spy.P6SpyDriver.findPassthru(P6SpyDriver.java:117)
	at com.p6spy.engine.spy.P6SpyDriver.connect(P6SpyDriver.java:87)
	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
	at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:358)
	at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206)
	at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:477)
	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:560)
	at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115)

错误2：

java.lang.ExceptionInInitializerError
	at com.p6spy.engine.spy.P6SpyDriver.findPassthru(P6SpyDriver.java:117)
	at com.p6spy.engine.spy.P6SpyDriver.connect(P6SpyDriver.java:87)
	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
	at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:358)
	at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206)
	at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:477)
	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:560)
	at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115)
	at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
	at org.springfr