Hi,

I am a Hibernate newbie and have vanilla install of 4.1.2 (no extras at all). All I want to turn up the log level to see fullSQL statements.

Any help would be really appreciated! Appollogies if this gets asked 1000's of times.

There seems to be no out of the box documentation on how to do this very simple task. (Lots of stuff about Log back / Log 4J etc. all of which are not relevant for me)

There are several configurable properties:



http://docs.jboss.org/hibernate/core/4.1/manual/en-US/html_single/#configuration-optional

Thank you for the quick reply.

I was already using the option 'hibernate.show_sql' which is simple and well documented.

Could you tell me a straight forward ('out of the box') way of getting Hibernate to print the value of the parameters that it is binding to the SQL? (And other useful 'Trace' style debug)

Best wishes,

S :-)

Hibernate isn't actually able to do that since it uses prepared statements all the time (as it's much more efficient), and keeping this context around for logging would complicate things significantly.
This is a limitation of the JDBC design, what people usually do during development is to use special JDBC drivers.. search the web for "jdbc spy", "P6Spy", or have a look into http://code.google.com/p/log4jdbc/

they should all be easy to setup and nicely separated, so you're sure you won't miss anything as Hibernate can't possible escape that ;)