How to get sql from hibernate criteria?

aiboogie · **Joined:** Thu Oct 04, 2007 10:32 am **Posts:** 6

How can I get / generate the SQL or HQL from a hibernate criteria?

sdas · **Joined:** Sat Oct 18, 2008 3:45 pm **Posts:** 1

Hi, can you please let me know how you solved this problem - i need to et the hql/sql from Hibernate criteria.
Thanks,

gonzao_diaz · **Joined:** Mon Nov 26, 2007 2:29 pm **Posts:** 443

Retrieving it from the code, at run time, I don't know.
How to capture it in a log, is explained here

http://hibernar.org/articulos_en/logging.php

rodrigors · **Joined:** Mon Oct 20, 2008 9:22 am **Posts:** 1

gonzao_diaz wrote:

Retrieving it from the code, at run time, I don't know.
How to capture it in a log, is explained here

http://hibernar.org/articulos_en/logging.php

I am looking for a way to retrieve SQL output at run time. Why? I have a service configurator app running on a development environment. After configuring the service (a C daemon with many configuration tables) and testing it, I want to port the exact changes to the database to production environment through an sql script, which would be offered to the user as a download. I checked your link and thought about tewaking the appender to log on a different file at each user interaction, but, unfortunately, this example won't bind the values to the sql output.