Hibernate executed queries and testing

Question

Is there a way to find out what queries are executed with hibernate?

I would like to write a performance test to ensure only a specific query and amount are run.

Update: Just a clarification, i would like to programatically find out how many queries are run, not just via visual-manual inspection, so it would easily testable.

score 3 · Accepted Answer · answered Sep 29 '10 at 02:04

3

Enable Hibernate statistics and use SessionFactory#getStatistics() to retrieve a Statistics and access the metrics related to queries.

See getQueries(), getQueryStatistics(String), QueryStatistics and the other methods.

References

Hibernate Core Reference Guide
- 3.4.6. Hibernate statistics
- 20.6. Monitoring performance

answered Sep 29 '10 at 02:04

Pascal Thivent

562,542
136
1,062
1,124

@Bozho Statistics are really full of nice metrics, very useful. – Pascal Thivent Sep 29 '10 at 06:08
Your reference return 404 – G. Ciardini Feb 11 '20 at 16:28

score 0 · Answer 2 · answered Sep 29 '10 at 00:58

0

hibernate.show_sql =true would show all the sqls executed.

http://docs.jboss.org/hibernate/core/3.3/reference/en/html/session-configuration.html

answered Sep 29 '10 at 00:58

frictionlesspulley

11,070
14
66
115

Hibernate executed queries and testing

2 Answers2

References

Linked