Hibernate Log

最新推荐文章于 2023-10-13 18:47:42 发布

原创最新推荐文章于 2023-10-13 18:47:42 发布 · 207 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#java

数据库专栏收录该内容

15 篇文章

订阅专栏

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

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 .