Hibernate Log

iteye_7657

于 2015-04-03 20:41:23 发布

阅读量195

点赞数

CC 4.0 BY-SA版权

分类专栏：数据库文章标签： java

本文链接：https://blog.youkuaiyun.com/iteye_7657/article/details/82617071

数据库专栏收录该内容

15 篇文章

订阅专栏

本文介绍Hibernate日志机制及其限制，特别是在SQL参数记录方面的不足。为解决这一问题，推荐使用JDBC代理驱动来实现更精细的日志记录，包括在同一行中记录SQL语句及其参数，并提供执行时间和调用代码行的跟踪。

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

Hibernate cannot log the SQL and its parameters in the same line like you want . The logging provided by the Hibernate (by setting log4j.logger.org.hibernate.SQL=debug and log4j.logger.org.hibernate.type=trace in the log4j configuration) can only log the SQL and the parameters in the different lines likes this :

insert 
intoAddress(address1, address2, city, province) 
values
    (?,?,?,?)
binding parameter [1]as[VARCHAR]- xxxxxx
binding parameter [2]as[VARCHAR]- xxxxxx
binding parameter [3]as[VARCHAR]- xxxx

You have to use JDBC proxy driver if you want to log the SQL with the parameters in the same line. I have tried log4jdbc and it can do it ,and it also can log the time spent by every SQL statement and log the lines in the code that cause the SQL statements .