使用DBCP连接池时出现MySql 8小时断开连接的解决方法

最新推荐文章于 2023-03-13 14:28:24 发布

hong2511

最新推荐文章于 2023-03-13 14:28:24 发布

阅读量302

点赞数

文章标签：解决解决方法连接池连接 mysql sql

原文地址为：使用DBCP连接池时出现MySql 8小时断开连接的解决方法

org.hibernate.exception.JDBCConnectionException: could not extract ResultSet] with root cause

Jan 05, 2016 10:14:09 AM org.apache.catalina.core.StandardWrapperValve invoke

SEVERE: Servlet.service() for servlet [dispatcher] in context with path [/book-shuxiang-api] threw exception [Request processing failed; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.JDBCConnectionException: could not extract ResultSet] with root cause

java.net.SocketException: Broken pipe

at java.net.SocketOutputStream.socketWrite0(Native Method)

at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:109)

at java.net.SocketOutputStream.write(SocketOutputStream.java:153)

at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)

at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)

at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3634)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2460)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2551)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)

at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1962)

at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)

at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:80)

at org.hibernate.loader.Loader.getResultSet(Loader.java:2065)

at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1862)

at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1838)

at org.hibernate.loader.Loader.doQuery(Loader.java:909)

at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:354)

at org.hibernate.loader.Loader.doList(Loader.java:2553)

at org.hibernate.loader.Loader.doList(Loader.java:2539)

at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2369)

at org.hibernate.loader.Loader.list(Loader.java:2364)

at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:496)

at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:387)

at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:231)

at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1264)

at org.hibernate.internal.QueryImpl.list(QueryImpl.java:103)

at org.hibernate.jpa.internal.QueryImpl.list(QueryImpl.java:573)

at org.hibernate.jpa.internal.QueryImpl.getResultList(QueryImpl.java:449)

at com.book.persist.dao.im.impl.GroupDaoImpl.getByGroupId(GroupDaoImpl.java:122)

at com.book.service.book.im.impl.GroupServiceImpl.getByGroupId(GroupServiceImpl.java:237)

at com.book.service.book.im.impl.GroupServiceImpl$$FastClassByCGLIB$$1a96e08e.invoke(<generated>)

at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)

at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:698)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)

at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)

at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)

at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:631)

at com.book.service.book.im.impl.GroupServiceImpl$$EnhancerByCGLIB$$f571d131.getByGroupId(<generated>)

at com.book.shuxiang.api.controller.im.GroupController.groupInfo(GroupController.java:193)

at com.book.shuxiang.api.controller.im.GroupController$$FastClassByCGLIB$$21102ae2.invoke(<generated>)

at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)

at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:698)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)

at org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:64)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:631)

at com.book.shuxiang.api.controller.im.GroupController$$EnhancerByCGLIB$$8e4569e5.groupInfo(<generated>)

使用DBCP连接池时出现MySql 8小时断开连接的解决方法

修改l配置文件：

修改如下：

<data-sources>

<data-source key="org.apache.struts.action.DATA_SOURCE" type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="driverClassName" value="com.mysql.jdbc.Driver" />
<set-property property="description" value="wjjg" />
<set-property property="url" value="jdbc:mysql://localhost/wjjg?useUnicode=true&characterEncoding=GB2312" />
<set-property property="password" value="12345678" />
<set-property property="username" value="wjjg" />
<set-property property="maxActive" value="10" />
<set-property property="maxIdle" value="60000" />
<set-property property="maxWait" value="60000" />
<set-property property="defaultAutoCommit" value="true" />
<set-property property="defaultReadOnly" value="false" />
<set-property property="testOnBorrow" value="true"/>
<set-property property="validationQuery" value="select 1"/>