Edit Question - KnowledgeHub

Title Body

We are implementing a Web App using JPA2.0 and Hibernate3.0. Connection pool configurations are set in persistence.xml located in META-INF folder. persistence.xml: <persistence xmlns="http://java.sun.com/xml/ns/persistence" version="2.0"> <persistence-unit name="MyPU" transaction-type="RESOURCE_LOCAL">  <properties> <property name="hibernate.connection.driver_class" value="com.mysql.jdbc.Driver"/> <property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5InnoDBDialect"/> <property name="hibernate.show_sql" value="true"/> <property name="bytecode.provider" value="org.hibernate.bytecode.javassist.BytecodeProviderImpl"/> <property name="hibernate.connection.username" value="{username}"/> <property name="hibernate.connection.password" value="{password}"/> <property name="hibernate.hbm2ddl.auto" value="update"/> <property name="hibernate.format_sql" value="true"/> <property name="hibernate.connection.url" value="{jdbc url}"/> <property name="hibernate.c3p0.min_size" value="1"/> <property name="hibernate.c3p0.timeout" value="1000"/> <property name="hibernate.c3p0.acquire_increment" value="1"/> <property name="hibernate.c3p0.idle_test_periods" value="600"/> <property name="hibernate.c3p0.testConnectionOnCheckin" value="true"/> <property name="hibernate.c3p0.preferredTestQuery" value="SELECT 1;"/> </properties> </persistence-unit> </persistence> We have a problem with connection pool configurations. It seems the configurations have no effect and the connection will be broken after 8 hours. Do we need another configuration file like hibernate.cfg

Tags (comma-separated) Cancel