无法记录Hibernate查询log4j(can't log Hibernate queries log4j)

 我正在尝试将hibernate查询记录到webapp特定的日志文件中。 我可以记录任何消息，但我仍然无法记录休眠查询。 
 它们正在server.log内部进行记录，即使是在不同的文件中，但我需要在同一台服务器上运行的每个应用程序的特定于应用程序的日志。 
 我正在使用log4j 1.2 ，我可以创建日志文件，记录传递给控制台但是hibernate查询的每个信息。 
 在database.properties文件中，我找到了hibernate.show_sql=true ，它负责控制台中的日志输出。 这是我引用的那种控制台的日志输出： 
 
 
 
 16：10：3​​5,827 INFO [stdout]（http-localhost-127.0.0.1-8080-1）Hibernate：select [...]（这里输出正确的查询通过，准备语句的? ） 
 
 
 无论如何，我需要的是记录输出。 我尝试了不同的log4j.xml设置，但仍然没有成功，它会创建日志文件但不会记录这些输出。 以下是当前的设置，即将所有内容记录在同一个文件中，当我能够记录甚至是将要分离日志的信息时。 
 
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd" >
<log4j:configuration>
<appender name="mainFileAppender2" class="org.apache.log4j.RollingFileAppender">
   <param name="append" value="false" />
   <param name="maxFileSize" value="100MB" />
   <param name="maxBackupIndex" value="50" />
    <param name="File" value="${webapp.root}/WEB-INF/logs/mainCORE.log"/>
    <layout class="org.apache.log4j.PatternLayout">
        <param name="ConversionPattern" value="%d %-5p %c{1}:%L %m %n" />
    </layout>
</appender>

<appender name="journaldev-hibernate2" class="org.apache.log4j.RollingFileAppender">
    <param name="File" value="${webapp.root}/WEB-INF/logs/hib-queriesCORE.log" />
    <param name="Append" value="false"/><!--value="true" /-->
    <param name="ImmediateFlush" value="true" />
    <param name="MaxFileSize" value="200MB" />
    <param name="MaxBackupIndex" value="50" />

    <layout class="org.apache.log4j.PatternLayout">
        <param name="ConversionPattern" value="%d %d{Z} [%t] %-5p (%F:%L) - %m%n" />
    </layout>
</appender>
<root>
    <priority value="debug"></priority>
<!--    <appender-ref ref="stdout"/>  -->
    <appender-ref ref="mainFileAppender2"/>
</root>
 
 
 该配置会记录除这些输出以外的所有内容 在server.log中记录如下： 
 
 
 
 16：10：3​​5,827 INFO [stdout]（http-localhost-127.0.0.1-8080-1）Hibernate：select [...]（查询的其余部分） 
 

I am trying to log hibernate queries into a webapp specific log file. I can log any message but I am still unable to log hibernate queries.
 Them are being logged inside the server.log, even in a different file, but I need an app-specific log for each app running on the same server.
 I am using log4j 1.2, I am able to create the log files, to log every information passed to console but hibernate queries.
 Inside a database.properties file I found the hibernate.show_sql=true that is responsible for the logging output in console. This is the kind of console's logging output I refer:
 
 
 
16:10:35,827 INFO [stdout] (http-localhost-127.0.0.1-8080-1) Hibernate: select [...](here is outputted the correct query passed, with the ? of the prepared statement)
 
 
Anyway, what I need is to log that output. I tried different log4j.xml settings, but still with no success, it creates log files but does not log those outputs. Here is the current setting, that is logging everything inside the same file, when I will be able to log even those information I will go on separating the logs.
 
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd" >
<log4j:configuration>
<appender name="mainFileAppender2" class="org.apache.log4j.RollingFileAppender">
   <param name="append" value="false" />
   <param name="maxFileSize" value="100MB" />
   <param name="maxBackupIndex" value="50" />
    <param name="File" value="${webapp.root}/WEB-INF/logs/mainCORE.log"/>
    <layout class="org.apache.log4j.PatternLayout">
        <param name="ConversionPattern" value="%d %-5p %c{1}:%L %m %n" />
    </layout>
</appender>

<appender name="journaldev-hibernate2" class="org.apache.log4j.RollingFileAppender">
    <param name="File" value="${webapp.root}/WEB-INF/logs/hib-queriesCORE.log" />
    <param name="Append" value="false"/><!--value="true" /-->
    <param name="ImmediateFlush" value="true" />
    <param name="MaxFileSize" value="200MB" />
    <param name="MaxBackupIndex" value="50" />

    <layout class="org.apache.log4j.PatternLayout">
        <param name="ConversionPattern" value="%d %d{Z} [%t] %-5p (%F:%L) - %m%n" />
    </layout>
</appender>
<root>
    <priority value="debug"></priority>
<!--    <appender-ref ref="stdout"/>  -->
    <appender-ref ref="mainFileAppender2"/>
</root>
 
 
This configuration logs everything but those outputs. In the server.log are logged as follows:
 
 
 
16:10:35,827 INFO [stdout] (http-localhost-127.0.0.1-8080-1) Hibernate: select [...](rest of the query)
 

原文：https://stackoverflow.com/questions/42395740