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