Java: c3p0.ComboPooledDataSource broken pipe Error With MySQL
April 13th, 2009 by jeremychoneThis usually happen when the client connection pool maintained connection longer than the database connection. Fix: set the maxIdleTime property:
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
<property name="driverClass" value="${db.driverClass}" />
<property name="jdbcUrl" value="${db.jdbcUrl}" />
<property name="user" value="${db.user}" />
<property name="password" value="${db.password}" />
<!-- 1/2 hr. MySQL server default connection timeout is 43200 (12hrs) -->
<property name="maxIdleTime" value="1800" />
</bean>
Information Source: Broken pipe
