I setup an appender in logconfig.xml in order to write events to an Oracle Table.
I created a table with 4 rows in Oracle and after I restart the metadata server no events are loaded in Oracle. In metadata log I see no error message, even so no data are loaded in the table. Here is the appender and the appender ref is under ROOT
<!-- Oracle Appender -->
<appender name="LoggingTimeFile" class="DBAppender">
<param name="ConnectionString" value="DRIVER=oracle;UID=user1; PWD='****';PATH='path';CATALOG=oracle_log" />
<param name="MaxBufferedEvents" value="300" />
<param name="TableName" value="LOG" />
<param name="Column" value="sn" />
<param name="Column" value="d" />
<param name="Column" value="c" />
<param name="Column" value="m" />
</appender>
<!-- Successful User Login -->
<appender name="SuccLogin" class="FilteringAppender">
<appender-ref ref="LoggingTimeFile" />
<filter class="AndFilter">
<param name="AcceptOnMatch" value="true"/>
<filter class="StringMatchFilter">
<param name="StringToMatch" value="New client connection"/>
<param name="AcceptOnMatch" value="true"/>
</filter>
<filter class="StringMatchFilter">
<param name="StringToMatch" value="accepted"/>
<param name="AcceptOnMatch" value="true"/>
</filter>
<filter class="DenyAllFilter" />
</appender>
can you please give me a hint what i'm doing wrong?
In what log can I check more details?
Thank you
