I have the following log4j configuration which works in that it produces two log files, one with the diverted SPRING logs and one where I am attempting to filter out the SPRING content so it is just log messages I have configured using the Logger:
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">
<log4j:configuration xmlns:log4j='http://jakarta.apache.org/log4j/'>
<appender name="DEBUG" class="org.apache.log4j.RollingFileAppender">
<param name="File" value="C:/debug/debug.log" />
<param name="Append" value="true" />
<param name="MaxFileSize" value="10MB" />
<param name="MaxBackupIndex" value="10" />
<layout class="org.apache.log4j.PatternLayout">
<param name="ConversionPattern" value="%d %-5p [%t] %C.%M() - %m%n" />
</layout>
</appender>
<appender name="SPRING" class="org.apache.log4j.RollingFileAppender">
<param name="File" value="C:/spring/spring.log" />
<param name="Append" value="true" />
<param name="MaxFileSize" value="10MB" />
<param name="MaxBackupIndex" value="10" />
<layout class="org.apache.log4j.PatternLayout">
<param name="ConversionPattern" value="%d %-5p [%t] %C.%M() - %m%n" />
</layout>
</appender>
<logger name="org.springframework" additivity="false">
<level value="debug"/>
<appender-ref ref="SPRING"/>
</logger>
<logger name="org.hibernate" additivity="false">
<level value="debug"/>
<appender-ref ref="SPRING"/>
</logger>
<root>
<priority value="debug" />
<appender-ref ref="DEBUG"/>
<appender-ref ref="SPRING"/>
</root>
</log4j:configuration>
The problem I am having is that there are still some org.springframework.jdbc calls coming through to my debug log that I am expecting to get diverted to the SPRING log file.
2020-06-26 10:05:29,601 DEBUG [scheduling-1] org.springframework.jdbc.object.SqlCall.compileInternal() - Compiled stored procedure. Call string is [{call SQL(?, ?, ?, ?, ?, ?, ?)}]
2020-06-26 10:05:29,601 DEBUG [scheduling-1] org.springframework.jdbc.object.RdbmsOperation.compile() - RdbmsOperation with SQL [SQL] compiled
I tried adding another logger with no success:
<logger name="org.springframework.jdbc" additivity="false">
<level value="debug"/>
<appender-ref ref="SPRING"/>
</logger>
Any ideas why it isn't getting picked up by these loggers?