First off, I looked at several posts relating to hibernate.show_sql, sql output etc. but I did not see any that address what I am interested in.

With hibernate.show_sql="true" in Hibernate 3.0.5 the engine outputs SQL like the following:

Is it possible to have it output the actual values? (ie. something like the following, where the values are displayed not as '?' but as the actual data...or a truncated version of the data values):




Q: If there isn't anything currently available, is there a "best practice" for intercepting/extending this behavior?

Again, if this has already been answered, my apologies, but please provide the link to the answer if that is the case.

Thanks in advance,
John

If you set your log-level to DEBUG you will get the values, just a little further down the log

Thanks pksiv,

While that is helpful info, it is not exactly what I am looking for. I would like to isolate the sql call and, perhaps, replace each '?' with a formatted version of the data.

In there is a log call which dumps the sql to System.out. So it appears that the sql statement has been pre-prepared and then stored and retrieved. And based on the hibernate.show_sql it is output to the console.

I suppose to do what I am asking would be to intercept the sql at the point where it is executed and resolve each '?' with an array of objects.