Show sql generated by JPA/Hibernate

Question

Is there any way to show SQL generated by JPA/Hibernate without enabling the property <property name="hibernate.show_sql" value="true"/>?

The difficulty is that I need to monitor only one query and, if I turn on the show_sql all queries will be logged into the console.

Answer 1

You can enable and disable the SQL log using the code below

Logger sqlLogger = Logger.getLogger("org.hibernate.SQL");
sqlLogger.setLevel(Level.DEBUG);

... código ...

sqlLogger.setLevel(Level.OFF);