Get SQL query after executing criteria.list() ?

bletual · **Joined:** Wed Sep 27, 2006 7:56 am **Posts:** 1

Hibernate version:3.1.3 / Java 1.5

Hi,

is it possible to get the native sql query behind a criteria ?

I use Criteria API to filter a list of pojo. After filtering, I need

to export data to Excel with Jasper Reports. I want to retrieve

the native SQL to associate it with my report ... I tried to use

the statistics but the String[] returned with getQueries() is always

empty :

HibernateUtils.getSessionFactory().getStatistics().setStatisticsEnabled(true);

this.liste = criteria.list();

Statistics stats = HibernateUtils.getSessionFactory().getStatistics();
HibernateUtils.getSessionFactory().getStatistics().setStatisticsEnabled(false);
String [] queries = stats.getQueries();
...

Any idea ?

Thanks a lot,

Bruno.

mba · **Joined:** Tue Aug 29, 2006 10:56 am **Posts:** 15

Hello,

I have the same problem.

See class org.hibernate.loader.Loader.java

Code:

/**
* Identifies the query for statistics reporting, if null,
* no statistics will be reported
*/
protected String getQueryIdentifier() {
      return null;
}

This method is invoked.

Replace the line:

Code:

return null;

with

Code:

getSQLString();

.

I am testing just now this workaround. The solution has effects to the Statistics API regarding query cache.

Let me know if you get an alternate solution or if you have problems with the workaround.

mba

andresgr · **Posted:** Wed Nov 29, 2006 6:24 am

Create the session with an interceptor and use

org.hibernate.Interceptor.onPrepareStatement(String sql);