Debug von raw SQL generated by Hibernate.
Reintegrate the bind values for debug querys directly to an SQL Console.
Find where in code a query was fired, by using debug log entrys.
A dialog box is shown by pressing Ctrl + Alt + P search for command Extract SQL from Hibernate log.
Or by pressing Alt + H keys (Alt and H)
It will parse the current open hibernate log file and show the raw sql in new editor.
You can put debug marker in your code.
LOG.error("#### my debug info");
Those have to start with at least 4 #. do be shown in the output.
Activate hibernate logging in log4j.xml
<logger name="org.hibernate.type">
<level value="trace>
</logger>
<logger name="org.hibernate.SQL">
<level value="trace"/>
</logger>
Force hibernate to log querys:
configurationRegistry.setProperty("hibernate.show_sql", "true");
Further informations can be found at: "Hibernate show real SQL"
I would advice to use additionaly this extension Monitor file to monitor log files for changes.
Caused by this issue this extension is limited to a maximum log file size of 5MB You can patch your vs code installation. Change in
"%programfiles(x86)%\Microsoft VS Code\resources\app\out\vs\code\electron-main\main.js"
or for x64 edition
"%programfiles%\Microsoft VS Code\resources\app\out\vs\workbench\workbench.main.js"
Following code and add 00. To Increase Limit from 5MB to 500MB
MODEL_SYNC_LIMIT=5242880,
Or you filter your with log4j.xml to reduce file size
<filter class="org.apache.log4j.varia.StringMatchFilter">
<param name="StringToMatch" value="extracted value"/>
<param name="AcceptOnMatch" value="false"/>
</filter>