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