http://logging.apache.org/log4j/companions/receivers/apidocs/org/apache/log4j/db/CustomSQLDBReceiver.html

Add your jdbc jar to the $userhome/.chainsaw/plugins folder and update your chainsaw xml config file to use the receiver (see the Welcome tab - there's a 'view example receiver configuration' button on that tab which contains an example configuration file.

The receiver essentially requires you to define aliases from your columns to fixed columns the receiver is going to use to run the query. It also supports an IDField param, which is assumed to be an auto-incrementing int, which will allow you to 'tail' the events from the database when running the query multiple times (if the refreshMillis param is defined).


Scott Deboy
COMOTIV SYSTEMS
111 SW Columbia Street Ste. 950
Portland, OR 97201

Telephone:    503.224.7496
Cell:       503.997.1367
Fax:        503.222.0185

sdeboy@(protected)

www.comotivsystems.com



-----Original Message-----
From: Rally, Varun [mailto:varun.rally@(protected)]
Sent: Thu 7/3/2008 9:12 AM
To: log4j-user@(protected)
Subject: Question for CustomSQLDBReceiver

Hello All,



I am new to Chainsaw and want to use CustomSQLDBReceiver. Though I have
got an idea of what it is, I am not able to get it running. Please
provide me an internet link or URL that explains the steps to use a
CustomSQLDBReceiver.



Thanks in anticipation.



Regards,
Varun

---------------------------------------------------------------------
To unsubscribe, e-mail: log4j-user-unsubscribe@(protected)
For additional commands, e-mail: log4j-user-help@(protected)