how to get all sql queries fired in Hibernate application

ramakanthreddy_t · **Joined:** Thu Mar 05, 2009 2:50 am **Posts:** 14

How can i get all the SQL Queries that are fired in the application and from which Class in the application fired that SQL query. I have a problem while using update in Hibernate in Threads i am getting my data updated famtomly

thanks and regards
ramakanth

thhart · **Joined:** Sun Aug 01, 2004 6:49 pm **Posts:** 76

1. <property name="show_sql">false</property> this is a setting in a xml mapping configuration.
2. Log and see the queries arriving in your dbms.
3. Get the source code of hibernate and step into execution via a debugger.
4. Turn on tracing logging of hibernate.

HTH
Thomas

PS: 3. is highly recommend for all Hibernate users. It is worth it.

mazhar · **Posted:** Mon Apr 06, 2009 1:45 pm

Alternatively, if you want to check this query in your application, you could:
1. Extend the EmptyInterceptor class and override the

Code:

String onPrepareStatement(String sql)

method.
2. Register this SessionInterceptor with your SessionFactory.
3. The sql String in the intercepted onPrepareStatement() method is the query you need.

Note that only the operations performed using the Session interface can be intercepted and not HQL or SQL queries.

Hope this helps.