Early this morning I was woken up by an alert that my CF 10 server (windows) was running out of HDD space. It appeared my hibernatesql.log file was upwards of 20GB! First, I checked my Application.cfc and confirmed logging was disabled...
<cfset this.ormsettings.logsql = false/>
Then I started Googling and discovered there was at least a way to keep the log file from getting so big. You have to modify your /lib/log4j.properties like so...
# HibernateConsole is set to be a ConsoleAppender for Hibernate message using a PatternLayout.
log4j.appender.HIBERNATECONSOLE= org.apache.log4j.RollingFileAppender
log4j.appender.HIBERNATECONSOLE.File=C:/ColdFusion10/cfusion/logs/hibernatesql.log
log4j.appender.HIBERNATECONSOLE.Append=true
log4j.appender.HIBERNATECONSOLE.MaxFileSize=5000KB
log4j.appender.HIBERNATECONSOLE.MaxBackupIndex=3
log4j.appender.HIBERNATECONSOLE.layout=org.apache.log4j.PatternLayout
log4j.appender.HIBERNATECONSOLE.layout.ConversionPattern=%d{MM/dd HH:mm:ss} [%t] HIBERNATE %-5p - %m%n%
This ensures I'm using no more than 15MB of HDD space for my hibernate logging. However, I really want to disable it or at least set the log level to errors only. Any ideas?