I am new to Hibernate so please excuse me, if this is a "stupid" question. But I have been searching the net for an answer for some time now and could not find anything useful ...

After setting

hibernate.show_sql true

in the properties file, the SQL statements generated by hibernate are logged like this

Hibernate: update PERSON set name=?, lastname=?, age=? where id=?

Is there a way to enabled logging of the "values" for the bind variables?
Something like

Hibernate: update PERSON set name='John', lastname='Doe', age=30 where id=42

In other projects I worked on (without Hibernate) we always had a special subclass of PreparedStatement for this and it has proven very useful for debugging purposes.

Thanks in advance.

Bye,
Stefan

Try logging sql with this: http://www.p6spy.com/

Reto

yes - so why dont you use that preparedstatement class ? ;)

You can also look into p6spy which can do some of this.

/max

I will certainly look into "p6spy" and maybe even plug our own PreparedStatement into Hibernate.

But I was actually hoping that this was a standard feature of Hibernate. Something like



Since Hibernate is "filling in" the values for the bind variables anyway, it should be "easy" to print them to the log ...

I am currently evaluating Hibernate for an upcoming project and I am quite impressed by what I have seen so far. But all the people to whom I have shown my sample and the generated SQL, have asked me right away "Can you also see the parameter values?"

well you can by enabling org.hibernate.type debug log.

but it wont be merged into the sql - for that you should use tools like p6spy etc.

> well you can by enabling org.hibernate.type debug log.

That's what I was looking for ... well almost ;-)

Thanks!
Stefan[/quote]

How can I set this, if I use JDK Log API?

I tried the following code snippet in my application:


But the variable values aren't logged. Where's the mistake. TIA

You should have defined handler level also. I know this topic is very old, but I seem to get here each time I forget this. So I decided to add this information here.

final ConsoleHandler handler = new ConsoleHandler();
handler.setLevel(Level.FINEST);
Logger.getLogger("org.hibernate").addHandler(handler);