CODEWITHSUNDEEP
javahibernatetomcat
nuaavee
nuaavee

Reputation: 1356

How to see queries being fired by hibernate?

How do I see what queries are being fired by hibernate when a hibernate application is running in tomcat?

Upvotes: 9

Views: 6513

Answers (3)

Wotan von Klass
Wotan von Klass

Reputation: 21

Another alternative is P6Spy. It intercepts the JDBC driver and logs all transactions.

http://sourceforge.net/projects/p6spy/

Upvotes: 2

karakuricoder
karakuricoder

Reputation: 1075

Also, if you want to show the value of your parameters you can add

log4j.logger.org.hibernate.type=trace

to your log4j properties file.

Upvotes: 5

Eran Medan
Eran Medan

Reputation: 45735

The fast answer is

hibernate.show_sql=true

e.g. as in http://www.javalobby.org/java/forums/t44119.html

And from the official documentation:

hibernate.show_sql

Writes all SQL statements to console. This is an alternative to setting the log category org.hibernate.SQL to debug. e.g. true | false

hibernate.format_sql

Pretty print the SQL in the log and console. e.g. true | false

See this question as well: Hibernate show real SQL

Upvotes: 17

Related Questions