Is there a way to show the executed Sql/Jpql in the console?
You can set the log element in ObjectDB configuration to write logging also to the console:
<log path="$objectdb/log/" max="8mb" stdout="true" stderr="false" />
When stdout is set to true, all the logging information is written to the console, in addition to being written to the log file. Currently you cannot send only selective information from the log to the console.
To write query execution to the log, add the following logger element to the configuration:
<logger name="query.manager" level="debug" />