Language: Deutsch · English
SQL logging to a separate log file
Write SQL logging to a dedicated file (sql.log) – a separate log4j2 appender.
HOW-TO ADMINISTRATOR UPDATED: JUL 2026 APPLIES TO NUCLOS 4.2026.X
On this page
SQL logging can be written to its own file. Define a separate appender (SQLLog) and reference it in the SQL logger:
<?xml version="1.0" encoding="UTF-8"?>
<Configuration>
<Appenders>
<Console name="Console" target="SYSTEM_OUT">
<PatternLayout pattern="%d %p [%c] - %m%n"/>
</Console>
<RollingFile name="Logfile" fileName="<Nuclos-Log-Verzeichnis>/server.log"
filePattern="<Nuclos-Log-Verzeichnis>/server-%i.log"
append="true">
<PatternLayout pattern="%d %p [%c] - %m%n"/>
<Policies>
<SizeBasedTriggeringPolicy size="5 MB"/>
</Policies>
<DefaultRolloverStrategy max="20"/>
</RollingFile>
<RollingFile name="SQLLog" fileName="<Nuclos-Log-Verzeichnis>/sql.log"
filePattern="<Nuclos-Log-Verzeichnis>/sql-%i.log"
append="true">
<PatternLayout pattern="%d %p [%c] - %m%n"/>
<Policies>
<SizeBasedTriggeringPolicy size="5 MB"/>
</Policies>
<DefaultRolloverStrategy max="20"/>
</RollingFile>
</Appenders>
<Loggers>
<Logger name="org.apache.log4j.xml" level="info"/>
<Logger name="SQLLogger" level="debug">
<AppenderRef ref="SQLLog"/>
</Logger>
<Root level="info">
<AppenderRef ref="Console"/>
<AppenderRef ref="Logfile"/>
</Root>
</Loggers>
</Configuration>
Only in sql.log
With additivity="false" on the SQL logger the SQL entries only go to sql.log and not also to server.log.
Related pages
Überblick
Inhalte