当前位置: 代码迷 >> SQL >> 查看hibernate 现实发出的sql语句
  详细解决方案

查看hibernate 现实发出的sql语句

热度:67   发布时间:2016-05-05 13:13:26.0
查看hibernate 实际发出的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的就是实际参数

1 楼 freecode 2010-03-18  
log4j.logger.org.hibernate.SQL=DEBUG
log4j.logger.org.hibernate.type=TRACE
  相关解决方案