I was not able to find out some posibility to get SQL, that is translated from HQL.

I mean method like:

Query qu=session.createQuery(hql);
qu.setParams(....);

qu.translate();
sql=qu.getSQL();

Thanks,

Lukas

you can enable the output of sql in the Hibernate configuration => read Hibernate reference or you can configure your logging to debug sql statements.

Regards Sebastian

Hi,
I know and use this.
I wanted to save the generated SQL into database during session, without executing it.
I develop application that runs upon AS/400 DB2 (and many others). And there is batch processing of queries during night - the queries are very complex upon large bank data.

But by another client I want to execute it satement directly from fat client app. in HQL.

I don't like to write statement generation twice - to HQL and SQL, that's why I need this at application level.
I traced query exectuion and found it very diffucult to hack somewhere inside Hibernate to achieve this.... that's why I ask at forum.

Lukas

I think that the queries are finally compiled by the jdbc driver.

So you might hack this.

Another idea. Have a lock at c-jdbc it is a replicating driver. Which replicates queries to a number of databases. When your AS400 is down ;-) the queries are saved. May be there is a way to retrieve them.

Regards Sebastian