P6spy | Twice batch update/ insert query logging

[Umesh Londhe]

Hi Team,

 

We configured p6spy to log application details, but we are facing the issue regarding duplicate query logging while using jdbcTemplate.batchUpdate. We want log single query not twice please help here.

 

spy.properties configuration

 

appender=com.p6spy.engine.spy.appender.Slf4JLogger

append=true

filter=true

includecategories=batch,statement

excludecategories=result,resultset,debug,commit

logMessageFormat=com.p6spy.engine.spy.appender.CustomLineFormat

customLogMessageFormat=%(executionTime) ms|%(category)| QUERY >>> %(sqlSingleLine)

 

logback.xml configuration

 

<appender name="JDBCLogRollingFile" class="ch.qos.logback.core.rolling.RollingFileAppender">

          <encoder class="ch.qos.logback.classic.encoder.PatternLayoutEncoder">

              <Pattern>%d{"yyyy-MM-dd HH:mm:ss SSSZ"}|User:%X{userName}|UniqueId:%X{requestId}|%c{1 .}|%m%n</Pattern>

          </encoder>

          <rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">

              <fileNamePattern>${LOGS}${facCd}/logs/jdbc/%d{yyyyMMdd}.log</fileNamePattern>

          </rollingPolicy>

      </appender>

 

 

<logger name="p6spy" level="DEBUG" additivity="false">

        <appender-ref ref="JDBCLogRollingFile"/>

    </logger>

 

 

Sample:

2023-11-19 07:15:57 911-0600|User:|UniqueId:43|p6spy|0 ms|statement| QUERY >>> insert into ABC etc…

2023-11-19 07:15:57 911-0600|User:|UniqueId:43|p6spy|20 ms|statement| QUERY >>> insert into ABC etc…

 

2023-11-19 07:15:57 912-0700|User:|UniqueId:43|p6spy|0 ms|statement| QUERY >>> update ABC set XYZ…

2023-11-19 07:15:57 912-0700|User:|UniqueId:43|p6spy|21 ms|statement| QUERY>>> update ABC set XYZ…

 

 

Thanks,

Umesh Londhe.

Caterpillar: Confidential Green

[Harshad Yeolekar]

Hi All,

 

Duplicate query logging issue due to p6spy was fixed by @Umesh Londhe

 

Thanks

Harshad.

 

Caterpillar: Confidential Green