Hi. Thanks for all your help so far. I got further and the receiver is showing up in chainsaw and it connects. However, I get an oracle table or view does not exist error. I create a Java class that uses this same connection and sql and it works just fine. Do you have any thoughts on why I might be getting the error?
I also have the following questions:
- When is it best to use DBReceiver vs CustomDBReceiver?
- Can you define custom columns? ie. select .... , category as category. Would I add this custom column in the xml file to get it to show up in chainsaw?
Here is my lastest configuration file. I have also attached the java class I created incase it helps at all.
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE log4j:configuration >
<log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/">
<plugin name="MyDBReceiver" class="org.apache.log4j.db.DBReceiver">
<connectionSource class="org.apache.log4j.db.DriverManagerConnectionSource">
<param name="driverClass" value="oracle.jdbc.driver.OracleDriver"/>
<param name="password" value="blah"/>
<param name="user" value="I026526"/>
<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, application as APPLICATION, log_level as "LEVEL", message as MESSAGE, hostname as HOSTNAME, src_file as "FILE", stack as THREAD, log_time as TIMESTAMP, '' AS NDC, '' AS MDC, '' AS CLASS, '' AS METHOD, CONCAT('{{USERID,'||USER_ID||',log4jid,'||log_id||'}}','') AS PROPERTIES, '' AS EXCEPTION, '' AS LOGGER from bu_log"/>
</plugin>
<root>
<level value="debug"/>
</root>
</log4j:configuration>
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.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
