Comment by Reguel Wermelinger on Reguel Wermelinger's answer

Reguel Wermelinger — Tue, 07 Aug 2018 07:48:05 -0400

Today it is not possible to see the values for SystemDB queries. The exception is the cryptic toString() functionality of the TaskQuery instance itself. External Database queries have a mature logging and performance measuring stack included which exposes the real SQL query that was fired.

Comment by maidanh on Reguel Wermelinger's answer

maidanh — Tue, 31 Jul 2018 23:35:43 -0400

I have another question that. With this configuration we only can see sql query with question mark. How can we show (sql query + param value instead of question mark)?

Comment by maidanh on Reguel Wermelinger's answer

maidanh — Tue, 31 Jul 2018 00:14:53 -0400

It works like a charm, I'm very appreciate you

Answer by Reguel Wermelinger

Reguel Wermelinger — Mon, 30 Jul 2018 06:53:48 -0400

Basically you can enable a logger that prints out all statements that are executed by Axon.ivy engine against the System Database. It will grow big, so I suggest that you put into an extra file:

Open [engineDir]/configuration/log4jconfig.xml and route all logs of the persistence to a custom appender called sqlLog:

<category name="ch.ivyteam.ivy.persistence.db" class="ch.ivyteam.log.Logger">
    <appender-ref ref="sqlLog"/>
    <priority value="DEBUG"/>
  </category>

Declare the appender as FileLog (copy the normal file logger and adjust):

<appender name="sqlLog" class="org.apache.log4j.DailyRollingFileAppender">
    <param name="Threshold" value="DEBUG"/>
    <param name="File" value="${user.dir}/logs/sql.log"/>
    <param name="DatePattern" value="'.'yyyy-MM-dd"/>
    <layout class="ch.ivyteam.log.layout.IvyLog4jLayout">
      <param name="DateFormat" value="HH:mm:ss.SSS"/>
    </layout>
  </appender>

The result will be a file under /logs/sql.log

full sample:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">

<!--
  This is the logging configuration file for Axon.ivy Engine.
  It defines which log messages are logged (category/priority) and where the logs are written to.

  Logging in Axon.ivy Engine is based on a 3rd party library called Log4J 
  (see http://logging.apache.org/log4j for more information).

-->
<log4j:configuration debug="false" xmlns:log4j="http://jakarta.apache.org/log4j/">

  <!--
   Defines an appender that will write log messages with at least priority INFO to a file
   that is located in the logs directory and is called ch.ivyteam.ivy.log with
   a prefix of the current date.
   Every day a new file will be created.  
  --> 
  <appender name="FileLog" class="org.apache.log4j.DailyRollingFileAppender">
    <param name="Threshold" value="INFO"/>
    <param name="File" value="${user.dir}/logs/ch.ivyteam.ivy.log"/>
    <param name="DatePattern" value="'.'yyyy-MM-dd"/>
    <layout class="ch.ivyteam.log.layout.IvyLog4jLayout">
      <param name="DateFormat" value="HH:mm:ss.SSS"/>
    </layout>
  </appender>

  <appender name="sqlLog" class="org.apache.log4j.DailyRollingFileAppender">
    <param name="Threshold" value="DEBUG"/>
    <param name="File" value="${user.dir}/logs/sql.log"/>
    <param name="DatePattern" value="'.'yyyy-MM-dd"/>
    <layout class="ch.ivyteam.log.layout.IvyLog4jLayout">
      <param name="DateFormat" value="HH:mm:ss.SSS"/>
    </layout>
  </appender>

  <!--
   Defines an appender that will write log messages with at least a priority WARN to the console  
  -->  
  <appender name="ConsoleAppender" class="org.apache.log4j.ConsoleAppender">
    <param name="Threshold" value="WARN"/>
    <layout class="ch.ivyteam.log.layout.IvyLog4jLayout">
      <param name="DateFormat" value="HH:mm:ss.SSS"/>
      <param name="ContextPrinting" value="false"/>
      <param name="FixedCategoryLength" value="20"/>
      <param name="ThreadPrinting" value="false"/>
    </layout>
  </appender>

  <!-- Prevent "ClientAbortException: java.io.IOException: Broken pipe" from filling the log -->
  <category name="org.apache.myfaces.application.ResourceHandlerImpl" class="ch.ivyteam.log.Logger">
    <priority value="FATAL"/>
  </category>

  <!-- Disable deprecated integer API warnings -->
  <!--
  <category name="ch.ivyteam.ivy.persistence.restricted.TableKeyCompatibilityConvertor" class="ch.ivyteam.log.Logger">
    <priority value="ERROR"/>
  </category>
  -->

  <!-- 
    Enables WebService SOAP Message logging for a certain application and process model. 
    Replace {application} and {process_model} in the logger name below with the name of the application and process model you want to enable the logging. 
  -->
  <!-- 
  <category name="runtimelog.{application}.{process_model}.web_service" class="ch.ivyteam.log.Logger">
    <priority value="DEBUG"/>
  </category>
  -->

<category name="ch.ivyteam.ivy.persistence.db" class="ch.ivyteam.log.Logger">
    <appender-ref ref="sqlLog"/>
    <priority value="DEBUG"/>
  </category>


  <!--
   Defines that every log message is written that has at least a priority of INFO. 
   Defines that log messages are written to the file and console appender defined above.
  -->
  <root> 
    <level value ="INFO" />
    <appender-ref ref="FileLog"/>
    <appender-ref ref="ConsoleAppender"/>
  </root>

</log4j:configuration>

Answers to: show sql query when query ivy task

Comment by Reguel Wermelinger on Reguel Wermelinger's answer

Comment by maidanh on Reguel Wermelinger's answer

Comment by maidanh on Reguel Wermelinger's answer

Answer by Reguel Wermelinger