Hi, i recompiled a log4j-db (ant log4j-db.jar) from the given link.
Overwrote the jar to Chainsaw folder and added jar to -classpath. It still has same error. Pls advise. --- Scott Deboy <[EMAIL PROTECTED]> wrote: > 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] __________________________________ Yahoo! Mail Stay connected, organized, and protected. Take the tour: http://tour.mail.yahoo.com/mailtour.html --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
