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 
&quot;LEVEL&quot;, message as MESSAGE, src_file as &quot;FILE&quot;, 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>

Reply via email to