[cf-orm-dev] Enable log4j logging to file

[Dave Ferguson]

I followed all the instructions that were suggested here:
http://www.rupeshk.org/blog/index.php/2009/07/coldfusion-orm-how-to-log-sql/
for logging. However, I can't get logging to go to a file. The only
logging that works is to the console.

Is there something I am missing? I am running CF on OSX if that
matters.

Thanks,

--Dave

--
You received this message because you are subscribed to the Google Groups "cf-orm-dev" group.
To post to this group, send email to cf-or...@googlegroups.com.
To unsubscribe from this group, send email to cf-orm-dev+...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/cf-orm-dev?hl=en.

[Brian Kotek]

If it helps, Dave, here is the log4j file I am using to log SQL to a file:


# Set root category priority to INFO and its only appender to CONSOLE.
log4j.rootCategory=INFO, CONSOLE
#log4j.rootCategory=INFO, CONSOLE, LOGFILE

### Setup Axis Log
log4j.logger.org.apache.axis=WARN, AXISCONSOLE
log4j.additivity.org.apache.axis=false

# Set the enterprise logger category to FATAL and its only appender to CONSOLE.
log4j.logger.org.apache.axis.enterprise=FATAL, AXISCONSOLE

###--------------- Hibernate Log Settings ------
### Set Hibernate log
log4j.logger.org.hibernate=ERROR, HIBERNATELOGFILE, HIBERNATECONSOLE

### log just the SQL
log4j.logger.org.hibernate.SQL=DEBUG, HIBERNATELOGFILE, HIBERNATECONSOLE
log4j.additivity.org.hibernate.SQL=false
### Also log the parameter binding to the prepared statements.
log4j.logger.org.hibernate.type=DEBUG, HIBERNATELOGFILE


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

### log cache activity ###
log4j.logger.org.hibernate.cache=ERROR, HIBERNATECONSOLE
#---------------------------------------------

log4j.logger.net.sf.ehcache=ERROR

# CONSOLE is set to be a ConsoleAppender using a PatternLayout.
log4j.appender.CONSOLE=org.apache.log4j.ConsoleAppender
log4j.appender.CONSOLE.Threshold=INFO
log4j.appender.CONSOLE.layout=org.apache.log4j.PatternLayout
log4j.appender.CONSOLE.layout.ConversionPattern=%d{MM/dd HH:mm:ss} [%t] %-5p %m%n

# AXISCONSOLE is set to be a ConsoleAppender for Axis using a PatternLayout.
log4j.appender.AXISCONSOLE=org.apache.log4j.ConsoleAppender
log4j.appender.AXISCONSOLE.layout=org.apache.log4j.PatternLayout
log4j.appender.AXISCONSOLE.layout.ConversionPattern=%d [%t] AXIS %-5p %c - %m%n

# LOGFILE is set to be a File appender using a PatternLayout.
log4j.appender.LOGFILE=org.apache.log4j.FileAppender
log4j.appender.LOGFILE.File=axis.log
log4j.appender.LOGFILE.Append=true
log4j.appender.LOGFILE.Threshold=INFO
log4j.appender.LOGFILE.layout=org.apache.log4j.PatternLayout
log4j.appender.LOGFILE.layout.ConversionPattern=%-4r [%t] %-5p %c %x - %m%n

# HibernateConsole is set to be a ColsoleAppender for Hibernate message  using a PatternLayout.
log4j.appender.HIBERNATECONSOLE=org.apache.log4j.ConsoleAppender
log4j.appender.HIBERNATECONSOLE.layout=org.apache.log4j.PatternLayout
log4j.appender.HIBERNATECONSOLE.layout.ConversionPattern=%d{MM/dd HH:mm:ss} [%t] HIBERNATE %-5p - %m%n%n

# HibernateLogFile is set to be a FileAppender for Hibernate message  using a PatternLayout.
log4j.appender.HIBERNATELOGFILE=org.apache.log4j.FileAppender
log4j.appender.HIBERNATELOGFILE.layout=org.apache.log4j.PatternLayout
log4j.appender.HIBERNATELOGFILE.layout.ConversionPattern=%d{MM/dd HH:mm:ss} [%t] HIBERNATE %-5p - %m%n%n
log4j.appender.HIBERNATELOGFILE.File=C:/temp/hibernatesql.log
log4j.appender.HIBERNATELOGFILE.Append=false
log4j.appender.HIBERNATELOGFILE.MaxFileSize=500KB
log4j.appender.HIBERNATELOGFILE.MaxBackupIndex=3

[Dave Ferguson]

Thanks for this. Your settings worked for me. The main difference
from what you had to what I had was this part:

log4j.appender.HIBERNATELOGFILE.File=C:/temp/hibernatesql.log

According to what I read it didn't have to be a fully qualified path.
However, unless I put in a full path the log is not written.

Thanks,

--

====================
= Dave Ferguson
====================
= http://blog.dkferguson.com
= http://www.cfhour.com
= Adobe Community Professional
====================