Hello,
We have tried with filters tag and Regrex filter in log4j2 but it did not worked with our system.
we are not able to filter particulter logs in log files.
Please find below configurations which we have used.
With Regrex filter:-
<?xml version="1.0" encoding="UTF-8"?>
<Configuration>
<Appenders>
<RollingFile name="RollingFile" fileName="${sys:TalendJob.log}"
filePattern="logs/app-%d{MM-dd-yyyy}.log.gz">
<RegexFilter regex=".* Execute the query .*" onMatch="DENY" onMismatch="ACCEPT"/>
<PatternLayout>
<pattern>[%p] %d %c %M - %m%n</pattern>
</PatternLayout>
<TimeBasedTriggeringPolicy />
</RollingFile>
</Appenders>
<Loggers>
<Root level="INFO">
<AppenderRef ref="RollingFile"/>
</Root>
</Loggers>
</Configuration>
With Filter tag:-
<?xml version="1.0" encoding="UTF-8"?>
<Configuration>
<Appenders>
<Console name="Console" target="SYSTEM_OUT">
<PatternLayout pattern="%d{yyyy-MM-dd HH:mm:ss} %-5p %c{1}:%L - %m%n" />
<Filters>
<Filter type="RegexFilter" regex=".* Execute the query .*" onMatch="DENY" onMismatch="ACCEPT"/>
</Filters>
</Console>
<File name="File" fileName="${sys:TalendJob.log}" >
<PatternLayout>
<Pattern>[%p] %d %c %M - %m%n</Pattern>
</PatternLayout>
</File>
</Appenders>
<Loggers>
<Logger name="TalendLog" >
<AppenderRef ref="Console" level="INFO"/>
<AppenderRef ref="File" level="INFO"/>
</Logger>
<Root level="INFO">
<AppenderRef ref="Console" />
<AppenderRef ref="File" />
</Root>
</Loggers>
</Configuration>
The tdbRow Component generates below log in the logfile for each row that needs to be inserted in the table. This is not custom log and this is coming from tdbRow component only.
We need to remove this log generated by "tdbRow " component from logfile. We have have applied Regex Filter on "Execute the query " to suppress this log from the log file but it is not working. Maybe the regex expression that we have applied is not correct.
Could you please let us know the correct regex expression for the below log so as to suppress the log from tdbRow component using RegexFilter ?
2022-07-05 18:14:14 INFO jb_process_in_delim:13080 - tOracleRow_4 - Execute the query: '
BEGIN
insert into <<Table_Name>> (interface_name,source_id,record_id , DESC1 , DESC2 ) values('Dummy_interface', 'Dummy.csv' ,'1' , 'dummy.CSV' , 'OK' ) ;
commit;
END ;
' has finished
Kindly Suggest..
Thanks In Advance..
