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.

Pascal Thivent · Accepted Answer · 2010-09-29 02:04:23Z

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, 2010 at 2:04

Pascal Thivent

572k140 gold badges1.1k silver badges1.1k bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Pascal Thivent Over a year ago

@Bozho Statistics are really full of nice metrics, very useful.

G. Ciardini Over a year ago

Your reference return 404

frictionlesspulley · Accepted Answer · 2010-09-29 00:58:12Z

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, 2010 at 0:58

frictionlesspulley

12.6k16 gold badges73 silver badges124 bronze badges

Collectives™ on Stack Overflow

Hibernate executed queries and testing

2 Answers 2

References

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

References

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related