wildfly版本是10,p6spy是3.8.7
1:配置wildfly
https://download.csdn.net/download/jiangdaquan/12104426
下载文件,将文件解压到wildfly-10.0.0.Final\modules\system\layers\base\com
2:配置数据源
<driver name="p6" module="com.p6spy">
<driver-class>com.p6spy.engine.spy.P6SpyDriver</driver-class>
<xa-datasource-class>com.p6spy.engine.spy.P6SpyDriver</xa-datasource-class>
</driver>
3:修改解压文件夹下,properties文件夹下的spy.properties
4:正常启动项目
项目访问后,如果sql执行超出设置的时间,standalone/log文件夹下,spy.log文件会记录下超时的sql。更加日志优化代码