Hi *,
I'm using
Hibernate version 3.2.0.ga
Hibernate Annotations 3.2.1.ga.
Oracle10g

In our application we use all sort of queries- Named HQL, normal HQL, SQL etc. Obviously in most HQL/SQLs we use parameters.

How to configure (hibernate config xml file) to print the SQL/HQL parameters in the logs?
I can display formatted (using <property name="hibernate.show_sql">true</property>) SQL and HQL queries with ? (question marks) for the parameters. HOW CAN I ALSO DISPLAY THE PARAMETER USED IN THE SQL?HQL IN QUESTION?

Any help is greatly appreciated.

~/Gurram

log4j.logger.org.hibernate.SQL=debug
log4j.logger.org.hibernate.bind=debug

Is there an "log4j.xml" equivalent for the following?

log4j.logger.org.hibernate.SQL=debug
log4j.logger.org.hibernate.bind=debug

~/Gurram

<logger name="org.hibernate.SQL">
<level value="DEBUG"/>
</logger>
<logger name="org.hibernate.bind">
<level value="DEBUG"/>
</logger>