查看hibernate 实际发出的sql语句

最新推荐文章于 2024-04-23 23:53:29 发布

最新推荐文章于 2024-04-23 23:53:29 发布 · 352 阅读

文章标签：

#SQL #Hibernate #log4j

HIbernate 专栏收录该内容

20 篇文章

订阅专栏

本文探讨了在使用Hibernate框架时，通过配置log4j来调试SQL语句的问题。具体而言，当启用DEBUG级别日志记录时，如何正确显示SQL语句中的实际参数，而非仅显示占位符。文章还提供了一个具体的例子来说明问题。

平常的show_sql=true 最后的参数只能看到一个？

log4j设置

log4j.category.org.hibernate.SQL=DEBUG,CA
log4j.category.org.hibernate.type=DEBUG,CA

log

DEBUG 10-03-18 17:26:17,203 main                  [AbstractBatcher.log:346]  select topdsobayi0_.BAYID as BAYID1_, topdsobayi0_.INDEX1 as INDEX1_1_, topdsobayi0_.INDEX1 as INDEX1_39_0_, topdsobayi0_.BAYID as BAYID39_0_, topdsobayi0_.DISCONNECTORID as DISCONNE3_39_0_, topdsobayi0_.DISCONNECTORTYPE as DISCONNE4_39_0_, topdsobayi0_.POSITIONBEGIN as POSITION5_39_0_, topdsobayi0_.POSITIONEND as POSITION6_39_0_, topdsobayi0_.POSITIONGROUD1 as POSITION7_39_0_, topdsobayi0_.POSITIONGROUD2 as POSITION8_39_0_, topdsobayi0_.NodeBegin as NodeBegin39_0_, topdsobayi0_.NodeEnd as NodeEnd39_0_ from JB_TOP_DSO_BAYInfo topdsobayi0_ where topdsobayi0_.BAYID=?
DEBUG 10-03-18 17:26:17,203 main                  [NullableType.nullSafeSet:79]  binding '2228' to parameter: 1

第2行的binding的就是实际参数