Thanks for taking a look Scott, here it is:
======================
<?xml version="1.0" encoding="UTF-8" ?>
<log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/";
debug="false">
<plugin name="DBReceiver1" class="org.apache.log4j.db.DBReceiver">
<connectionSource
class="org.apache.log4j.db.DriverManagerConnectionSource">
<param name="driverClass" value="com.mysql.jdbc.Driver"/>
<param name="url" value="jdbc:mysql://<server>/<db>"/>
<param name="user" value="<snip>"/>
</connectionSource>
</plugin>
<plugin name="DBReceiver2" class="org.apache.log4j.db.DBReceiver">
<connectionSource
class="org.apache.log4j.db.UrlConnectionSource">
<param name="driverClass" value="com.mysql.jdbc.Driver"/>
<param name="url" value="jdbc:mysql://<server>/<db>"/>
<param name="user" value="<snip>"/>
</connectionSource>
</plugin>
<plugin name="MyDBReceiver"
class="org.apache.log4j.db.CustomSQLDBReceiver">
<param name="sql" value="SELECT logger AS 'LOGGER', event_time AS
'TIMESTAMP', log_level AS 'LEVEL', thread AS 'THREAD', message AS
'MESSAGE', '' AS 'NDC', '' AS 'MDC', 'class_name' AS 'CLASS', method AS
'METHOD', file_name AS 'FILE', line AS 'LINE', '{{application,' +
app_name + ',hostname,' + machine_name + ',log4jid,' + CAST(counter AS
varchar(255)) + '}}' AS 'PROPERTIES', '' AS 'EXCEPTION' FROM
log_event"/>
<connectionSource
class="org.apache.log4j.db.DriverManagerConnectionSource">
<param name="password" value="XXXXX"/>
<param name="user" value="YYYYY"/>
<param name="driverClass" value="com.mysql.jdbc.Driver"/>
<param name="url" value="jdbc:mysql://<server>/<db>"/>
</connectionSource>
<param name="IDField" value="counter"/>
<param name="refreshMillis" value="3000"/>
</plugin>
<root>
<level value="debug"/>
</root>
</log4j:configuration>
======================
> -----Original Message-----
> From: Scott Deboy [mailto:[EMAIL PROTECTED]
> Sent: Thursday, April 21, 2005 10:33 AM
> To: Log4J Users List
> Subject: RE: Chainsaw V2 config file for DBAppender
>
> Can you email the contents of your config file?
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
