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 included the configuration file below.
The execution of the job threw an exception
java.lang.NullPointerException
at org.apache.log4j.CategoryKey.<init>(CategoryKey.java:30)
at org.apache.log4j.Hierarchy.getLogger(Hierarchy.java:483)
at org.apache.log4j.Hierarchy.getLogger(Hierarchy.java:465)
at org.apache.log4j.LogManager.getLogger(LogManager.java:256)
at org.apache.log4j.Logger.getLogger(Logger.java:64)
at
org.apache.log4j.db.CustomSQLDBReceiver$CustomReceiverJob.execute(CustomSQLDBReceiver.java:326)
at
org.apache.log4j.scheduler.Scheduler.executeInABox(Scheduler.java:195)
at org.apache.log4j.scheduler.Scheduler.run(Scheduler.java:173)
<?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="pass"/>
<param name="user" value="user"/>
<param name="url"
value="jdbc:oracle:thin:@server:1521:servicename"/>
</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.
