Hi All,

How i can change hibernate.show_sql property programatically without bring down the ApplicationServer.
The requirement is hibernate.show_sql property could be changing without shutting down the server.

Here the hibernate configuration file where hibernate.show_sql property value is hardcoded to "true".

<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">org.hibernate.dialect.DB2Dialect</prop>
<prop key="hibernate.show_sql">true</prop>
<prop key="hibernate.max_fetch_depth">10</prop>
<prop key="hibernate.default_schema">MyApplication</prop>
<prop key="hibernate.format_sql">false</prop>
<prop key="hibernate.query.factory_class">org.hibernate.hql.classic.ClassicQueryTranslatorFactory</prop>
<prop key="hibernate.cache.use_query_cache">false</prop>
<prop key="hibernate.cache.use_second_level_cache">false</prop>

<prop key="hibernate.cache.use_query_cache">false</prop>
<prop key="hibernate.cache.use_second_level_cache">false</prop>
<prop key="hibernate.use_sql_comments">false</prop>
<prop key="hibernate.default_schema">MySchema</prop>\
</props>
</property>

See this: http://hibernar.org/foro/viewtopic.php?f=4&t=4

You can dynamically change the log4j thresholds to turn on/off this information, e.g. by doing this:

Logger.getLogger("org.hibernate.SQL").setThreshold(Level.INFO);