Hi i have a problem with hibernate.
I can't find the hibernate property that allows me to reconnect to the database after the connection to the database was lost.
I use Hibernate 3.2.4.sp1 with cp30 and MS SQL Server 2005 and my persistence unit looks like:
Code:
<persistence-unit name="apppersistence">
<provider>org.hibernate.ejb.HibernatePersistence</provider>
<jta-data-source>java:/ibxrequestDatasource</jta-data-source>
<properties>
<property name="hibernate.connection.isolation" value="4096"/>
<property name="hibernate.hbm2ddl.auto" value="validate"/>
<property name="hibernate.cache.use_query_cache" value="true"/>
<property name="hibernate.cache.use_second_level_cache" value="true"/>
<property name="hibernate.cache.provider_class" value="org.hibernate.cache.EhCacheProvider"/>
<property name="hibernate.cache.provider_configuration_file_resource_path" value="ehcache.xml"/>
<property name="hibernate.cache.region_prefix" value=""/>
<property name="hibernate.show_sql" value="false"/>
<property name="hibernate.format_sql" value="false"/>
<property name="hibernate.max_fetch_depth" value="2"/>
<property name="hibernate.use_sql_comments" value="true"/>
<property name="hibernate.default_batch_fetch_size" value="32"/>
<property name="hibernate.order_updates" value="false"/>
<property name="jboss.entity.manager.factory.jndi.name" value="java:/appDS"/>
<property name="hibernate.default_schema" value="dbo"/>
<property name="hibernate.connection.driver_class" value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>
<property name="hibernate.dialect" value="org.hibernate.dialect.SQLServerDialect"/>
<property name="hibernate.c3p0.min_size" value="5"/>
<property name="hibernate.c3p0.max_size" value="200"/>
<property name="hibernate.c3p0.timeout" value="1800"/>
<property name="hibernate.c3p0.max_statements" value="50"/>
</properties>
</persistence-unit>
Can somebody help me with this problem.
Thanks.