Hi, I am using chainsaw with CustomSQLDBReceiver. When I launch chainsaw, the receiver is started and I see events. However, I am not receiving any new events. Do you have any thoughts on why?
Below is my configuration file. (For obvious reasons, I did not include my real password, user name, etc). <?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="blah"/> <param name="user" value="user"/> <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, log_level as "LEVEL", message as MESSAGE, src_file as "FILE", stack as THREAD, log_time as TIMESTAMP, '' AS NDC, '' AS MDC, application AS CLASS, '' AS METHOD, CONCAT('{{application,'||user_id||',hostname,'||hostname||',USERID,'||USER_ID||',log4jid,'||log_id||'}}','') AS PROPERTIES, '' AS EXCEPTION, 'Log::Log4perl' AS LOGGER from bu_log"/> </plugin> <root> <level value="DEBUG"/> </root> </log4j:configuration>
