Hibernate show_sql not working

[Anand Bhatt]

Hi,
I have integrated spring with hibernate and use the below snippet in spring-context.xml file,to use "show_sql" property of hibernate.
But I can not see any sql at my console.

<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">
org.hibernate.dialect.HSQLDialect
</prop>
<prop key="show_sql">true</prop>
</props>
</property>

Any idea,where I am missing?

[Anand Bhatt]

Hi,
I forgot to add a prefix hibernate to "show_sql".Now ot ok
Thanks!