Hello Ivy-Team, how can I configurate the hibernate.show_sql property? I tried to configurate it in the persistence configuration editor but nothing happened. Is there something else I have to do? Thanks for answers asked 04.12.2015 at 15:42 Florian Hein... |
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 Add a category to define the hibernate sql log level right below an existing category definition:
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 answered 07.12.2015 at 14:27 Reguel Werme... ♦♦ Thank You this works
(09.12.2015 at 10:54)
Florian Hein...
|
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. answered 10.12.2015 at 14:27 Florian Hein... Thank you very much Florian! It's really helpful!
(11.12.2015 at 04:45)
Hap Em
|
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:
This is my log4jconfig.xml:
answered 10.12.2015 at 13:09 Hap Em |
Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
Tags:
Asked: 04.12.2015 at 15:42
Seen: 5,266 times
Last updated: 11.12.2015 at 04:45