Hi
Inside my DAO method i have

I would like somehow retireve number of sql commands executed against database to retrieve OperationSent object.
OperationSent entity has 3 one-to-one association and i would like to create Junit test to assert that this code produces exactly one sql...

Looking at statistics api i've seen
getQueryExecutionCount() method but it returns 0. After a few experiments i noticed the method returns number greater than 0 only for sql/hql queries.

Is it possible to retrieve number of sqls for session.get() , session.load()
using statistics??
and if not is any workaround to satisfy my test requirement ?
[/code]

Hello,

We have done just that (automatic developer tests asserting the number of SQL queries made by a Hibernate operation), using two techniques:

- programmatically turning show_sql=true, redirecting System.out and counting the number of lines starting with "Hibernate: " :)
- using Statistics.getPrepareStatementCount()

I think that Statistics.getPrepareStatementCount() is accurate and shows the same number as the SQLs shown with show_sql=true (you can confirm this by looking at the Hibernate source code).

For good error messages (showing the extra SQL statements right away), we have retained the kludge of System.out redirection, and I also submitted a little patch that adds collecting the SQLs to Statistics, let's hope that it makes it to a release:

http://opensource.atlassian.com/project ... e/HHH-3130

Best wishes,
Timo

I wouldn't like to redirect System.Out and then parse, cause i have this kind of tricks...

Counting preparing statements seems to be ok for my case but need to check it in different scenarios.

I hope your patch will be merged to furute hibernate release, but i have no time now to take a look at it.

Anyway thanks a lot for your help