Hi,

I seem to have a problem configuring hibernate and the output for logging messages. For the time being, all hibernate messages appear in the standard output (System.out). I do not want this to happen, instead, I want them stored in a file (eg. hibernate.log). My log4j. properties file looks like the following:



The log file created though, remains empty. What am I doing wrong here? Am I missing some other configuration needed?

Thanks in advance,
Argyro

I don't know how it is configured with properties file but you can use this log4j.xml:

<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">

<log4j:configuration>

<!-- File Logging for deployment -->
<appender name="file" class="org.apache.log4j.RollingFileAppender">
<param name="File" value="logs/log.txt" />
<param name="Append" value="true" />
<param name="MaxFileSize" value="10MB" />
<param name="MaxBackupIndex" value="3" />
<layout class="org.apache.log4j.PatternLayout">
<param name="ConversionPattern" value="%d %-5p %.5X{sessionId} %c - %m\n" />
</layout>
</appender>

<!-- Presentation layer logging -->
<logger name="org.hibernate">
<level value="ALL" />
</logger>

<root>
<level value="WARN" />
<appender-ref ref="file" />
</root>

</log4j:configuration>

Thank you very much, but the problem still remains.

Make sure that the log4j.xml ist the one which is used. Perhaps there are other log4j.xmls or log4j.properites in your classpath?

Make sure you have hibernate.show_sql set to false in your hibernate properties. (http://www.hibernate.org/hib_docs/v3/reference/en/html_single/#configuration-optional)

Having that set to true seems to makes sql output go to std out regardless of other logging settings.

And if you set log4j.debug to true in you system properties, log4j will output where it is loading its properties from. That may help you debug the problem.