logging sql, can I get rid of ?, ?, ?

deanhiller · **Joined:** Thu Sep 16, 2004 4:56 pm **Posts:** 80

The logging of sql statements seems to be real nice except for when it runs inserts/updates, it logs stuff like this....

Code:

Hibernate: insert into Parents (name, Version, Id) values (?, ?, ?)
Hibernate: insert into Children (name, parent_id, Version, Id) values (?, ?, ?, ?)
Hibernate: insert into Children (name, parent_id, Version, Id) values (?, ?, ?, ?)
Hibernate: update Parents set name=?, Version=? where Id=? and Version=?

I want to see what was inserted or what those question marks really are. Is there a way to change that? I am especially trying to figure out why that last update was run....the three inserts should have been enough.
thanks,
dean

axismundi · **Joined:** Mon Aug 22, 2005 5:45 am **Posts:** 146

deanhiller wrote:

The logging of sql statements seems to be real nice except for when it runs inserts/updates, it logs stuff like this....

Code:

Hibernate: insert into Parents (name, Version, Id) values (?, ?, ?)
Hibernate: insert into Children (name, parent_id, Version, Id) values (?, ?, ?, ?)
Hibernate: insert into Children (name, parent_id, Version, Id) values (?, ?, ?, ?)
Hibernate: update Parents set name=?, Version=? where Id=? and Version=?

I want to see what was inserted or what those question marks really are. Is there a way to change that? I am especially trying to figure out why that last update was run....the three inserts should have been enough.
thanks,
dean

the question marks are placeholders for the values, because hibernate is using PreparedStatement's internally. AFAIK it's impossible to let the values show.
to track down what your app is doing you should start your debugger.

max · **Posted:** Sun Apr 23, 2006 2:47 pm

dudes - you need to read the manual.

http://www.hibernate.org/hib_docs/v3/re ... on-logging

stolley · **Posted:** Sun Apr 23, 2006 7:23 pm

I haven't used HB in a while, so I haven't checked out any of the new logging options; but when I needed to do stuff like that I used to use a product called P6Spy (it's not actively supported anymore but will still work for what you want to do).

It outputs the sql with the positional markers (the "?" characters) replaced with the values that were passed to the JDBC call.

Even if the newer HB formatting options do what you want, this can still be a useful option. With correct configuration, it works for direct SQL that was not issued using the Hibernate API At all.

http://sourceforge.net/projects/p6spy/

max · **Posted:** Mon Apr 24, 2006 1:31 am

1) they are not new logging options (they have been there since forever)

2) p6spy and similar technologies is also very much recommended since it works across hibernate and non-hibernate access. (but requires a little more setup than just enable a logging level)

axismundi · **Joined:** Mon Aug 22, 2005 5:45 am **Posts:** 146

max wrote:

dudes - you need to read the manual.

http://www.hibernate.org/hib_docs/v3/re ... on-logging

that'a helpfull hint, really!