出现如下异常
解决的方式:参考hibernate配置文件:
解决的方式:参考hibernate配置文件:
- <!--MySql驱动程序eg.mysql-connector-java-5.0.4-bin.jar-->
- <propertyname="dialect">org.hibernate.dialect.MySQLDialect</property>
- <propertyname="connection.driver_class">com.mysql.jdbc.Driver</property>
- <!--JDBCURL-->
- <propertyname="connection.url">
- jdbc:mysql://localhost/tonyshao?characterEncoding=gb2312&zeroDateTimeBehavior=convertToNull
- </property>
- <propertyname="connection.username">user</property>
- <propertyname="connection.password">passport</property>
- <propertyname="hibernate.cache.provider_class">org.hibernate.cache.EhCacheProvider</property>
- <propertyname="hibernate.cache.use_query_cache">true</property>
- <propertyname="hibernate.connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property>
- <propertyname="hibernate.connection.pool_size">2</property>
- <!--连接关闭时默认将所有未提交的操作回滚。Default:false-->
- <propertyname="hibernate.connection.autocommit">false</property>
- <!--c3p0connectionpoolingproperties-->
- <!--数据库连接对象最大持有时间,这个timeout一定要大于MYSQL默认的28800(秒)-->
- <propertyname="c3p0.timeout">30000</property>
- <!--最大可缓存数据库语句对象-->
- <propertyname="c3p0.max_statements">50</property>
- <!--每隔28000s测试连接是否可用-->
- <propertyname="c3p0.idle_test_period">28000</property>
- <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&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>
- Lastpacketsenttotheserverwas1msago.
- STACKTRACE:
- com.mysql.jdbc.CommunicationsException:Communicationslinkfailureduetounderlyingexception:
- **BEGINNESTEDEXCEPTION**
- java.net.SocketException
- MESSAGE:Brokenpipe
- STACKTRACE:
- java.net.SocketException:Brokenpipe
- atjava.net.SocketOutputStream.socketWrite0(NativeMethod)
- atjava.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
- atjava.net.SocketOutputStream.write(SocketOutputStream.java:136)
- atjava.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)
- atjava.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
- atcom.mysql.jdbc.MysqlIO.send(MysqlIO.java:2692)
- atcom.mysql.jdbc.MysqlIO.send(MysqlIO.java:2621)
- atcom.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1552)
- atcom.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
- atcom.mysql.jdbc.Connection.execSQL(Connection.java:2994)
- atcom.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)
- atcom.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030)
- atorg.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139)
- atorg.hibernate.loader.Loader.getResultSet(Loader.java:1669)
- atorg.hibernate.loader.Loader.doQuery(Loader.java:662)
- atorg.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
- atorg.hibernate.loader.Loader.loadEntity(Loader.java:1785)