Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 3.2

Is it possible to get Hibernate to log into a separate file using the log4j.category entry in log4j.properties. I tried the following in my log4j.properties file and did not work.

......
......

log4j.appender.cm_hibernate_file=org.apache.log4j.FileAppender
log4j.appender.cm_hibernate_file.File=cm.hibernate.log
log4j.appender.cm_hibernate_file.layout=org.apache.log4j.PatternLayout
log4j.appender.cm_hibernate_file.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n


#log4j.logger.org.hibernate=info
log4j.logger.org.hibernate=debug

log4j.category.org.hibernate=DEBUG,cm_hibernate_file
log4j.additivity.org.hibernate=false

...........
...........


Thanks for any help

Take a look at this:
http://ideoplex.com/id/386/controlling-hibernate-output-with-log4j

Basically, you have to put these lines in your log4j.properties

If i put


log4j.rootLogger=warn, file


in the log4j file then all the log goes into that file, I need the Hibernate log alone to go into the hibernate.log file. Here is what i am trying to achieve...


1. All logs except hibernate and my class files go to rootLogger
2. Hibernate logs go to Hibernate.log file
3. My class file logs go to myfile.log