#
# Sample log4j configuration for the MOA-SPSS web service
#

# commons-logging setup
org.apache.commons.logging.LogFactory=org.apache.commons.logging.impl.Log4jFactory

# Define log4j root loggers for the 'moa.spss.server' and 'iaik.server' 
# logging hierarchies.
# All logging output is written to the 'stdout' and 'R' appenders.
# Add JDBC if you also want to write it to the database
log4j.rootLogger=info, stdout, R
log4j.logger.moa.spss.server=info
log4j.logger.iaik.server=info
log4j.moa=debug

# Configure the 'stdout appender' to write logging output to the console
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p | %d{dd HH:mm:ss,SSS} | %t | %m%n

# Configure the rolling file appender 'R' to write logging output
# to the file 'moa-spss.log'. The file is rolled over every 1000KB,
# and a maximum history of 4 log files is being kept.
log4j.appender.R=org.apache.log4j.RollingFileAppender
log4j.appender.R.File=moa-spss.log
log4j.appender.R.MaxFileSize=1000KB
log4j.appender.R.MaxBackupIndex=4
log4j.appender.R.layout=org.apache.log4j.PatternLayout
log4j.appender.R.layout.ConversionPattern=%5p | %d{dd HH:mm:ss,SSS} | %t | %m%n

# Configure the jdbc appender 'JDBC' to write logging output
# to the given PostgreSQL database
# a suitable table called 'spss_log' must have been created in the
# database using the command:
# create table spss_log (log_time timestamp, log_level varchar(5), log_msg varchar(256))
log4j.appender.JDBC=org.apache.log4j.jdbc.JDBCAppender
log4j.appender.JDBC.driver=org.postgresql.Driver
log4j.appender.JDBC.URL=jdbc:postgresql://<servername>/moa?user=moa&password=moatest
log4j.appender.JDBC.layout=org.apache.log4j.PatternLayout
log4j.appender.JDBC.sql=INSERT INTO spss_log (log_time, log_level, log_msg) VALUES ('%d{ yyyy-MM-dd HH:mm:ss.SSS}', '%5p', '%m')