Turning "show_sql" on and off programmatically

fedot · **Joined:** Thu Dec 15, 2005 2:30 pm **Posts:** 10

Is it possible to flip "hibernate.show_sql" property on and off programmatically? I would like to start off with no SQL being shown and only display queries displayed for few specific database access calls. Thanks!

snpesnpe · **Joined:** Sat Jun 12, 2004 4:49 pm **Posts:** 915

i think that you have to rebuild session after change environment, but you can do what you want with extract sql query from query translator - see example in HQLTest for usage
query translator

max · **Posted:** Fri Dec 16, 2005 2:49 am

much better to use the log4j categories org.hibernate.SQL if you want to dynamically control when it should output.

hardikjadhav · **Joined:** Thu Oct 20, 2005 7:48 am **Posts:** 19

for this u have to maintain exatra code/method .
it's batter that you use log4j to show and hide SQL.

fedot · **Joined:** Thu Dec 15, 2005 2:30 pm **Posts:** 10

Didn't think about using log4j and turning IT on and off. Thanks!