This should go into a Wiki, but here you go: - download the latest developer snapshot from http://people.apache.org/~sdeboy - copy your jdbc driver into your $USERHOME/.chainsaw/plugins folder - copy this example chainsaw config file to your machine: http://svn.apache.org/repos/asf/logging/chainsaw/trunk/src/main/resources/org/apache/log4j/chainsaw/log4j-receiver-sample.xml - delete all of the 'plugin' entries except the customDBReceiver entry - modify that entry to match the SQL statement you need based on the JavaDoc for the CustomSQLDBReceiver...note the explanation of IDField, which prevents allows you to 'tail' the events in the DB by adding a 'where' clause using that Id field (if it is available in your table)..here's the JavaDoc: http://logging.apache.org/log4j/companions/receivers/apidocs/org/apache/log4j/db/CustomSQLDBReceiver.html - start Chainsaw - Load a chainsaw configuration by selecting the 'Use a chainsaw config file' option from the 'Load events into Chainsaw' dialog - Click 'open file' and browse to your config file you created..click 'always start Chainsaw with this configuration' if appropriate
Scott On Tue, Jun 28, 2011 at 7:45 AM, Amit Oberoi <[email protected]>wrote: > Any suggestions ? > > Regards > > Amit oberoi > > -----Original Message----- > From: Amit Oberoi [mailto:[email protected]] > Sent: Tuesday, June 28, 2011 6:16 PM > To: [email protected] > Subject: JDBCReceiver > > All, > > > > I have on several threads on Google suggesting the availability of > JDBCReceiver for chainsaw however I couldn't locate it anywhere. Please > can someone suggest me where can I find it and how can this be > configured with Chainsaw V2. > > > > Regards > > > > Amit Oberoi > > > ======================================================================== > ====================================================Disclaimer: This > message and the information contained herein is proprietary and > confidential and subject to the Tech Mahindra policy statement, you may > review the policy at <a > href="http://www.techmahindra.com/Disclaimer.html";>http://www.techmahind > ra.com/Disclaimer.html</a> externally and <a > href="http://tim.techmahindra.com/Disclaimer.html";>http://tim.techmahind > ra.com/Disclaimer.html</a> internally within Tech > Mahindra.=============================================================== > ============================================================= > > ============================================================================================================================Disclaimer: > This message and the information contained herein is proprietary and > confidential and subject to the Tech Mahindra policy statement, you may > review the policy at <a href="http://www.techmahindra.com/Disclaimer.html > ">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href=" > http://tim.techmahindra.com/Disclaimer.html";> > http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech > Mahindra.============================================================================================================================ > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
