Hi,

I'm building a Criteria using session.createCriteria(...);
I would like to be able to get the SQL string corresponding to this Criteria because I would like to be able to build a request like the following:

UPDATE ... FROM table WHERE field IN (criteria SQL string) SET ...

I've looked at the hibernate documentation but could not find anything.
Is it possible ?
Thanks
Patrick

you just have to add the following line in the hibernate-service.xml

<attribute name="ShowSqlEnabled">true</attribute>

I was meaning: getting the SQL string corresponding to the Criteria dynamically... (to be able to reuse it in my update statement) not print it on the output.