DBPrism looging support is based on Apache Log4J project, to avoid problems with XML parsers versions DBPrism include by default log4j.properties file instead of log4j.xml.
This file is located into your Web server deployment directory, for example /usr/local/JDev10g/j2ee/home/applications/dpls/dpls/WEB-INF/classes/ for an OC4J container and a dpls.ear deployment file.
It look like this:
# Set options for appender named "A1".
# Appender "A1" will be a SyslogAppender
log4j.appender.A1=org.apache.log4j.net.SyslogAppender
# The syslog daemon resides on www.abc.net
log4j.appender.A1.SyslogHost=localhost
# A1's layout is a PatternLayout, using the conversion pattern
# %r %-5p %c{2} %M.%L %x - %m\n. Thus, the log output will
# include # the relative time since the start of the application in
# milliseconds, followed by the level of the log request,
# followed by the two rightmost components of the logger name,
# followed by the callers method name, followed by the line number,
# the nested disgnostic context and finally the message itself.
# Refer to the documentation of PatternLayout for further information
# on the syntax of the ConversionPattern key.
log4j.appender.A1.layout=org.apache.log4j.PatternLayout
log4j.appender.A1.layout.ConversionPattern=%-4r %-5p %c{2} %M.%L %x - %m\n
# Set options for appender named "A2"
# A2 should be a RollingFileAppender, with maximum file size of 10 MB
# using at most one backup file. A2's layout is TTCC, using the
# ISO8061 date format with context printing enabled.
log4j.appender.A2=org.apache.log4j.RollingFileAppender
log4j.appender.A2.MaxFileSize=10MB
log4j.appender.A2.MaxBackupIndex=1
log4j.appender.A2.layout=org.apache.log4j.TTCCLayout
log4j.appender.A2.layout.DateFormat=ISO8601
log4j.appender.A2.File=/tmp/dpls.log
# Root logger set to DEBUG using the A2 appender defined above.
log4j.rootLogger=DEBUG, A2
# Logger definitions:
# The SECURITY logger inherits is level from root. However, it's output
# will go to A1 appender defined above. It's additivity is non-cumulative.
log4j.logger.SECURITY=INHERIT, A1
log4j.additivity.SECURITY=false
# Only warnings or above will be logged for the logger "SECURITY.access".
# Output will go to A1.
log4j.logger.SECURITY.access=WARN
# The logger "class.of.the.day" inherits its level from the
# logger hierarchy. Output will go to the appender's of the root
# logger, A2 in this case.
log4j.logger.class.of.the.day=INHERIT
#Refer to the setOption method in each Appender and Layout for class specific options.
The important parts here are the log4j.rootLogger=DEBUG, A2 line which defines the default level of logging and the location of the appender A2 which is based on the RollingFileAppender implementation and log4j.appender.A2.File=/tmp/dpls.log .
In this example the DBPrism logging information will be on the file dpls.log into the directory /tmp/ and this file will growth to a max size of 10Mb.
You can change the file location and the debug level according to your need, also you can use other logging implementations such as Unix Syslog, Windows NT Events and others.
For more information about Log4J options look at the Documentation section of this Apache project.
