chainsaw with CustomSQLDBReceiver

Discussion in 'Java' started by karen, Sep 12, 2006.

  1. karen

    karen Guest

    I am using CustomSQLDBReceiver with chainsaw. When chainsaw is
    launched,
    I am getting a null pointer exception. Any thoughts on what the issue
    might be?

    I have included my 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:eek:racle:thin:mad: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 &quot;LEVEL&quot;, message as MESSAGE,
    hostname
    as HOSTNAME, src_file as &quot;FILE&quot;, 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>
    karen, Sep 12, 2006
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. scott
    Replies:
    0
    Views:
    715
    scott
    May 24, 2004
  2. jerry
    Replies:
    5
    Views:
    20,352
    Krzysztof
    Jun 6, 2012
  3. monkey boy via JavaKB.com

    Is there a way to Chainsaw as a service?

    monkey boy via JavaKB.com, Feb 6, 2005, in forum: Java
    Replies:
    0
    Views:
    312
    monkey boy via JavaKB.com
    Feb 6, 2005
  4. iq

    Chainsaw log viewer

    iq, Jun 16, 2005, in forum: Java
    Replies:
    3
    Views:
    696
    Arne Vajhøj
    Sep 19, 2012
  5. tkonrath
    Replies:
    1
    Views:
    3,159
    scott
    Oct 10, 2005
Loading...

Share This Page