jsf - probleme mit hibernate debug log (log4j)

alan79

Mitglied
Hallo Forum

Ich möchte gerne log4j logging für hibernate konfigurieren. Doch irgendwie erzeugt meine log4j Konfiguration keinerlei Einträge im Log.

Info zur Umgebung:
Eclipse Ganymede
Tomcat 6.0.18 per WTP integriert
Myfaces 1.2.6
Richfaces 3.3
Facelets 1.1.14
Hibernate Core 3.3.0

Hier die Konfiguration von Hibernate:
Code:
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
    <session-factory>
        <property name="hibernate.bytecode.use_reflection_optimizer">false</property>
        <property name="hibernate.connection.autocommit">true</property>
        <property name="hibernate.connection.driver_class">org.gjt.mm.mysql.Driver</property>
        <property name="hibernate.connection.password">Whoop123</property>
        <property name="hibernate.connection.url">jdbc:mysql://localhost/timerep</property>
        <property name="hibernate.connection.username">timerep</property>
        <property name="hibernate.default_catalog">timerep</property>
        <property name="hibernate.dialect">org.hibernate.dialect.MySQLInnoDBDialect</property>
        <property name="hibernate.show_sql">false</property>
        <mapping resource="com/antavis/groupware/model/Projects.hbm.xml" />
        <mapping resource="com/antavis/groupware/model/UserProjects.hbm.xml" />
        <mapping resource="com/antavis/groupware/model/Company.hbm.xml" />
        <mapping resource="com/antavis/groupware/model/Contacts.hbm.xml" />
        <mapping resource="com/antavis/groupware/model/Vacations.hbm.xml" />
        <mapping resource="com/antavis/groupware/model/Invoice.hbm.xml" />
        <mapping resource="com/antavis/groupware/model/Eventinfo.hbm.xml" />
        <mapping resource="com/antavis/groupware/model/News.hbm.xml" />
        <mapping resource="com/antavis/groupware/model/Roles.hbm.xml" />
        <mapping resource="com/antavis/groupware/model/Timereports.hbm.xml" />
        <mapping resource="com/antavis/groupware/model/VwUserRolesTomcat.hbm.xml" />
        <mapping resource="com/antavis/groupware/model/Locations.hbm.xml" />
        <mapping resource="com/antavis/groupware/model/Users.hbm.xml" />
        <mapping resource="com/antavis/groupware/model/Releaseinfo.hbm.xml" />
    </session-factory>
</hibernate-configuration>

Hier die Konfiguration von log4j:
Code:
log4j.rootLogger=DEBUG
#log4j.rootLogger=ERROR, A1

# Global Threshold - overridden by any Categories below.
#log4j.appender.stdout.Threshold=WARN

# Categories
log4j.category.com.antavis=INFO, A2
#log4j.category.com.antavis.groupware.dao=INFO


#HIBERNATE LOG SETTINGS
#log4j.logger.org.hibernate.SQL=DEBUG, HIBLOG
#log4j.additivity.org.hibernate.SQL=false
#log4j.logger.org.hibernate=DEBUG, HIBLOG
log4j.logger.net.sf.hibernate=DEBUG, HIBLOG
### log JDBC bind params ###
log4j.logger.net.sf.hibernate.type=DEBUG
#log4j.logger.org.hibernate.type=debug
#log4j.logger.org.hibernate.engine.QueryParameters=debug



# Appenders
########## Appender A1 (CONSOLE)
log4j.appender.A1=org.apache.log4j.ConsoleAppender
log4j.appender.A1.layout=org.apache.log4j.PatternLayout
log4j.appender.A1.layout.ConversionPattern=[%5p] %d{dd.MM.yyyy HH:mm:ss,SSS} (%F:%M:%L)%m%n
########## Appender A2 (Rolling File)
log4j.appender.A2=org.apache.log4j.RollingFileAppender
log4j.appender.A2.File=c:/temp/groupware.log
# Set the maximum log file size (use KB, MB or GB)
log4j.appender.A2.MaxFileSize=10000KB
# Set the number of log files (0 means no backup files at all)
log4j.appender.A2.MaxBackupIndex=3
# Append to the end of the file or overwrites the file at start.
log4j.appender.A2.Append=false
log4j.appender.A2.layout=org.apache.log4j.PatternLayout
log4j.appender.A2.layout.ConversionPattern=[%5p] %d{dd.MM.yyyy HH:mm:ss,SSS} (%F:%M:%L)%m%n

log4j.appender.HIBLOG=org.apache.log4j.RollingFileAppender
log4j.appender.HIBLOG.File=c:/temp/hibernate.log
# Set the maximum log file size (use KB, MB or GB)
log4j.appender.HIBLOG.MaxFileSize=10000KB
# Set the number of log files (0 means no backup files at all)
log4j.appender.HIBLOG.MaxBackupIndex=3
# Append to the end of the file or overwrites the file at start.
log4j.appender.HIBLOG.Append=false
log4j.appender.HIBLOG.layout=org.apache.log4j.PatternLayout
log4j.appender.HIBLOG.layout.ConversionPattern=[%5p] %d{dd.MM.yyyy HH:mm:ss,SSS} (%F:%M:%L)%m%n

Ich habe nun diverse verschiedene Eintstellungen im log4j.properties ausprobiert. Das File c:\temp\hibernate.log wird wohl erzeugt ist aber immer leer.
Das File c:\temp\groupware.log funktioniert einwandfrei.
Hibernate scheint keinerlei einträge zu erzeugen, egal wo ich das log4j konfiguriere. Das Einzige was funktioniert ist die folgende Einstellung in der Hibernate Konfiguration:
<property name="hibernate.show_sql">false</property>

Dies Erzeugt jedoch lediglich informationen in der Console. Zudem sind die Parameter in den SQL Statements nicht ersichtlich.

Vielen Dank für einen Tipp!
Grüsse
Alan
 
Zurück