解决java.net.SocketException: Broken pipe异常

出现如下异常
解决的方式:参考hibernate配置文件：

Java代码

1. <!--MySql驱动程序eg.mysql-connector-java-5.0.4-bin.jar-->
2. <propertyname="dialect">org.hibernate.dialect.MySQLDialect</property>
3. <propertyname="connection.driver_class">com.mysql.jdbc.Driver</property>
5. <!--JDBCURL-->
6. <propertyname="connection.url">
7. jdbc:mysql://localhost/tonyshao?characterEncoding=gb2312&amp;zeroDateTimeBehavior=convertToNull
8. </property>
10. <propertyname="connection.username">user</property>
11. <propertyname="connection.password">passport</property>
13. <propertyname="hibernate.cache.provider_class">org.hibernate.cache.EhCacheProvider</property>
14. <propertyname="hibernate.cache.use_query_cache">true</property>
16. <propertyname="hibernate.connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property>
17. <propertyname="hibernate.connection.pool_size">2</property>
18. <!--连接关闭时默认将所有未提交的操作回滚。Default:false-->
19. <propertyname="hibernate.connection.autocommit">false</property>
21. <!--c3p0connectionpoolingproperties-->
22. <!--数据库连接对象最大持有时间,这个timeout一定要大于MYSQL默认的28800（秒）-->
23. <propertyname="c3p0.timeout">30000</property>
24. <!--最大可缓存数据库语句对象-->
25. <propertyname="c3p0.max_statements">50</property>
26. <!--每隔28000s测试连接是否可用-->
27. <propertyname="c3p0.idle_test_period">28000</property>
28. <propertyname="c3p0.acquire_increment">1</property>

	<!--MySql 驱动程序 eg. mysql-connector-java-5.0.4-bin.jar-->
	<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
	<property name="connection.driver_class">com.mysql.jdbc.Driver</property>

	<!-- JDBC URL -->
	<property name="connection.url">
		jdbc:mysql://localhost/tonyshao?characterEncoding=gb2312&amp;zeroDateTimeBehavior=convertToNull
	</property>

	<property name="connection.username">user</property>
	<property name="connection.password">passport</property>

	<property name="hibernate.cache.provider_class">org.hibernate.cache.EhCacheProvider</property>
	<property name="hibernate.cache.use_query_cache">true</property>
	
	<property name="hibernate.connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property> 
	<property name="hibernate.connection.pool_size">2</property>
	<!--连接关闭时默认将所有未提交的操作回滚。Default: false -->
	<property name="hibernate.connection.autocommit">false</property>
	
	<!-- c3p0 connection pooling properties -->
    <!-- 数据库连接对象最大持有时间,这个timeout一定要大于MYSQL默认的28800（秒） -->
    <property name="c3p0.timeout">30000</property>
    <!-- 最大可缓存数据库语句对象 -->
    <property name="c3p0.max_statements">50</property>
    <!-- 每隔28000s测试连接是否可用 -->
    <property name="c3p0.idle_test_period">28000</property>
    <property name="c3p0.acquire_increment">1</property>

Java代码

1. Lastpacketsenttotheserverwas1msago.
3. STACKTRACE:
5. com.mysql.jdbc.CommunicationsException:Communicationslinkfailureduetounderlyingexception:
7. **BEGINNESTEDEXCEPTION**
9. java.net.SocketException
10. MESSAGE:Brokenpipe
12. STACKTRACE:
14. java.net.SocketException:Brokenpipe
15. atjava.net.SocketOutputStream.socketWrite0(NativeMethod)
16. atjava.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
17. atjava.net.SocketOutputStream.write(SocketOutputStream.java:136)
18. atjava.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)
19. atjava.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
20. atcom.mysql.jdbc.MysqlIO.send(MysqlIO.java:2692)
21. atcom.mysql.jdbc.MysqlIO.send(MysqlIO.java:2621)
22. atcom.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1552)
23. atcom.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
24. atcom.mysql.jdbc.Connection.execSQL(Connection.java:2994)
25. atcom.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)
26. atcom.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030)
27. atorg.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139)
28. atorg.hibernate.loader.Loader.getResultSet(Loader.java:1669)
29. atorg.hibernate.loader.Loader.doQuery(Loader.java:662)
30. atorg.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
31. atorg.hibernate.loader.Loader.loadEntity(Loader.java:1785)