Hi,
I have an uncommon (I guess) problem.
After I create a Query object with HQL statement, is there a way to get corresponding native SQL query string from it?

It happens that I have a bunch of display filters, which generate HQL queries, and a resultSet-based report generation tool, which accepts only native SQL queries. It would be good to have some direct translation to easy associate a report with a filter, without a need to change the report tool.

Thanks in advance!
Jakub

set show_sql to true (and format_sql as well to help with readablity)

Thanks, but I don't need to actually see the resulting SQL string, I need to get it _programatically_ from Query (or some other place in Hibernate) to use in other class.
Jakub