[prev in list] [next in list] [prev in thread] [next in thread] 

List:       log4j-user
Subject:    RE: CustomSQLDBReceiver in Chainsaw
From:       "Scott Deboy" <sdeboy () comotivsystems ! com>
Date:       2004-12-19 2:08:05
Message-ID: 984A7225EFC7FD44B0B66D3A29A14400061A3B () pdxcorp1 ! vwsnet ! com
[Download RAW message or body]

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



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

[prev in list] [next in list] [prev in thread] [next in thread]