RE: CustomSQLDBReceiver
H again :) It seems that the build.xml 's build do not include /dialect/Util.class and all. having new probs on that when running Chainsaw. Thks --- Scott Deboy [EMAIL PROTECTED] wrote: You need to use the latest version of build.xml in cvs instead of the one included with log4j 1.3alpha 6. You can download it here: http://cvs.apache.org/viewcvs.cgi/logging-log4j/build.xml?rev=1.161view=markup Right-click the download link and save. Replace the build.xml at the root of the log4j 1.3alpha6 tar.gz with this new build.xml, then re-run the db target. Scott -Original Message- From: Tan Kah Siong [mailto:[EMAIL PROTECTED] Sent: Tue 6/14/2005 8:46 PM To: Log4J Users List Cc: Subject: RE: CustomSQLDBReceiver 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: log4j-user@logging.apache.org 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]
RE: CustomSQLDBReceiver
Added the class manually to the jar file solved the problem. Thanks --- Tan Kah Siong [EMAIL PROTECTED] wrote: H again :) It seems that the build.xml 's build do not include /dialect/Util.class and all. having new probs on that when running Chainsaw. Thks --- Scott Deboy [EMAIL PROTECTED] wrote: You need to use the latest version of build.xml in cvs instead of the one included with log4j 1.3alpha 6. You can download it here: http://cvs.apache.org/viewcvs.cgi/logging-log4j/build.xml?rev=1.161view=markup Right-click the download link and save. Replace the build.xml at the root of the log4j 1.3alpha6 tar.gz with this new build.xml, then re-run the db target. Scott -Original Message- From: Tan Kah Siong [mailto:[EMAIL PROTECTED] Sent: Tue 6/14/2005 8:46 PM To: Log4J Users List Cc: Subject:RE: CustomSQLDBReceiver 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: log4j-user@logging.apache.org 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!
RE: CustomSQLDBReceiver
We should do another 1.3 alpha release around the same time we release 1.2.11. -Mark -Original Message- From: Scott Deboy [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 14, 2005 6:34 PM To: Log4J Users List Subject: RE: CustomSQLDBReceiver 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: log4j-user@logging.apache.org 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]