P6spy日志问题为什么每条sql打印两遍

最新推荐文章于 2024-07-08 19:18:40 发布

aliveClass

最新推荐文章于 2024-07-08 19:18:40 发布

阅读量3.3k

点赞数

CC 4.0 BY-SA版权

文章标签： P6spy log 日志 java sql

本文链接：https://blog.youkuaiyun.com/aya19880214/article/details/12967557

在使用P6spy进行数据库监控时，发现每条SQL语句被打印两次。经排查，发现是由于'useprefix'配置项设置导致。通过在'spy.properties'中将'useprefix'设置为true，可以解决SQL重复打印的问题。

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

Hibernate: select tgoodsinfo0_.goodsId as goodsId3_ .....
10:18:49|54|1|statement|select tgoodsinfo0_.goodsId......desc|select tgoodsinfo0_......_.sale=1 order by tgoodsinfo0_.operDate desc
10:18:49|54|6|statement|select tgoodsinfo0_.goodsId......desc|select tgoodsinfo0_......_.sale=1 order by tgoodsinfo0_.operDate desc
10:18:49|-1||resultset|select tgoodsinfo0_.goodsId ......desc|goodsId3_ = 1
10:18:49|-1||resultset|select tgoodsinfo0_.goodsId ......desc|goodsId3_ = 1
10:18:49|-1||resultset|select tgoodsinfo0_.goodsId ......desc|goodsId3_ = 2
10:18:49|-1||resultset|select tgoodsinfo0_.goodsId ......desc|goodsId3_ = 2
10:18:49|-1||resultset|select tgoodsinfo0_.goodsId ......desc|goodsId3_ = 3
10:18:49|-1||resultset|select tgoodsinfo0_.goodsId ......desc|goodsId3_ = 3
10:18:49|-1||resultset|select tgoodsinfo0_.goodsId ......desc|goodsId3_ = 4
10:18:49|-1||resultset|select tgoodsinfo0_.goodsId ......desc|goodsId3_ = 4
10:18:49|-1||resultset|select tgoodsinfo0_.goodsId ......desc|goodsId3_ = 5
10:18:49|-1||resultset|select tgoodsinfo0_.goodsId ......desc|goodsId3_ = 5
10:18:49|-1||resultset|select tgoodsinfo0_.goodsId ......desc|goodsId3_ = 6
10:18:49|-1||resultset|select tgoodsinfo0_.goodsId ......desc|goodsId3_ = 6
10:18:49|1|1|commit||
10:18:49|1|6|commit||