it's not writing to hibernate.log, please find out if there is any fault in properties configuration

Hibernate version: 3.0

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):hibernate.show_sql true

Debug level Hibernate log excerpt:

log4j.configDebug=FALSE
log4j.debug=FALSE

log4j.rootLogger=ERROR, CONSOLE, FILE

#If you set the "additivity" to false for "x.y", its log messages will not end up in the log for "x".
log4j.logger.org.hibernate=DEBUG, HIBERNATE
log4j.additivity.org.hibernate=false
# or you can set HIBERNATE.additivity = false

log4j.logger.abc.runtime.db=DEBUG, DB
log4j.additivity.abc.runtime.db=false

log4j.logger.abc.runtime.ActionServlet=DEBUG

log4j.logger.http.redirect=INFO
log4j.logger.http.request=INFO
log4j.logger.http.parameter=INFO
log4j.logger.http.header=INFO
log4j.logger.http.session=INFO

pattern=%p [%d] [%t] %c{3} %-5r %m%n

log4j.appender.CONSOLE=org.apache.log4j.ConsoleAppender
log4j.appender.CONSOLE.layout=org.apache.log4j.PatternLayout
log4j.appender.CONSOLE.layout.ConversionPattern=${pattern}


log4j.appender.HIBERNATE=org.apache.log4j.RollingFileAppender
log4j.appender.HIBERNATE.File=srd_hibernate.log
#log4j.appender.HIBERNATE.MaxFileSize=1000KB
#log4j.appender.HIBERNATE.MaxBackupIndex=1
log4j.appender.HIBERNATE.Append=false
log4j.appender.HIBERNATE.layout=org.apache.log4j.PatternLayout
log4j.appender.HIBERNATE.layout.ConversionPattern=${pattern}

log4j.appender.FILE=org.apache.log4j.RollingFileAppender
log4j.appender.FILE.File=abc.log
log4j.appender.FILE.MaxFileSize=1000KB
log4j.appender.FILE.MaxBackupIndex=1
log4j.appender.FILE.Append=false
log4j.appender.FILE.layout=org.apache.log4j.PatternLayout
log4j.appender.FILE.layout.ConversionPattern=${pattern}

log4j.appender.DB=org.apache.log4j.RollingFileAppender
log4j.appender.DB.File=abc_picklist.log
log4j.appender.DB.MaxBackupIndex=1
log4j.appender.DB.MaxFileSize=1000KB
log4j.appender.DB.Append=false
log4j.appender.DB.layout=org.apache.log4j.PatternLayout
log4j.appender.DB.layout.ConversionPattern=${pattern}


### direct messages to file hibernate.log ###
#log4j.appender.file=org.apache.log4j.RollingFileAppender
#log4j.appender.file.File=hibernate.log
#log4j.appender.file.layout=org.apache.log4j.PatternLayout
#log4j.appender.file.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n




### log just the SQL
#log4j.logger.org.hibernate.SQL=debug

### log JDBC bind parameters ###
#log4j.logger.org.hibernate.type=info
#log4j.logger.org.hibernate.type=debug

### log schema export/update ###
#log4j.logger.org.hibernate.tool.hbm2ddl=debug

### log HQL parse trees
#log4j.logger.org.hibernate.hql=debug

### log cache activity ###
#log4j.logger.org.hibernate.cache=debug

### log JDBC resource acquisition
#log4j.logger.org.hibernate.jdbc=debug

### enable the following line if you want to track down connection ###
### leakages when using DriverManagerConnectionProvider ###
#log4j.logger.org.hibernate.connection.DriverManagerConnectionProvider=trace3

While we are on the topic of setting the Hibernate Appender in Log4j, what do you need to set in the Log4j XML file? I've only see examples of the properties configuration, not XML.

Sorry I couldn't help, I kept my config XML based...so never used the Hibernate Appender.

There is no Hibernate appender. Hibernate uses commons logging, hence this question should be asked in the Log4j groups.

Christian:

Ja, I guess I got confused by this...which is an implementation to interface with log4j...not something that is included with Hibernate.

http://www.hibernate.org/97.html

Thanks for the clarification! ;)