CustomSQLDBReceiver was left out of the db jar in the 1.3 alpha 6 release because of a problem with the ant script.
I've fixed the ant problem so if you feel like building from CVS, the db jar will contain the class. The class is available with the 1.3 alpha 6 download - in src/java/org/apache/log4j/db - You could compile it and add it to your classpath set in chainsaw.bat, and it should work ok. 1.3 alpha 6 is available here: http://logging.apache.org/site/binindex.cgi Scott -----Original Message----- From: Tan Kah Siong [mailto:[EMAIL PROTECTED] Sent: Tue 6/14/2005 6:00 PM To: Log4J Users List Cc: Subject: RE: CustomSQLDBReceiver I had followed the instructions to loading the config file. I had the error encountered attached. It seems that the SQLreceiver class cannot be found. The program was run using the provided chainsaw.bat. Thanks --- Scott Deboy <[EMAIL PROTECTED]> wrote: > 1. The file-load menu items are provided as a way to > process a log file created by a file appender > configured to use XMLLayout. > > Instead, configure Chainsaw this way: > > Open Chainsaw > Select the view-show application wide preferences > menu > > In the 'automatic configuration url' field at the > bottom, specify the URL to your config file. > Example: file:///c:/mysql-chainsaw-config.xml > > Restart Chainsaw > > 2. Chainsaw does support custom fields and > CustomSQLDBReceiver provides a way to pass them to > Chainsaw. Customsqldbreceiver expects all > properties to be combined into a single string and > returned as the PROPERTIES field in the SQL > statement. This field is then parsed into the > individual properties, thus the need for concat. > Ugly but it works. If you feel like contributing a > patch to improve the receiver in this area, please > do! > > 3. There is a JNDIConnectionSource, which can be > pooled. See > http://logging.apache.org/log4j/docs/api-1.3/org/apache/log4j/db/JNDIConnectionSource.html > > Scott > > -----Original Message----- > From: Tan Kah Siong [mailto:[EMAIL PROTECTED] > Sent: Tue 6/14/2005 2:12 AM > To: [email protected] > Cc: > Subject: CustomSQLDBReceiver > Hi, > > I am interested in using my mssql server as a base > for > Chainsaw log viewer. > > I had tried to do this after reading the > documentation > and encountered the following problems and > questions. > > I had edited the Example Receiver configuration by > deleting away all plugins except CustomDBReceiver. I > also changed the connection source's password, user, > driver and url to my requirements. Lastly i used a > sql > statement that would utilise the compulsary fields > as > stated in the documentation, without the concat > part. > The sql server i used is setup with the > corresponding > fields. > > I fired up ChainSaw and loaded the edited xml file > through the "Load Log4J File" menu, however, nothing > happens after that, no loading nor errors. I also > see > no network activity that indicates attempts to > contact > sql server. > > 1) Is there any step i missed or gone wrong? > > 2) I noted that chainsaw support only the documented > fields, can it support other custom fields. ?Using > concat? > > 3) How would i use pooled connections with ChainSaw? > > Please advice. > > > > __________________________________ > Discover Yahoo! > Use Yahoo! to plan a weekend, have fun online and > more. Check it out! > http://discover.yahoo.com/ > > --------------------------------------------------------------------- > To unsubscribe, e-mail: > [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: > [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] __________________________________ Discover Yahoo! Get on-the-go sports scores, stock quotes, news and more. Check it out! http://discover.yahoo.com/mobile.html
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
