CODEWITHSUNDEEP
sqlhibernatelog4j
CalamarBicefalo
CalamarBicefalo

Reputation: 87

How to log final SQL queries with hibernate

Is it possible to log not HQL queries but final queries when using hibernate. I mean, the one that is sent to the database. I've tried different log level but I haven't seen it. And in my opinion it would be useful to debug some issues.

Thank you very much.

Upvotes: 3

Views: 5042

Answers (1)

JB Nizet
JB Nizet

Reputation: 691735

Yes, it's possible. That's what the hibernate.show_sql property does. You may also have finer control using the logging configuration:

org.hibernate.SQL           Log all SQL DML statements as they are executed
org.hibernate.type          Log all JDBC parameters
org.hibernate.tool.hbm2ddl  Log all SQL DDL statements as they are executed

Upvotes: 4

Related Questions