I found part of the problem. I did not have an underscore in log4j_id (I just had log4jid). When I changed that, I started getting new events. However, I am getting duplicate events many times. Any thoughts on that?
Here's the data. I changed some data due to security issues. I didn't change the log4j_id though.
| "Scott Deboy" <[EMAIL PROTECTED]>
09/21/2006 05:47 PM
|
To: "Log4J Users List" <[email protected]> cc: Subject: RE: chainsaw events not being received |
To be able to continually retrieve newly-inserted rows, you need a
property named 'log4j_id' in the 'properties' column. The value after
log4j_id should be the value in the column represented by the IDField
param.
Can you run the sql query and provide a couple of rows? I'd like to see
the string returned as the properties column.
Scott Deboy
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 21, 2006 12:22 PM
To: [email protected]
Subject: chainsaw events not being received
Hi,
I am using chainsaw with CustomSQLDBReceiver. When I launch chainsaw,
the
receiver is started and I see events. However, I am not receiving any
new
events. Do you have any thoughts on why?
Below is my configuration file. (For obvious reasons, I did not include
my
real password, user name, etc).
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE log4j:configuration >
<log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/">
<plugin name="MyCustomDBReceiver"
class="org.apache.log4j.db.CustomSQLDBReceiver">
<connectionSource
class="org.apache.log4j.db.DriverManagerConnectionSource">
<param name="driverClass"
value="oracle.jdbc.driver.OracleDriver"/>
<param name="password" value="blah"/>
<param name="user" value="user"/>
<param name="url" value="jdbc:oracle:thin:@blah:1521:brewu"/>
</connectionSource>
<param name="IDField" value="log_id"/>
<param name="refreshMillis" value="3000"/>
<param name="sql" value="SELECT line as LINE, log_level as
"LEVEL", message as MESSAGE, src_file as "FILE",
stack
as THREAD, log_time as TIMESTAMP, '' AS NDC, '' AS MDC, application AS
CLASS, '' AS METHOD,
CONCAT('{{application,'||user_id||',hostname,'||hostname||',USERID,'||US
ER_ID||',log4jid,'||log_id||'}}','')
AS PROPERTIES, '' AS EXCEPTION, 'Log::Log4perl' AS LOGGER from bu_log"/>
</plugin>
<root>
<level value="DEBUG"/>
</root>
</log4j:configuration>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
This transmission may contain information that is privileged,
confidential, legally privileged, and/or exempt from disclosure
under applicable law. If you are not the intended recipient, you
are hereby notified that any disclosure, copying, distribution, or
use of the information contained herein (including any reliance
thereon) is STRICTLY PROHIBITED. Although this transmission and
any attachments are believed to be free of any virus or other
defect that might affect any computer system into which it is
received and opened, it is the responsibility of the recipient to
ensure that it is virus free and no responsibility is accepted by
JPMorgan Chase & Co., its subsidiaries and affiliates, as
applicable, for any loss or damage arising in any way from its use.
If you received this transmission in error, please immediately
contact the sender and destroy the material in its entirety,
whether in electronic or hard copy format. Thank you.
