How to Make Hibernate Print Out IDs in the Console?

I'm using Hibernate/Spring. I have Hibernate configured to output HQL into the Console; it shows things like:

Hibernate: update sometable set some_field=?, other_field=? where id=?

This is great. The only additional thing I want is to replace the question-marks with REAL IDs.

The context is that I'm trying to investigate if a cascading delete is responsible for deleting a record after the parent/ow开发者_如何学Cner of that record is changed (say, from P1 to P2) and then the old parent P1 is deleted.

---

You need to enable (log4j) logging for this packages and this level:

org.hibernate.sql=TRACE
org.hibernate.type=TRACE

It should produce trace messages about each parameter.

@see thierd replaiy for an example

added

Only a hint: because it would be useless if the statements and parameters are shown/logged to different places:

Instead of using "hibernate.show_sql" you can enable DEBUG logging for "org.hibernate.SQL". Now you should see the SQL logged in your Log4J output rather than in the console.