Hi,
how to log a prepared statement along with the parameters in hibernate.
Is it possible atall?
Or is there any way to tell to hibernate to use normal statements rather than prepared statements, so that we can log them.
Thanks,
Vijay.

We've found that making the Hibernate categories org.hibernate.SQL and org.hibernate.type have DEBUG level output (with the remainder covered by an ERROR level on org.hibernate) in log4j allows us to see the parameters being bound and the SQL being executed.

You can use p6spy or implement your own with this article as reference http://www-128.ibm.com/developerworks/java/library/j-loggable.html

Thank you guys.

Please rate if any of the posts were helpful.