You are viewing a plain text version of this content. The canonical link for it is here.
Posted to log4j-user@logging.apache.org by Ravi Vemuri <Ra...@three.co.uk> on 2004/08/02 16:46:21 UTC
JDBC Async Appender
Hi All,
I am using JDBCAppender to log to the database and want this to be
asynchronous. I am using the XML configuration given below but the logging
is taking much longer than can be expected and the performance is much
better with logging switched off. Can someone please take a look at the
log4j.xml and let me know if there is something wrong or something I need to
do to make it asynchronous.
Thanks,
- Ravi Vemuri
<!--
############################################################################
# -->
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">
<log4j:configuration configDebug="true"
xmlns:log4j="http://jakarta.apache.org/log4j/" >
<appender name="A1" class="org.apache.log4j.ConsoleAppender">
<layout class="org.apache.log4j.PatternLayout">
<param name="ConversionPattern"
value="%d{yyyy-MM-dd HH:mm:ss.SSS} %-5p %-20c{3}
[%x] %m%n"/>
</layout>
</appender>
<appender name="StatsLogger"
class="org.apache.log4j.DailyRollingFileAppender">
<param name="DatePattern"
value="yyyy-MM-dd"/>
<param name="File"
value="c:\\PGA\\logs\\pgastats.log" />
<layout class="org.apache.log4j.PatternLayout">
<param name="ConversionPattern"
value="%d{yyyy-MM-dd HH:mm:ss.SSS} %-5p %-20c{3}
[%x] %m%n"/>
</layout>
</appender>
<appender name="ConsoleLogger"
class="org.apache.log4j.RollingFileAppender">
<param name="DatePattern"
value="yyyy-MM-dd"/>
<param name="File"
value="c:\\PGA\\logs\\pgacoreapp.log" />
<layout class="org.apache.log4j.PatternLayout">
<param name="ConversionPattern"
value="%d{yyyy-MM-dd HH:mm:ss.SSS} %-5p %-20c{3}
[%x] %m%n"/>
</layout>
</appender>
<appender name="DBLogger"
class="adaptor.common.dblogging.DBLogger">
<param name="DatePattern"
value="yyyy-MM-dd"/>
<layout class="org.apache.log4j.PatternLayout">
<param name="ConversionPattern"
value="%d{yyyy-MM-dd HH:mm:ss.SSS} %-5p %-20c{3}
[%x] %m%n"/>
</layout>
</appender>
<appender name="ASYNC" class="org.apache.log4j.AsyncAppender">
<appender-ref ref="DBLogger"/>
</appender>
<category name="a.b">
<priority value="debug" />
<appender-ref ref="ConsoleLogger" />
</category>
<category
name="adaptor.cardtransaction.common.PGAServiceStatistics">
<priority value="info" />
<appender-ref ref="StatsLogger" />
</category>
<logger name="adaptor.common.dblogging.DBLogger"
additivity="false">
<level value="DEBUG"/>
<appender-ref ref="DBLogger"/>
</logger>
<root>
<priority value ="fatal" />
<appender-ref ref="A1" />
</root>
</log4j:configuration>
<!--
############################################################################
# -->
________________________________________________________________________
This e-mail message (including any attachment) is intended only for the personal
use of the recipient(s) named above. This message is confidential and may be
legally privileged. If you are not an intended recipient, you may not review, copy or
distribute this message. If you have received this communication in error, please notify
us immediately by e-mail and delete the original message.
Any views or opinions expressed in this message are those of the author only.
Furthermore, this message (including any attachment) does not create any legally
binding rights or obligations whatsoever, which may only be created by the exchange
of hard copy documents signed by a duly authorised representative of Hutchison
3G UK Limited.
________________________________________________________________________