I need to have complete logging of SQL for all INSERTS, UPDATES and DELETES. I cannot find a way to have the prepared statements enter the values used in those statements. Is there a log4j setting I am missing? Or am I going to have to make my own solution?

Thanks.

Enable TRACE logging for org.hibernate.type and DEBUG for org.hibernate.SQL and you'll have most everything. You can also use a tool like P6Spy.

-Chris

Thanks for the reply, I have those enabled and that is how I am getting the "UPDATE foo set report=?, title=? WHERE id=?"

I need those ? values somehow.

Look at the subsequent log lines for org.hibernate.type. They will give you all the bind parameters, one per log line. So you'll see something like this:

1725 DEBUG org.hibernate.SQL - update CHILD set PARENT_ID=? where ID=?
1726 DEBUG org.hibernate.type.LongType - binding '1' to parameter: 1
1726 DEBUG org.hibernate.type.LongType - binding '1' to parameter: 2

Enjoy.

Ahh my mistake, fat fingered the logging stuffs. TRACE on type does give me the info.
Is it possible to further define that I only care about whats going in my SQL and not get the "RETURNING ..." pieces? The returning output is making my logs exceed 15mb+ in a few queries =/

Not in the current codebase because both get and set are encapsulated in *Type. This has come up before and I thought there was a JIRA for it but I can't find it just now. You'd only really want this in a local or dev environment (due to log size and possibly security issues) so maybe P6spy is the way to go for you (AFIAK it is a bit more configurable).

Hi,
what dbms are you using? You can always enable tracing/logging on the server side (not in production of course).