Re: Issue with IDField in CustomSQLDBReceiver

2011-07-07 Thread Scott Deboy
All of the code is available in subversion...to build the CustomSQLDBReceiver you can download the receivers companion and build it with maven. I was running from source myself - I'll try the DMG from the developer snapshot. Here is the repo information for the receivers companion..

RE: Issue with IDField in CustomSQLDBReceiver

2011-07-07 Thread Amit Oberoi
l.com] Sent: Friday, July 08, 2011 12:24 AM To: Log4J Users List Subject: Re: Issue with IDField in CustomSQLDBReceiver Yes, IDField is used to dynamically update the SQL statement with a 'where' clause: (idfield) > (last known IDField value), essentially allowing it to 'tail

Re: Issue with IDField in CustomSQLDBReceiver

2011-07-07 Thread Scott Deboy
, Amit Oberoi wrote: > All, > > > > I am using the latest developer snapshot 2.0.1 for Chainsaw V2. I have > configured CustomSQLDBReceiver with My SQL server. > > > > My problem is every time the receiver refreshes it gets all the logs in > the database in

Issue with IDField in CustomSQLDBReceiver

2011-07-07 Thread Amit Oberoi
All, I am using the latest developer snapshot 2.0.1 for Chainsaw V2. I have configured CustomSQLDBReceiver with My SQL server. My problem is every time the receiver refreshes it gets all the logs in the database instead of the new ones. Probably it is ignoring the IDField param for SQL

RE: Question for CustomSQLDBReceiver

2008-07-03 Thread Rally, Varun
-37800 VOIP - 434-509-0698 Extn. 121 US Phone- 001-303-293-2223 Extn. 22814 -Original Message- From: Scott Deboy [mailto:[EMAIL PROTECTED] Sent: Thursday, July 03, 2008 2:45 PM To: Log4J Users List Subject: RE: Question for CustomSQLDBReceiver The receiver needs all of the columns to be in

RE: Question for CustomSQLDBReceiver

2008-07-03 Thread Scott Deboy
22.0185 [EMAIL PROTECTED] www.comotivsystems.com -Original Message- From: Rally, Varun [mailto:[EMAIL PROTECTED] Sent: Thu 7/3/2008 1:09 PM To: Log4J Users List Subject: RE: Question for CustomSQLDBReceiver Hello, I believe I am doing all of the steps mentioned below. I think the issue is with the config

RE: Question for CustomSQLDBReceiver

2008-07-03 Thread Rally, Varun
Hello, I believe I am doing all of the steps mentioned below. I think the issue is with the configuration file where I have the SQL. In CustomSQLDBReceiver, there is an example query select logger as LOGGER, timestamp as TIMESTAMP, level as LEVEL, thread as THREAD, message as MESSAGE, ndc

RE: Question for CustomSQLDBReceiver

2008-07-03 Thread Scott Deboy
How to use CustomSQLDBReceiver: 1. create a $userhome/.chainsaw/plugins folder 2. copy your jdbc driver to the plugins folder 3. the Chainsaw downloads page links to an 'inportant distribution notes' link for more info about extended features - go there and follow the instructions

RE: Question for CustomSQLDBReceiver

2008-07-03 Thread Rally, Varun
3-2223 Extn. 22814 -Original Message- From: Scott Deboy [mailto:[EMAIL PROTECTED] Sent: Thursday, July 03, 2008 10:29 AM To: Log4J Users List Subject: RE: Question for CustomSQLDBReceiver http://logging.apache.org/log4j/companions/receivers/apidocs/org/apache/ log4j/db/CustomSQLDBRec

RE: Question for CustomSQLDBReceiver

2008-07-03 Thread Scott Deboy
503.997.1367 Fax:503.222.0185 [EMAIL PROTECTED] www.comotivsystems.com -Original Message- From: Rally, Varun [mailto:[EMAIL PROTECTED] Sent: Thu 7/3/2008 9:12 AM To: [email protected] Subject: Question for CustomSQLDBReceiver Hello All, I am new to Chainsaw and want t

Question for CustomSQLDBReceiver

2008-07-03 Thread Rally, Varun
Hello All, I am new to Chainsaw and want to use CustomSQLDBReceiver. Though I have got an idea of what it is, I am not able to get it running. Please provide me an internet link or URL that explains the steps to use a CustomSQLDBReceiver. Thanks in anticipation. Regards, Varun

chainsaw with CustomSQLDBReceiver

2006-09-13 Thread karen . e . greene
Hi. I was hoping someone may have gotten a chance to look at this error I am getting. I am using CustomSQLDBReceiver with chainsaw. When chainsaw is launched, I am getting a null pointer exception (the details of which are included below). Any thoughts on what the issue might be? I have

RE: CustomSQLDBReceiver not working correctly. Where can I find the code for it?

2006-05-12 Thread Scott Deboy
, Edward [mailto:[EMAIL PROTECTED] Sent: Friday, May 12, 2006 1:55 PM To: Log4J Users List Subject: RE: CustomSQLDBReceiver not working correctly. Where can I find the code for it? After getting the source and putting in debug statements I found the problem. The code is not trimming the

RE: CustomSQLDBReceiver not working correctly. Where can I find the code for it?

2006-05-12 Thread Mostrom, Edward
h "log4jid" and claiming it was not a match. When I removed the space everything worked fine. -Original Message- From: Mostrom, Edward [mailto:[EMAIL PROTECTED] Sent: Friday, May 12, 2006 2:08 PM To: Log4J Users List Subject: RE: CustomSQLDBReceiver not working correctly. Where c

RE: CustomSQLDBReceiver not working correctly. Where can I find the code for it?

2006-05-12 Thread Mostrom, Edward
PM To: Log4J Users List Subject: RE: CustomSQLDBReceiver not working correctly. Where can I find the code for it? The SVN repository was down for a couple of days. Here's a link to the latest revision of CustomSQLDBReceiver. As always, patches are always appreciated! http://svn.apache.org/v

RE: CustomSQLDBReceiver not working correctly. Where can I find the code for it?

2006-05-12 Thread Scott Deboy
The SVN repository was down for a couple of days. Here's a link to the latest revision of CustomSQLDBReceiver. As always, patches are always appreciated! http://svn.apache.org/viewcvs.cgi/logging/log4j/trunk/src/java/org/apach e/log4j/db/CustomSQLDBReceiver.java?view=markup

CustomSQLDBReceiver not working correctly. Where can I find the code for it?

2006-05-10 Thread Mostrom, Edward
I am using Chainsaw v2 alpha 1 connecting to an Oracle 10g database. I am getting events back; but every time it refreshes it gets them all again instead of just the new ones. Looks like it is ignoring the IDField param for the sql. It is apparently looking at the IDField because it will compla

RE: CustomSQLDBreceiver MDC

2005-06-24 Thread Scott Deboy
Please feel free to contribute a patch resolving your issue. -Original Message- From: Tan Kah Siong [mailto:[EMAIL PROTECTED] Sent: Fri 6/24/2005 4:41 PM To: Log4J Users List Cc: Subject:RE: CustomSQLDBreceiver MDC Changing delimiters is not the resolution to the

RE: CustomSQLDBreceiver MDC

2005-06-24 Thread Tan Kah Siong
; > -Original Message- > From: Tan Kah Siong [mailto:[EMAIL PROTECTED] > Sent: Fri 6/24/2005 2:34 AM > To: [email protected] > Cc: > Subject: CustomSQLDBreceiver MDC > Hi, > > The current implementation of PROPERTIES and MDC > support the f

RE: CustomSQLDBreceiver MDC

2005-06-24 Thread Scott Deboy
Access the source from CVS and modify the receiver to use a different delimiter. -Original Message- From: Tan Kah Siong [mailto:[EMAIL PROTECTED] Sent: Fri 6/24/2005 2:34 AM To: [email protected] Cc: Subject:CustomSQLDBreceiver MDC Hi, The current

CustomSQLDBreceiver MDC

2005-06-24 Thread Tan Kah Siong
Hi, The current implementation of PROPERTIES and MDC support the following format. {{name, value}} if my value contains a comma, won't this start causing problems? I do not wish to affect the current data in my database, is there any way of circumventing such problems? Please advice. __

RE: CustomSQLDBReceiver

2005-06-15 Thread Mark Womack
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 > > CustomSQLDB

RE: CustomSQLDBReceiver

2005-06-15 Thread Tan Kah Siong
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

RE: CustomSQLDBReceiver

2005-06-15 Thread Tan Kah Siong
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

RE: CustomSQLDBReceiver

2005-06-14 Thread Scott Deboy
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

RE: CustomSQLDBReceiver

2005-06-14 Thread Tan Kah Siong
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 alp

RE: CustomSQLDBReceiver

2005-06-14 Thread Scott Deboy
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/jav

RE: CustomSQLDBReceiver

2005-06-14 Thread Tan Kah Siong
l' 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 ex

RE: CustomSQLDBReceiver

2005-06-14 Thread Scott Deboy
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

CustomSQLDBReceiver

2005-06-14 Thread Tan Kah Siong
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 al

RE: Where is CustomSQLDBReceiver

2005-06-09 Thread Ghielli Patrick
PROTECTED] Sent: donderdag 9 juni 2005 16:24 To: [email protected] Subject: Where is CustomSQLDBReceiver Hi, As my Chainsaw Log gave me Failed to locate Receiver class:org.apache.log4j.db.DBReceiver Failed to locate Receiver class:org.apache.log4j.db.CustomSQLDBReceiver I searched them in

Where is CustomSQLDBReceiver

2005-06-09 Thread Roland.Kofler
Hi, As my Chainsaw Log gave me Failed to locate Receiver class:org.apache.log4j.db.DBReceiver Failed to locate Receiver class:org.apache.log4j.db.CustomSQLDBReceiver I searched them in the CVS. Hum Hum, cant find em... Why, where, how??? Thank you a lot roland

RE: Chainsaw with CustomSQLDBReceiver fo oracle

2005-03-22 Thread Scott Deboy
ver config, change IDField to reference the ID column (unless it's really the msisdn column you're using as the unique id), and get rid of the 'application' and 'hostname' params (they're defined in the sql concat statement above) -Original Message-

RE: Chainsaw with CustomSQLDBReceiver fo oracle

2005-03-22 Thread Ghielli Patrick
Users List Subject: RE: Chainsaw with CustomSQLDBReceiver fo oracle If you can post your table schema and what you have for an 'sql' parameter and we can figure it out. Scott There are a number of limitations described in the JavaDoc: http://cvs.apache.org/viewcvs.cgi/logging-log4j/src/java/o

RE: Chainsaw with CustomSQLDBReceiver fo oracle

2005-03-22 Thread Ghielli Patrick
l. Regards, Patrick. -Original Message- From: Scott Deboy [mailto:[EMAIL PROTECTED] Sent: vrijdag 18 maart 2005 6:22 To: Log4J Users List Subject: RE: Chainsaw with CustomSQLDBReceiver fo oracle If you can post your table schema and what you have for an 'sql' parameter and we can fi

RE: Chainsaw with CustomSQLDBReceiver fo oracle

2005-03-17 Thread Scott Deboy
events may show up on the chainsaw-log tab (but more likely) an empty tab. There is an example receiver configuration on Chainsaw's Welcome tab that shows an example CustomSQLDBReceiver config. When running, look on the chainsaw-log tab for messages containing 'lastID' - this wil

Chainsaw with CustomSQLDBReceiver fo oracle

2005-03-16 Thread Ghielli Patrick
Hi, I am trying to configure a CustomSQLDBReceiver for the Oracle DB I am using. After solving some problems mentionned in other postings on this mailing list, I now try set up a working sql statement. The statement I have now results in an error. The event in the chainsaw log describe it as an

RE: CustomSQLDBReceiver in Chainsaw

2004-12-18 Thread Scott Deboy
EMAIL PROTECTED] Sent: Sat 12/18/2004 4:13 PM To: Log4J Users List Cc: Subject: RE: CustomSQLDBReceiver in Chainsaw At 02:50 PM 12/18/2004, Scott Deboy wrote: >A couple of things: > >Are you running Chainsaw through webStart? > >Your db driver jar must be in the classp

RE: CustomSQLDBReceiver in Chainsaw

2004-12-18 Thread Doug Fraser
At 02:50 PM 12/18/2004, Scott Deboy wrote: A couple of things: Are you running Chainsaw through webStart? Your db driver jar must be in the classpath - jre/lib/ext if using WebStart. The JavaDoc describe some restrictions that are in place to use CustomSQLDBReceiver: - You must have an identity

RE: CustomSQLDBReceiver in Chainsaw

2004-12-18 Thread Doug Fraser
restrictions that are in place to use CustomSQLDBReceiver: - You must have an identity column and specify that field as the IDField param. done - All of the event fields must be defined in the SQL statement, even if you don't have columns for them in your database done - Unless you sp

RE: CustomSQLDBReceiver in Chainsaw

2004-12-18 Thread Scott Deboy
A couple of things: Are you running Chainsaw through webStart? Your db driver jar must be in the classpath - jre/lib/ext if using WebStart. The JavaDoc describe some restrictions that are in place to use CustomSQLDBReceiver: - You must have an identity column and specify that field as the

CustomSQLDBReceiver in Chainsaw

2004-12-18 Thread Doug Fraser
Hi, I am trying to get Chainsaw v2 up and running; instead, it just sits there I do not know if I have something misconfigured or missing. What I did was start Chainsaw, read in the config file that defines a DBReceiver, and it gets created etc. Then I expected for the DBReceiver to fetch