I am using Hibernate 3.0.5 and Hibernate Transaction manager to manage transaction. When flushing the objects, say Oracle DB didnt accept and JDBC driver throws the exception with message "cannot insert NULL into <some table>".
This is result of an insert query fired.
is there any way to find the object to log the values in the object to trace the problem?

Hi,

I personally know following ways to log sql-statements:

log4j.logger.org.hibernate.SQL=TRACE

This logs just the prepared statement SQL (no values, only place holder "?" )
To log Log JDBC bind parameter runtime arguments:

log4j.logger.org.hibernate.type=TRACE

Unfortunately the output is not well formated and rather unreadable.
Personally I prefer to use P6spy (http://www.p6spy.com/) to log my hiberante sql-statements.

Thanks pb00067.

I will certainly look deeper into this. I went through P6spy on the higher level.
I cant enable trace in PROD servers. I want the details of bean only when an exception happens.
Is there any way to interept that?

Have anybody tried something like this?