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]
