Hibernate setting for live environment

Here is the hibernate configuration setting for live environment.

we can use the below for production systems.

If any one has question regarding this please post a comment.

<property name="dialect">
org.hibernate.dialect.MySQLDialect
</property>
<property name="hibernate.c3p0.acquire_increment">3</property>
<property name="hibernate.c3p0.idle_test_period">
54000
</property>
<property name="hibernate.c3p0.timeout">1800</property>
<property name="hibernate.c3p0.max_size">100</property>
<property name="hibernate.c3p0.min_size">3</property>
<property name="hibernate.c3p0.max_statements">0</property>
<property name="hibernate.c3p0.preferredTestQuery">
select 1;
</property>

<property name="current_session_context_class">thread</property>
<!– Cache Settings
<property name="cache.use_second_level_cache">false</property>
<property name="cache.provider_class">org.hibernate.cache.EhCacheProvider</property>

<property name="hibernate.cache.use_query_cache">false</property>–>
<!– End Cache Settings –>
<!– Disable the second-level cache
<property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>–>
<!– Echo all executed SQL to stdout –>
<property name="show_sql">false</property>

--
Thanks & Regards,
B.Chandra Shekhar.
Software Engineer,
Jiva Infotech Pvt Ltd.