Hi,

I want to change the configuration at runtime ie enable/disable "hibernate.show_sql" property. I see that I can do it thru either xml file or thru configuration object. However, once SessionFactory is created out of configuration object, it will be static forever? Can I can set any properties after SessionFactory is created ? I want to set the "hibernate.show_sql" property after SessionFactory is created. Is this possible? Or do I have to create a new SessionFactory everytime, I change the configuration object?

Thanks for your help.

Basically you're not allowed to change the settings once the factory is configured.

You could create 2 factories - 1 with show_sql=true, one with show_sql=false and choose which to use at runtime. For example, by adding a static setShowSqlEnabled method to HibernateUtil to decide which factory to generate a Session from, or adding a showSql parameter to getSession.

Mike