Chainsaw database connectivity error

["Rally, Menka" <me...@fiserv.com>]

 

Hello 

 

I am facing problem in adding Oracle database receiver in chainsaw.

 

Following are my XML Details: -   

<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE log4j:configuration >

<log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/"
debug="true">

   <appender name="A2" class="org.apache.log4j.ConsoleAppender">

      <layout class="org.apache.log4j.SimpleLayout"/>

   </appender>

 

 

   <plugin name="CustomDBReceiver"
class="org.apache.log4j.db.CustomSQLDBReceiver">

      <connectionSource
class="org.apache.log4j.db.DriverManagerConnectionSource">

        <param name="password" value="LOG654"/>

        <param name="user" value="APP_LOG_USER"/>

        <param name="driverClass"
value="oracle.jdbc.driver.OracleDriver"/>

        <param name="url"
value="jdbc:oracle:thin:@10.53.12.54:1521:odsd"/>

        </connectionSource>

      <param name="refreshMillis" value="5000"/>

     <param name="sql" value='select logger as LOGGER, log_date as
TIMESTAMP, lvl as LEVEL, thread_name as THREAD, ndc as NDC, mdc as
MDC,message as MESSAGE, 

 

class_name as CLASS, method_name as METHOD, file_name as FILE,
line_number as LINE,
concat("{{application,databaselogs,hostname,localhost,log4jid,", log_id,


 

"}}") as PROPERTIES, exception as EXCEPTION from APP_LOG'/>

      <param name="IDField" value="log_id"/>

 <param name="application" value="App"/>

      <param name="hostname" value="Host"/

   </plugin>

 

 

 

   <root>

      <level value="debug"/>

   </root>

</log4j:configuration>

 

 

 

Following is the error coming in chainsaw logs

 

Level 

ERROR 

Logger 

org.apache.log4j.db.CustomSQLDBReceiver 

Time 

2008-10-14 05:30:53,066 

Thread 

Chainsaw-WorkerThread 

Message 

*************Problem receiving events

NDC 

null 

Class 

? 

Method 

	
Line 

	
File 

	
Properties 

{{hostname,chainsaw}{log4jid,384}{application,log}} 

Throwable 

java.sql.SQLException: Non supported SQL92 token at position: 221: 

        at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)

        at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)

        at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1130)

        at oracle.jdbc.driver.OracleSql.handleToken(OracleSql.java:201)

        at oracle.jdbc.driver.OracleSql.handleODBC(OracleSql.java:121)

        at oracle.jdbc.driver.OracleSql.parse(OracleSql.java:69)

 

 

 

Thanks

Menka