Logging SQL and its parameters to diagnose performance and data integrity issues

Answer

edit process-center/config/log4j.xml (or process-server/config/log4j.xml)

Change:

    <category name="org.springframework.jdbc.core.JdbcTemplate" additivity="false">

        <priority value="error"/>

        <appender-ref ref="TWSqlAppender"/>

    </category>

to (notice we change the category name and the priority value):

    <category name="org.springframework.jdbc.core" additivity="false">

        <priority value="trace"/>

        <appender-ref ref="TWSqlAppender"/>

    </category>

and change the appender from:

    <appender name="TWSqlAppender" class="org.apache.log4j.RollingFileAppender">


        <param name="Threshold" value="DEBUG"/>

        <param name="File" value="C:/IBM/Lombardi7/process-center/logs/tw-sql.log"/>

        <param name="MaxBackupIndex" value="10"/>

        <layout class="org.apache.log4j.PatternLayout">

            <param name="ConversionPattern" value="%d{ISO8601} [%t] %p %c %x - %m\r\n"/>

        </layout>

    </appender>

to (we change the threshold to trace - your path may vary):

    <appender name="TWSqlAppender" class="org.apache.log4j.RollingFileAppender">


        <param name="Threshold" value="TRACE"/>

        <param name="File" value="C:/IBM/Lombardi7/process-center/logs/tw-sql.log"/>

        <param name="MaxBackupIndex" value="10"/>

        <layout class="org.apache.log4j.PatternLayout">

            <param name="ConversionPattern" value="%d{ISO8601} [%t] %p %c %x - %m\r\n"/>

        </layout>

    </appender>