logging-log4j-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Scott Deboy" <sde...@comotivsystems.com>
Subject RE: CustomSQLDBReceiver in Chainsaw
Date Sun, 19 Dec 2004 02:08:05 GMT
For those interested in using this receiver, a clarification:

application and hostname aren't params in the receiver config - they are event properties
(see the JavaDoc for an explanation of how to specify them in the SQL).


-----Original Message-----
From:	Doug Fraser [mailto:doug@venturesetc.com]
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 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 IDField 
>param.
>- All of the event fields must be defined in the SQL statement, even if 
>you don't have columns for them in your database
>- Unless you specify 'application' and 'hostname' params, the 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 will tell you if your sql is executing, because lastID is 
>the highest value of the identity field that the receiver was able to 
>retrieve from the database.
>
>Let me know if you have more questions,
>Scott

I give up - so where do I set the application and hostname params.  It 
seems that I can get the SQL connection up and running
(no error msgs when the PuTTY terminal to the db is running) but events are 
just not being displayed

doug


---------------------------------------------------------------------
To unsubscribe, e-mail: log4j-user-unsubscribe@logging.apache.org
For additional commands, e-mail: log4j-user-help@logging.apache.org






Mime
View raw message