在服务器部署一段时间后无法与数据库连接 [英] Not able to connect with database after some times of deployment on server
本文介绍了在服务器部署一段时间后无法与数据库连接的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我将我的war文件上传到我的服务器上，它在部署完成后可以正常工作，但经过一段时间后，它会显示异常。
我使用的是struts2和hibernate
我的 hibernate.cfg.xml 是
< session-factory>
< property name =hibernate.dialect> org.hibernate.dialect.MySQLDialect< / property>
< property name =hibernate.connection.driver_class> com.mysql.jdbc.Driver< / property>
< property name =hibernate.connection.url> jdbc：mysql：// localhost：3306 / dbName< / property>
< property name =hibernate.connection.username> UserName< / property>
< property name =hibernate.connection.password>密码< / property>
< property name =hibernate.connection.zeroDateTimeBehavior> round< / property>
< property name =autoReconnect> true< / property>
< property name =show_sql> true< / property>
< property name =format_sql> true< / property>
< property name =maxIdleTime> 0< / property>
< property name =use_sql_comments> true< / property>
< property name =hibernate.connection.pool_size> 20< / property>
< property name =hibernate.current_session_context_class> org.hibernate.context.ThreadLocalSessionContext< / property>
< property name =current_session_context_class>线程< / property>
< / session-factory>
在控制台上执行查询后，显示 Exception
263512233 [http-bio-12414-exec-1768] WARN org.hibernate.util.JDBCExceptionReporter - SQL错误： 0，SQLState：08003
263512233 [http-bio-12414-exec-1768] ERROR org.hibernate.util.JDBCExceptionReporter - 连接关闭后不允许任何操作。连接被驱动程序隐式关闭。
org.hibernate.exception.JDBCConnectionException：无法在org.hibernate.exception.SQLStateConverter.convert（SQLStateConverter.java:99）上执行查询
在org.hibernate.exception.JDBCExceptionHelper中执行
。在org.hibernate.loader.loader.doList（Loader.java:2545）上转换（JDBCExceptionHelper.java:66）
在org.hibernate.loader.Loader.list（Loader.java:2271）
在org.hibernate.loader.hql.QueryLoader.list（QueryLoader.java:459）
在org .hibernate.hql.ast.QueryTranslatorImpl.list（QueryTranslatorImpl.java:365）
at org.hibernate.engine.query.HQLQueryPlan.performList（HQLQueryPlan.java:196）
at org.hibernate.impl .SessionImpl.list（SessionImpl.java:1268）
at org.hibernate.impl.QueryImpl.list（QueryImpl.java:102）
at iland.login.LoginBusiness.HbmLogin（LoginBusiness.java:104 ）
在iland.login.LoginAction.doLogin（LoginAction.java:53）
在sun.reflect.NativeMethodAccessorImpl.invoke0（本机方法）
在sun.reflect.NativeMethodAccessorImpl.invoke（NativeMethodAccessorImpl.java:39）
在sun.reflect.DelegatingMethodAccessorImpl.invoke（DelegatingMethodAccessorImpl.java:25）
at java.lang.reflect.Method.invoke（Method.java:597）
at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction（DefaultActionInvocation.java:450）
at com.opensymphony .xwork2.DefaultActionInvocation.invokeActionOnly（DefaultActionInvocation.java:289）
在com.opensymphony.xwork2.DefaultActionInvocation.invoke（DefaultActionInvocation.java:252）
在org.apache.struts2.interceptor.debugging.DebuggingInterceptor .intercept（DebuggingInterceptor.java:256）
在com.opensymphony.xwork2.DefaultActionInvocation.invoke（DefaultActionInvocation.java:246）
在com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept（DefaultWorkflowInterceptor.java ：167）
在com.opensymphony .xwork2.interceptor.MethodFilterInterceptor.intercept（MethodFilterInterceptor.java:98）
在com.opensymphony.xwork2.DefaultActionInvocation.invoke（DefaultActionInvocation.java:246）
在com.opensymphony.xwork2.validator.ValidationInterceptor .doIntercept（ValidationInterceptor.java:265）
at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept（AnnotationValidationInterceptor.java:68）
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept （MethodFilterInterceptor.java:98）
at com.opensymphony.xwork2.DefaultActionInvocation.invoke（DefaultActionInvocation.java:246）
at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept（ConversionErrorInterceptor.java:138 ）
at com.opensymphony.xwork2.DefaultActionInvocation.invoke（DefaultActionInvocation.java:246）
at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept（ParametersInterceptor.java:239）
在com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept（MethodFilterInterceptor.java:98）
在com.opensymphony.xwork2.DefaultActionInvocation.invoke（DefaultActionInvocation.java:246）
在com.opensymphony.xwork2 .interceptor.ParametersInterceptor.doIntercept（ParametersInterceptor.java:239）
在com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept（MethodFilterInterceptor.java:98）
在com.opensymphony.xwork2.DefaultActionInvocation.invoke （DefaultActionInvocation.java:246）在com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept（StaticParametersInterceptor.java:191）
在com.opensymphony.xwork2.DefaultActionInvocation.invoke（DefaultActionInvocation.java:246 ）
at org.apache.struts2.interceptor.MultiselectInterceptor.intercept（MultiselectInterceptor.java:73）
at com.opensymphony.xwork2.DefaultActionInvocation.invoke（DefaultActionInvocation.java:246）
at org.apache.strut s2.interceptor.CheckboxInterceptor.intercept（CheckboxInterceptor.java:91）
处org.apache.struts2.interceptor.FileUploadInterceptor com.opensymphony.xwork2.DefaultActionInvocation.invoke（DefaultActionInvocation.java:246）
。截距（FileUploadInterceptor.java:252）
。在com.opensymphony.xwork2.DefaultActionInvocation.invoke（DefaultActionInvocation.java:246）
。在com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept（ModelDrivenInterceptor.java： 100）
at com.opensymphony.xwork2.DefaultActionInvocation.invoke（DefaultActionInvocation.java:246）
at com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept（ScopedModelDrivenInterceptor.java:141）
在com.opensymphony.xwork2.DefaultActionInvocation.invoke（DefaultActionInvocation.java:246）
at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept（ChainingInterceptor.java:145）
at com.opensymphony.xwork2 .DefaultActionInvocation.invoke（ DefaultActionInvocation.java:246）在com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept（PrepareInterceptor.java:171
）
在com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept（MethodFilterInterceptor.java： 98）
at com.opensymphony.xwork2.DefaultActionInvocation.invoke（DefaultActionInvocation.java:246）
at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept（I18nInterceptor.java:161）
在com.opensymphony.xwork2.DefaultActionInvocation.invoke（DefaultActionInvocation.java:246）
at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept（ServletConfigInterceptor.java:164）
at com.opensymphony.xwork2 .DefaultActionInvocation.invoke（DefaultActionInvocation.java:246）
at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept（AliasInterceptor.java:193）
at com.opensymphony.xwork2.DefaultActionInvocation.invoke（DefaultActionInvocation .java：246）
在com.opensymp hony.xwork2.interceptor.ExceptionMappingInterceptor.intercept（ExceptionMappingInterceptor.java:189）
处org.apache.struts2.impl com.opensymphony.xwork2.DefaultActionInvocation.invoke（DefaultActionInvocation.java:246）
。 StrutsActionProxy.execute（StrutsActionProxy.java:54）
处org.apache.struts2.dispatcher.ng.ExecuteOperations org.apache.struts2.dispatcher.Dispatcher.serviceAction（Dispatcher.java:563）
。 executeAction（ExecuteOperations.java:77）
处org.apache.catalina.core.ApplicationFilterChain org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter（StrutsPrepareAndExecuteFilter.java:99）
。 internalDoFilter（ApplicationFilterChain.java:243）
在org.apache.catalina.core.ApplicationFilterChain.doFilter（ApplicationFilterChain.java:210）
在org.apache.catalina.core.StandardWrapperValve.invoke（StandardWrapperValve。 java：224）
在org.apache.catalina.core.StandardContextValve.invoke（StandardContext Valve.java:169）美元，org.apache.catalina.authenticator.AuthenticatorBase.invoke（AuthenticatorBase.java:472 B $ B）
在org.apache.catalina.core.StandardHostValve.invoke（StandardHostValve.java： 168）
在org.apache.catalina.valves.ErrorReportValve.invoke（ErrorReportValve.java:100）
at org.apache.catalina.core.StandardEngineValve.invoke（StandardEngineValve.java:118）$ b在org.apache.catalina.connector.CoyoteAdapter.service（CoyoteAdapter.java:405）
$ b在org.apache.coyote.http11.AbstractHttp11Processor.process（AbstractHttp11Processor.java:964）
。在组织.apache.coyote.AbstractProtocol $ AbstractConnectionHandler.process（AbstractProtocol.java:515）
at org.apache.tomcat.util.net.JIoEndpoint $ SocketProcessor.run（JIoEndpoint.java:302）
at java .util.concurrent.ThreadPoolExecutor $ Worker.runTask（ThreadPoolExecutor.java:886）
at java.util.concurrent.ThreadPoolExecutor $ Worker.run（ThreadPoolExecutor.java:908）$ b $ at java.lang.Thread .RU n（Thread.java:662）
导致：com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException：连接关闭后，不允许任何操作。驱动程序隐式关闭连接。
at sun.reflect.NativeConstructorAccessorImpl.newInstance0（Native Method）
at sun.reflect.NativeConstructorAccessorImpl.newInstance（NativeConstructorAccessorImpl.java:39）
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance（DelegatingConstructorAccessorImpl。 java：27）
at java.lang.reflect.Constructor.newInstance（Constructor.java:513）
at com.mysql.jdbc.Util.handleNewInstance（Util.java:407）
at com.mysql.jdbc.Util.getInstance（Util.java:382）
at com.mysql.jdbc.SQLError.createSQLException（SQLError.java:1013）
at com.mysql.jdbc.SQLError .createSQLException（SQLError.java:987）
at com.mysql.jdbc.SQLError.createSQLException（SQLError.java:982）
at com.mysql.jdbc.SQLError.createSQLException（SQLError.java:927 ）
at com.mysql.jdbc.ConnectionImpl.throwConnectionClosedException（ConnectionImpl.java:1213）
at com.mysql.jdbc.ConnectionImpl.checkClosed（ConnectionImpl.java:1200）
at com。 mysql.jd
at com.mysql.jdbc.ConnectionImpl.prepareStatement（ConnectionImpl.java:4169）
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement（AbstractBatcher。
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement（AbstractBatcher.java:452）
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement（AbstractBatcher.java:161）
在org.hibernate.loader.Loader.prepareQueryStatement（Loader.java:1700）
在org.hibernate.loader.Loader.doQuery（Loader.java:801）
在org.hibernate.loader.Loader .doQueryAndInitializeNonLazyCollections（Loader.java:274）
在org.hibernate.loader.Loader.doList（Loader.java:2542）
... 77 more
由com.mysql引起。 jdbc.exceptions.jdbc4.CommunicationsException：从服务器成功接收的最后一个数据包是102,104,208毫秒前。成功发送到服务器的最后一个数据包是102,104,208毫秒前。比服务器配置的'wait_timeout'值长。在应用程序中使用之前，应考虑过期和/或测试连接有效性，增加服务器配置的客户端超时值，或者使用Connector / J连接属性'autoReconnect = true'来避免此问题。
at sun.reflect.NativeConstructorAccessorImpl.newInstance0（Native Method）
at sun.reflect.NativeConstructorAccessorImpl.newInstance（NativeConstructorAccessorImpl.java:39）
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance（DelegatingConstructorAccessorImpl。 java：27）
at java.lang.reflect.Constructor.newInstance（Constructor.java:513）
at com.mysql.jdbc.Util.handleNewInstance（Util.java:407）
在com.mysql.jdbc.SQLError.createCommunicationsException（SQLError.java:1116）
在com.mysql.jdbc.MysqlIO.send（MysqlIO.java:3348）
在com.mysql.jdbc.MysqlIO .sendCommand（MysqlIO.java:1967）
at com.mysql.jdbc.MysqlIO.sqlQueryDirect（MysqlIO.java:2140）
at com.mysql.jdbc.ConnectionImpl.execSQL（ConnectionImpl.java:2626 ）
at com.mysql.jdbc.PreparedStatement.executeInternal（PreparedStatement.java:2111）
at com.mysql.jdbc.PreparedStatement.executeQuery（PreparedStatement.java:2273）
at org。冬眠。 jdbc.AbstractBatcher.getResultSet（AbstractBatcher.java:208）
在org.hibernate.loader.Loader.getResultSet（Loader.java:1953）
在org.hibernate.loader.Loader.doQuery（Loader。 java：802）
... 79 more
导致：java.net.SocketException：在java.net.SocketOutputStream.socketWrite0中破坏
（Native方法）$ b $在java .net.SocketOutputStream.socketWrite（SocketOutputStream.java:92）$ b $在java.net.SocketOutputStream.write（SocketOutputStream.java:136）
在java.io.BufferedOutputStream.flushBuffer（BufferedOutputStream.java:65 ）
在java.io.BufferedOutputStream.flush（BufferedOutputStream.java:123）
在com.mysql.jdbc.MysqlIO.send（MysqlIO.java:3329）
... 87 more
Hibernate：
/ * insert iland.hbm.ErrorLog
* / insert
into
xrcwrn_retail_shop.error_log
（class，method，line_no，error， add_date）
值
（？，？，？，？，？）
8月19，2014 5:23:08 am com.opensymphony.xwork2.util.logging.commons.CommonsLogger错误
SEVERE：处理请求期间发生异常：null
java.lang.NullPointerException
at iland.login.LoginBusiness.LoginSessionSave（LoginBusiness.java:123）
at iland.login.LoginBusiness.HbmLogin（LoginBusiness.java:116）
at iland.login.LoginAction.doLogin（LoginAction.java： 53）
在sun.reflect.NativeMethodAccessorImpl.invoke0（本机方法）
在sun.reflect.NativeMethodAccessorImpl.invoke（NativeMethodAccessorImpl.java:39）
在sun.reflect.DelegatingMethodAccessorImpl.invoke（ DelegatingMethodAccessorImpl.java:25）
at java.lang.reflect.Method.invoke（Method.java:597）
at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction（DefaultActionInvocation.java:450）
at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly（DefaultActionInvocation.java:289）
at com.opensymphony.xwork2.DefaultActionInvocation.i nvoke（DefaultActionInvocation.java:252）
at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept（DebuggingInterceptor.java:256）
at com.opensymphony.xwork2.DefaultActionInvocation.invoke（DefaultActionInvocation。 java：246）
at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept（DefaultWorkflowInterceptor.java:167）
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept（MethodFilterInterceptor.java:98）
at com.opensymphony.xwork2.DefaultActionInvocation.invoke（DefaultActionInvocation.java:246）
at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept（ValidationInterceptor.java:265）
at org .apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept（AnnotationValidationInterceptor.java:68）
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept（MethodFilterInterceptor.java:98）
at com.opensymphony .xwork2.De faultActionInvocation.invoke（DefaultActionInvocation.java:246）
at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept（ConversionErrorInterceptor.java:138）
at com.opensymphony.xwork2.DefaultActionInvocation.invoke（DefaultActionInvocation。 java：246）
at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept（ParametersInterceptor.java:239）
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept（MethodFilterInterceptor.java:98）
at com.opensymphony.xwork2.DefaultActionInvocation.invoke（DefaultActionInvocation.java:246）
at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept（ParametersInterceptor.java:239）
at com .opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept（MethodFilterInterceptor.java:98）
at com.opensymphony.xwork2.DefaultActionInvocation.invoke（DefaultActionInvocation.java:246）
at com.opensymphony.xwork2.interceptor 。静态的ParametersInterceptor.intercept（StaticParametersInterceptor.java:191）
在com.opensymphony.xwork2.DefaultActionInvocation.invoke（DefaultActionInvocation.java:246）
在org.apache.struts2.interceptor.MultiselectInterceptor.intercept（MultiselectInterceptor。 java：73）
at com.opensymphony.xwork2.DefaultActionInvocation.invoke（DefaultActionInvocation.java:246）
at org.apache.struts2.interceptor.CheckboxInterceptor.intercept（CheckboxInterceptor.java:91）
at com.opensymphony.xwork2.DefaultActionInvocation.invoke（DefaultActionInvocation.java:246）
at org.apache.struts2.interceptor.FileUploadInterceptor.intercept（FileUploadInterceptor.java:252）
at com.opensymphony .xwork2.DefaultActionInvocation.invoke（DefaultActionInvocation.java:246）
在com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept（ModelDrivenInterceptor.java:100）
在com.opensymphony.xwork2.DefaultActionInvocation.invoke （DefaultActionInvocation.java ：246）
at com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept（ScopedModelDrivenInterceptor.java:141）
at com.opensymphony.xwork2.DefaultActionInvocation.invoke（DefaultActionInvocation.java:246）
在com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept（ChainingInterceptor.java:145）
at com.opensymphony.xwork2.DefaultActionInvocation.invoke（DefaultActionInvocation.java:246）
at com.opensymphony。 xwork2.interceptor.PrepareInterceptor.doIntercept（PrepareInterceptor.java:171）
处com.opensymphony.xwork2.DefaultActionInvocation com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept（MethodFilterInterceptor.java:98）
。调用（DefaultActionInvocation.java:246）
at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept（I18nInterceptor.java:161）
at com.opensymphony.xwork2.DefaultActionInvocation.invoke（DefaultActionInvocation.java： 246）
在org.apache.struts2.in terceptor.ServletConfigInterceptor.intercept（ServletConfigInterceptor.java:164）
在com.opensymphony.xwork2.DefaultActionInvocation.invoke（DefaultActionInvocation.java:246）
在com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept（ AliasInterceptor.java:193）美元，com.opensymphony.xwork2.DefaultActionInvocation.invoke（DefaultActionInvocation.java:246 b $ b）
在com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept（ExceptionMappingInterceptor.java:189）
at com.opensymphony.xwork2.DefaultActionInvocation.invoke（DefaultActionInvocation.java:246）
at org.apache.struts2.impl.StrutsActionProxy.execute（StrutsActionProxy.java:54）
at org .apache.struts2.dispatcher.Dispatcher.serviceAction（Dispatcher.java:563）
at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction（ExecuteOperations.java:77）
at org.apache .struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter（StrutsPrepareAndExe cuteFilter.java:99）在org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
（ApplicationFilterChain.java:243）
在org.apache.catalina.core.ApplicationFilterChain.doFilter（ApplicationFilterChain.java： 210）
at org.apache.catalina.core.StandardWrapperValve.invoke（StandardWrapperValve.java:224）
at org.apache.catalina.core.StandardContextValve.invoke（StandardContextValve.java:169）$ b在org.apache.catalina.authenticator.AuthenticatorBase.invoke（AuthenticatorBase.java:472）
$ b在org.apache.catalina.core.StandardHostValve.invoke（StandardHostValve.java:168）
。在组织.apache.catalina.valves.ErrorReportValve.invoke（ErrorReportValve.java:100）
at org.apache.catalina.core.StandardEngineValve.invoke（StandardEngineValve.java:118）
at org.apache.catalina .connector.CoyoteAdapter.service（CoyoteAdapter.java:405）
at org.apache.coyote.http11.AbstractHttp11Processor.process（AbstractHttp11Processor.java:964）
at org.apache.coyote.AbstractProtocol $ AbstractConnectionHandler.process（AbstractProtocol.java:515）
at org.apache.tomcat.util.net.JIoEndpoint $ SocketProcessor.run（JIoEndpoint.java:302）
at java.util.concurrent.ThreadPoolExecutor $ Worker.runTask（ThreadPoolExecutor.java:886）$ java.util.concurrent.ThreadPoolExecutor
$ Worker.run（ThreadPoolExecutor.java:908）
at java.lang。 Thread.run（Thread.java:662）
如何解决上述问题。
所以它可以一直正常工作。
编辑：经过几个小时的部署后，它显示出上述问题。在我的服务器上，我使用Apache Tomcat 7和我的sql数据库。
新增功能：
添加以下详细信息：
< property name =hibernate.c3p0.min_size> 5< / property>
< property name =hibernate.c3p0.max_size> 20< / property>
< property name =hibernate.c3p0.timeout> 0< / property>
< property name =hibernate.c3p0.max_statements> 50< / property>
< property name =hibernate.c3p0.idle_test_period> 0< / property>
仍然面临这个问题我应该在这里做什么修改/添加
<在您的配置属性中，您已经使用c3p0属性maxIdleTime，但c3p0属性使用 c3p0。前缀或了hibernate.c3p0。。请注意，启用任何 c3p0 属性都会通过休眠启发式自动启用相应的连接提供程序。在日志中没有看到您正在使用c3p0。如果你没有配置数据源，那么Hibernate将使用 hibernate.connection.provider_class org.hibernate.connection.DriverManagerConnectionProvider 。此连接提供程序内置了可为其设置 hibernate.connection.pool_size 的基本连接池，但它仅用于开发目的。切勿在生产环境中使用它。
您可能会对主题如何解决java.net.SocketException ：破管。一段时间后，您会意识到您在游泳池中保持 open 连接状态，由于以下原因突然关闭另一侧：
- 防火墙或路由器可能会限制空闲连接（MySQL客户端/服务器协议不会
ping）。
- MySQL服务器可能正在关闭空闲连接超过
wait_timeout或
interactive_timeout阈值。
为帮助解决这些问题，可以使用以下提示：
wait_timeout 和 interactive_timeout 设置得足够高。检查是否使用 interactiveClient 。
tcpKeepalive 。
/ * ping * / 开头的查询来执行轻量级ping而不是完整查询。请注意，ping的语法需要与此处指定的完全相同。
这些选项中的一些你最好使用连接池，你可以使用Hibernate。 Hibernate支持commons-dbcp，c3p0和proxool。你也可以在Web服务器上配置JNDI数据源来使用Hibernate，它有一个连接池。请参阅第7章连接与连接器/ J汇集。
如果你想用c3p0配置Hibernate，你应该阅读如何配置C3P0连接池。对于dbcp示例配置，您应该查看 MySQL，Hibernate和Broken Pipe Exception 这篇文章。无论您使用哪种连接池，都取决于您。
I uploaded my war file on my server it works perfectly after deploy but after some time it shows exception. I am using struts2 and hibernate
my hibernate.cfg.xml is
<session-factory>
<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="hibernate.connection.url">jdbc:mysql://localhost:3306/dbName</property>
<property name="hibernate.connection.username">UserName</property>
<property name="hibernate.connection.password">Password</property>
<property name="hibernate.connection.zeroDateTimeBehavior">round</property>
<property name="autoReconnect">true</property>
<property name="show_sql">true</property>
<property name="format_sql">true</property>
<property name="maxIdleTime">0</property>
<property name="use_sql_comments">true</property>
<property name="hibernate.connection.pool_size">20</property>
<property name="hibernate.current_session_context_class">org.hibernate.context.ThreadLocalSessionContext</property>
<property name="current_session_context_class">thread</property>
</session-factory>
On console After executing query it is showing following Exception
263512233 [http-bio-12414-exec-1768] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: 08003
263512233 [http-bio-12414-exec-1768] ERROR org.hibernate.util.JDBCExceptionReporter - No operations allowed after connection closed.Connection was implicitly closed by the driver.
org.hibernate.exception.JDBCConnectionException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:99)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2545)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
at org.hibernate.loader.Loader.list(Loader.java:2271)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:459)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:365)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at iland.login.LoginBusiness.HbmLogin(LoginBusiness.java:104)
at iland.login.LoginAction.doLogin(LoginAction.java:53)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:450)
at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:289)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:252)
at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:256)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:167)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:265)
at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:138)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:239)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:239)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:191)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:73)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:91)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:252)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:100)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:141)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:145)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:171)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:161)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:193)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:189)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54)
at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:563)
at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)
at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:99)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:405)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:964)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:515)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:302)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.Connection was implicitly closed by the driver.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.Util.getInstance(Util.java:382)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
at com.mysql.jdbc.ConnectionImpl.throwConnectionClosedException(ConnectionImpl.java:1213)
at com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1200)
at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4203)
at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4169)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)
at org.hibernate.loader.Loader.doQuery(Loader.java:801)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
at org.hibernate.loader.Loader.doList(Loader.java:2542)
... 77 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 102,104,208 milliseconds ago. The last packet sent successfully to the server was 102,104,208 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3348)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1967)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2273)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
at org.hibernate.loader.Loader.doQuery(Loader.java:802)
... 79 more
Caused by: java.net.SocketException: Broken pipe
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)
at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3329)
... 87 more
Hibernate:
/* insert iland.hbm.ErrorLog
*/ insert
into
xrcwrn_retail_shop.error_log
(class, method, line_no, error, add_date)
values
(?, ?, ?, ?, ?)
Aug 19, 2014 5:23:08 AM com.opensymphony.xwork2.util.logging.commons.CommonsLogger error
SEVERE: Exception occurred during processing request: null
java.lang.NullPointerException
at iland.login.LoginBusiness.LoginSessionSave(LoginBusiness.java:123)
at iland.login.LoginBusiness.HbmLogin(LoginBusiness.java:116)
at iland.login.LoginAction.doLogin(LoginAction.java:53)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:450)
at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:289)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:252)
at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:256)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:167)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:265)
at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:138)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:239)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:239)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:191)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:73)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:91)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:252)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:100)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:141)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:145)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:171)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:161)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:193)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:189)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54)
at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:563)
at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)
at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:99)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:405)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:964)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:515)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:302)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
How to resolve above problem. So that it can work properly all the time.
Edit: After few hours of deployment it is showing above problem. On my server I am using Apache Tomcat 7 and my sql database.
New Addition: Added following details
<property name="hibernate.c3p0.min_size">5</property>
<property name="hibernate.c3p0.max_size">20</property>
<property name="hibernate.c3p0.timeout">0</property>
<property name="hibernate.c3p0.max_statements">50</property>
<property name="hibernate.c3p0.idle_test_period">0</property>
Still facing the problem what modification/addition should I make here
解决方案
In your configuration properties you have used c3p0 property maxIdleTime, but c3p0 properties are configured using c3p0. prefix or hibernate.c3p0.. Note that enabling any of c3p0 properties automatically enables the corresponding connection provider by hibernate heuristics. In the log isn't seen that you are using c3p0. If you are not configured data sources then Hibernate will use hibernate.connection.provider_class org.hibernate.connection.DriverManagerConnectionProvider. This connection provider has in-built rudimentary connection pool for which you can set a hibernate.connection.pool_size, but it is used only for development purposes. Never use it in the production environment.
You might have endless discussion on topic How to fix java.net.SocketException: Broken pipe. After some time you will realize that you have remained open connections in the pool, which are suddenly closed on the other side by the following reasons:
- Firewalls or routers may clamp down on idle connections (the MySQL client/server protocol does not ping).
- The MySQL Server may be closing idle connections that exceed the
wait_timeoutorinteractive_timeoutthreshold.
To help troubleshoot these issues, the following tips can be used:
- A recent (5.1.13+) version of JDBC driver is used.
- Ensure that
wait_timeoutandinteractive_timeoutare set sufficiently high. Check ifinteractiveClientis used. - Ensure that
tcpKeepaliveis enabled. - Ensure that any configurable firewall or router timeout settings allow for the maximum expected connection idle time.
- Ensure connections are valid when used from the connection pool. Use a query that starts with
/* ping */to execute a lightweight ping instead of full query. Note, the syntax of the ping needs to be exactly as specified here. - Explicitly validate the connection before using it if the connection has been left idle for an extended period of time.
- Minimize the duration a connection object is left idle while other application logic is executed.
To comply to some of this options you'd better use a connection pool that you can use with Hibernate. Hibernate has support for commons-dbcp, c3p0, and proxool. Also you can configure JNDI data source on web server to use with hibernate, it has a connection pool. See Chapter 7 Connection Pooling with Connector/J.
If you like to configure Hibernate with c3p0 you should read this How-To configure the C3P0 connection pool. For dbcp example configuration you should check this post MySQL, Hibernate and Broken Pipe Exception. Whatever connection pooling you will use is up to you.
这篇关于在服务器部署一段时间后无法与数据库连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
