Hi,
I want to see the complete sql statements in the log file with all of it values.

<property name="show_sql">true</property>
doesn't show the values wich are used in the sql statement.
is there a way to show the values?

if you are using log4j you should have configuration file named logger.properties or sth like this. you should have such line in this file:
log4j.logger.net.sf.hibernate = DEBUG

note that this will not do what you are asking which is to see the values passed into the placeholders, it will just give you some lower level debugging.

or use can try P6Spy, it's supposed to be put between your application and database and logs complete statement being sent to database plus some statistics.
It doesn't support all hibernate features (ie. I couldn't get it to work with select-before-update), but generally it's very useful...

for more info see http://www.p6spy.com

Check your JDBC driver docs, too. MySQL Connector/J has some logging options, for example.