Help with Broken pipe

Question

Guys, I have a problem in my system, it is falling too much the connection as database, this system gets to 12 hours idle, I need a help to configure C3P

<!--Configuração do pool de c3p0         -->
<property name="c3p0.acquire_increment"         value="10"    /> 
<property name="hibernate.c3p0.min_size"        value="20"     />
<property name="hibernate.c3p0.max_size"        value="50"   />
<property name="hibernate.c3p0.timeout"         value="144000"/>
<property name="hibernate.c3p0.max_statements"  value="50"    /> 
<property name="c3p0.idle_test_period"          value="3000"   />

Answer 1

I had a similar problem when I went to test my TC, the solution I found was to apply the following attributes in Persistence.xml. If you haven’t solved it yet, try these parameters in the xml of Hibernate.

 <property name="connection.autoReconnect" value="true"/>
 <property name="connection.autoReconnectForPools" value="true"/>