Hibernate version: - 3.0
Name and version of the database you are using:DB2390Dialect
The generated SQL (show_sql=false):

Problem: Nothing of Hibernate SQLs etc. getting logged using Log4j.

I don't want the SQLs logged to console. So we have show_sql=false in applicationContext.xml

In log4j.properties file I have the below. There is nothing logged in REPS_SQL.log
==================================
log4j.rootLogger=INFO, stdout, rollingfile

log4j.logger.org.hibernate=info
log4j.logger.org.hibernate.SQL=debug, SQLAppender
log4j.additivity.org.hibernate.SQL=false

# Pattern to output the date/time, calling class and message.
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d{ISO8601} %p %C.%M(): %m%n

log4j.appender.SQLAppender=org.apache.log4j.RollingFileAppender
log4j.appender.SQLAppender.File=/REPS_SQL.log
log4j.appender.SQLAppender.layout=org.apache.log4j.PatternLayout
log4j.appender.SQLAppender.layout.ConversionPattern=%d{ISO8601} %p %C.%M(): %m%n

log4j.appender.rollingfile=org.apache.log4j.RollingFileAppender
log4j.appender.rollingfile.File=/REPS.log
==================================

I turned show_sql to True and I have more log entries then I know what to do with now. Give that a shot. Although now I can't get all the extra hibernate log entries to stop.

Dave Ziebol

By having show_sql to true I do get the SQLs logged but it is in Console. And I want them in custom Log4j log file rather than Console.

=========
I turned show_sql to True and I have more log entries then I know what to do with now. Give that a shot. Although now I can't get all the extra hibernate log entries to stop.

Dave Ziebol
==========