Answers to: Hibernate show_sql

Comment by Hap Em on Florian Heinrich's answer

Hap Em — Fri, 11 Dec 2015 04:45:09 -0500

Thank you very much Florian! It's really helpful!

Answer by Florian Heinrich

Florian Heinrich — Thu, 10 Dec 2015 14:27:50 -0500

Hello Hapem85,

try to create your own hibernate appender:

<appender name="hibernate-appender" class="org.apache.log4j.RollingFileAppender">
    <param name="Append" value="true"/>
    <param name="File" value="${user.dir}/logs/hibernate.log"/>
    <layout class="org.apache.log4j.PatternLayout">
        <param name="ConversionPattern" value="[%d{dd/MM/yy} %d{HH:mm:ss}] %-5p %c %m%n"/>
    </layout>
</appender>

and change the category to logger:

<logger name="org.hibernate.SQL">
    <appender-ref ref="hibernate-appender"/>
    <level value="DEBUG"/>
</logger>

Hope that helps.

Answer by Hap Em

Hap Em — Thu, 10 Dec 2015 13:09:43 -0500

Hello all,

I have tried with the solution form Reguel but it doesn't work. Pls help me if you have any idea!

Thanks!

In the persistence.xml, I had added the property for show sql:


<property name="hibernate.show_sql" value="true"/>

This is my log4jconfig.xml:







<log4j:configuration debug="false" xmlns:log4j="http://jakarta.apache.org/log4j/">
 
  <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="org.apache.log4j.IvyLog4jLayout">
      <param name="DateFormat" value="HH:mm:ss.SSS"/>
    </layout>
  </appender>


  <appender name="ConsoleAppender" class="org.apache.log4j.ConsoleAppender">
    <param name="Threshold" value="WARN"/>
    <layout class="org.apache.log4j.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>

  <category name="org.apache.cxf.bus.spring" class="ch.ivyteam.log.Logger">
    <priority value="ERROR"/>
  </category>
<category name="org.hibernate.SQL" class="ch.ivyteam.log.Logger">
    <priority value="INFO"/>
  </category>

  

   <root> 
    <level value="INFO"/>
    <appender-ref ref="FileLog"/>
    <appender-ref ref="SmsLog"/> 
    <appender-ref ref="EmailLog"/> 
    <appender-ref ref="ConsoleAppender"/>
  </root>
</log4j:configuration>

Comment by Florian Heinrich on Reguel Wermelinger's answer

Florian Heinrich — Wed, 09 Dec 2015 10:54:01 -0500

Thank You this works

Answer by Reguel Wermelinger

Reguel Wermelinger — Mon, 07 Dec 2015 14:27:15 -0500

I guess that you have to customize the log4j configuration so that the hibernate logs are visible in the designer log. To do so open the file [designer-root-dir]/configuration/log4jconfig.xml with a text editor.

Add a category to define the hibernate sql log level right below an existing category definition:

  <category name="org.hibernate.SQL" class="ch.ivyteam.log.Logger">
    <priority value="WARN"/><!-- raised priority so that we see the logs with a default designer configuration -->
  </category>

Restart you Designer to apply the changed log configuration.

For a list of available loggers consult the hibernate documentation: https://docs.jboss.org/hibernate/orm/3.3/reference/en-US/html/session-configuration.html#configuration-logging

Notice that with the Axon.ivy Visual VM plugin you can also inspect the sql queries that are fired by the hibernate persistence layer. In contrast to the normal log outputs you will also see execution times and the used runtime parameters on for parameterized queries. See the "external database" tab in the plugin: http://developer.axonivy.com/doc/latest/EngineGuideHtml/monitoring.html#d5e4726