Java 使用 logback 和 slf4j 记录休眠参数值
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/25516797/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
logging hibernate parameter values using logback and slf4j
提问by CodeMed
I use hibernate, spring mvc, and eclipse. In my eclipse console, the hibernate sql displays in the form of:
我使用 hibernate、spring mvc 和 eclipse。在我的 eclipse 控制台中，hibernate sql 以以下形式显示：
Hibernate: insert into some_table (fieldname1, fieldname2, fieldname3, fieldname4)
values (?, ?, ?, ?)
How can I get the console to print out the values that are being inserted in the place of the question marks?I am committed to using slf4j and logback for the logging in my app.
如何让控制台打印出插入问号位置的值？我致力于使用 slf4j 和 logback 来记录我的应用程序。
Here is my logback.xml:
这是我的 logback.xml：
<?xml version="1.0" encoding="UTF-8"?>
<configuration scan="true" scanPeriod="30 seconds">
<contextListener class="ch.qos.logback.classic.jul.LevelChangePropagator">
<resetJUL>true</resetJUL>
</contextListener>
<!-- To enable JMX Management -->
<jmxConfigurator/>
<appender name="console" class="ch.qos.logback.core.ConsoleAppender">
<encoder>
<pattern>%-5level %logger{0} - %msg%n</pattern>
</encoder>
</appender>
<!--<logger name="org.hibernate" level="debug"/> -->
<logger name="mypackagename.myappname" level="debug"/>
<logger name="org.hibernate.SQL" additivity="false" level="DEBUG" />
<logger name="org.hibernate.type" additivity="false" level="TRACE" />
<root level="info">
<appender-ref ref="console"/>
</root>
</configuration>
采纳答案by CodeMed
The correct working answer turned out to be:
结果正确的工作答案是：
<?xml version="1.0" encoding="UTF-8"?>
<configuration scan="true" scanPeriod="30 seconds">
<contextListener class="ch.qos.logback.classic.jul.LevelChangePropagator">
<resetJUL>true</resetJUL>
</contextListener>
<!-- To enable JMX Management -->
<jmxConfigurator/>
<appender name="console" class="ch.qos.logback.core.ConsoleAppender">
<encoder>
<pattern>%-5level %logger{0} - %msg%n</pattern>
</encoder>
</appender>
<logger name="mypackagename.myappname" level="TRACE"/>
<logger name="org.hibernate.SQL" level="DEBUG" />
<logger name="org.hibernate.type" level="TRACE" />
<root level="info">
<appender-ref ref="console"/>
</root>
</configuration>
回答by Andrey M
Configure org.hibernate.type.descriptor.sql.BasicBinderpackage to log TRACE level:
配置org.hibernate.type.descriptor.sql.BasicBinder包以记录跟踪级别：
<logger name="org.hibernate.type.descriptor.sql.BasicBinder" additivity="false" level="TRACE" />
回答by cesaregb
This is some info about the the 2 offered answers. Both worked for me.
这是有关 2 个提供的答案的一些信息。两者都为我工作。
For printing the query you want:
要打印您想要的查询：
<logger name="org.hibernate.SQL" additivity="false" >
<level value="DEBUG" />
<appender-ref ref="SQLROLLINGFILE" />
<appender-ref ref="STDOUT" />
</logger>
To print it "pretty" you can use the jpaProperties.put("hibernate.format_sql", true|false);More info in [https://docs.jboss.org/hibernate/stable/core.old/reference/en/html/configuration-optional.html]
要打印“漂亮”，您可以使用jpaProperties.put("hibernate.format_sql", true|false);[ https://docs.jboss.org/hibernate/stable/core.old/reference/en/html/configuration-optional.html] 中的更多信息
Now regarding the values. The accepted:
现在关于价值观。接受的：
<logger name="org.hibernate.type" additivity="false" >
<level value="TRACE" />
<appender-ref ref="SQLROLLINGFILE" />
<appender-ref ref="STDOUT" />
</logger>
The output would be:
输出将是：
2017-02-12 14:16:57 DEBUG org.hibernate.SQL -
select
producttyp0_.idProductType as idProduc1_25_1_,
producttyp0_.deleted as deleted2_25_1_,
producttyp0_.description as descript3_25_1_,
producttyp0_.name as name4_25_1_,
products1_.idProductType as idProduc6_25_3_,
products1_.idProduct as idProduc1_24_3_,
products1_.idProduct as idProduc1_24_0_,
products1_.deleted as deleted2_24_0_,
products1_.maxQty as maxQty3_24_0_,
products1_.name as name4_24_0_,
products1_.price as price5_24_0_,
products1_.idProductType as idProduc6_24_0_
from
ProductType producttyp0_
left outer join
Product products1_
on producttyp0_.idProductType=products1_.idProductType
where
producttyp0_.idProductType=?
2017-02-12 14:16:57 TRACE o.h.type.descriptor.sql.BasicBinder - binding parameter [1] as [INTEGER] - [35]
2017-02-12 14:16:57 TRACE o.h.t.descriptor.sql.BasicExtractor - extracted value ([idProduc1_24_0_] : [INTEGER]) - [null]
2017-02-12 14:16:57 TRACE o.h.t.descriptor.sql.BasicExtractor - extracted value ([deleted2_25_1_] : [INTEGER]) - [0]
2017-02-12 14:16:57 TRACE o.h.t.descriptor.sql.BasicExtractor - extracted value ([descript3_25_1_] : [VARCHAR]) - [desc]
2017-02-12 14:16:57 TRACE o.h.t.descriptor.sql.BasicExtractor - extracted value ([name4_25_1_] : [VARCHAR]) - [c0my6zko[test]]
2017-02-12 14:16:57 TRACE o.h.t.descriptor.sql.BasicExtractor - extracted value ([idProduc6_25_3_] : [INTEGER]) - [null]
And the other offered solution
而另一个提供的解决方案
<logger name="org.hibernate.type.descriptor.sql.BasicBinder" additivity="false" level="TRACE" >
<level value="TRACE" />
<appender-ref ref="SQLROLLINGFILE" />
<appender-ref ref="STDOUT" />
</logger>
The output would be:
输出将是：
2017-02-12 14:18:55 DEBUG org.hibernate.SQL -
select
producttyp0_.idProductType as idProduc1_25_1_,
producttyp0_.deleted as deleted2_25_1_,
producttyp0_.description as descript3_25_1_,
producttyp0_.name as name4_25_1_,
products1_.idProductType as idProduc6_25_3_,
products1_.idProduct as idProduc1_24_3_,
products1_.idProduct as idProduc1_24_0_,
products1_.deleted as deleted2_24_0_,
products1_.maxQty as maxQty3_24_0_,
products1_.name as name4_24_0_,
products1_.price as price5_24_0_,
products1_.idProductType as idProduc6_24_0_
from
ProductType producttyp0_
left outer join
Product products1_
on producttyp0_.idProductType=products1_.idProductType
where
producttyp0_.idProductType=?
2017-02-12 14:18:55 TRACE o.h.type.descriptor.sql.BasicBinder - binding parameter [1] as [INTEGER] - [36]
Personally I like the 2nd one because is less info (avoiding the o.h.t.descriptor.sql.BasicExtractor), but its up to the project.
我个人喜欢第二个，因为信息较少（避免使用 ohtdescriptor.sql.BasicExtractor），但这取决于项目。
Hope it gives a little more info about what to include.
希望它提供更多有关要包含的内容的信息。
