I know that Hibernate will show me the SQL if I add

<property name="hibernate.show.sql" value="true"></property>

to the config file but it shows the statement without values (the prepared statement with the ? in place of the values being set).

Is there a way to get Hibernate to show what values it is using in the prepared statement? We are getting foreign key constraint errors and it is very difficult to debug. Is the problem that we didn't map the properties to the correct columns? Or could it be we are populating the beans incorrectly? Seeing the values would help a lot.

Thanks!

Discussed recently here:

http://forum.hibernate.org/viewtopic.php?t=965749&highlight=

The other forum discussion is neat, but for a quick and simple solution, I just use logdriver. It's a JDBC driver which just wraps a real JDBC driver and logs all statements before executing them.

http://rkbloom.net/logdriver/

I use it all the time in testing. I don't know if I'd ship with it though.

Good luck,
Stephen

ps. don't forget to rate!