Just a quick question. Is there a way, with showsql=true, to see the actual values used in insert statements? What I'm seeing are sql statements like 'insert into table (col1, col2) values (?,?)', but I really need to see what those values are instead of ? placeholders.

If you just need the information for debugging purposes you could use p6spy,
p6Spy is a JDBC driver which wraps around your actual JDBC driver and intercepts JDBC calls transparently to your application.
I have used it already with DB2 and Oracle.
You can find it here: http://www.p6spy.com/
I can't tell you if its ready for a production system, but it works very well on my workstation.

kind regards, Chris

You need to turn on logging for Hibernate: specifically in log4j.properties.

WARNING: Hibernate uses commons-logging -- My example assumes that commons-logging is deferring to Log4j for configuration.

Good luck,
Curtis ...