Hibernate version:
version 2.1.6, 9.8.2004

Is there a way to show the resolved parameter values when displaying an sql statement via the show_sql=true configuration parameter?
It displays the generated which is very helpful but uses '?' instead of displaying the resolved parameter.

There is no direct way.

However, if you change your log setting to DEBUG, then you will see a lot of messages giving you details about the values bound to the parameters.

Also, make sure that you have log4j or equivalent in your classpath, as Hibernate uses that for logging.

ok thanks!

can you please give an example of how to change this setting (DEBUG)?

If you use log4j, then there should be a file called log4j.properties.

You can change the setting there (probably it would show as INFO).

If you don't have log4j, then you should add a log4j.properties file in your classpath.

You can get a sample from the Apache Log4j website.

I do have a lo4j.properties file, I'm sorry but I think I didn't formulate right my question, I'll rephrase it: "what is the exact line that I should add/modify in this properties file to turn on/off DEBUG information for hibernate?"

for 2.x:
log4j.logger.net.sf.hibernate=debug

for 3.x
log4j.logger.org.hibernate=debug

thank you