net.hasor.db.jdbc.core.JdbcTemplate - java.sql.SQLException: Connection is closed · Issue #I3Z82Y · 杭州开云集致科技有限公司/hasor

三个数据源  一个是mysql  一个sqlserver  一个orcal  ,网络正常情况下没事， orcal数据 这个网络 有时周末会断两天，一断两天就会出现ERROR net.hasor.db.jdbc.core.JdbcTemplate - 
java.sql.SQLException: Connection is closed
	at com.zaxxer.hikari.pool.ProxyConnection$ClosedConnection.lambda$getClosedConnection$0(ProxyConnection.java:515)
	at com.sun.proxy.$Proxy40.prepareStatement(Unknown Source)
	at com.zaxxer.hikari.pool.ProxyConnection.prepareStatement(ProxyConnection.java:337)
	at com.zaxxer.hikari.pool.HikariProxyConnection.prepareStatement(HikariProxyConnection.java)
	at sun.reflect.GeneratedMethodAccessor218.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at net.hasor.db.datasource.CloseSuppressingInvocationHandler.invoke(CloseSuppressingInvocationHandler.java:57)
	at com.sun.proxy.$Proxy219.prepareStatement(Unknown Source)
	at sun.reflect.GeneratedMethodAccessor218.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at net.hasor.db.jdbc.core.JdbcConnection$CloseSuppressingInvocationHandler.invoke(JdbcConnection.java:182)
	at com.sun.proxy.$Proxy220.prepareStatement(Unknown Source)
	at net.hasor.db.jdbc.core.JdbcTemplate$SimplePreparedStatementCreator.createPreparedStatement(JdbcTemplate.java:879)
	at net.hasor.db.jdbc.core.JdbcTemplate.lambda$execute$1(JdbcTemplate.java:163)
	at net.hasor.db.jdbc.core.JdbcConnection.execute(JdbcConnection.java:119)
	at net.hasor.db.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:161)
	at net.hasor.db.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:208)
	at net.hasor.dataql.fx.db.runsql.SqlFragment.lambda$noPageFragment$6(SqlFragment.java:287)
	at net.hasor.dataql.fx.db.runsql.SqlFragment.executeSQL(SqlFragment.java:313)
	at net.hasor.dataql.fx.db.runsql.SqlFragment.executeSQL(SqlFragment.java:292)
	at net.hasor.dataql.fx.db.runsql.SqlFragment.noPageFragment(SqlFragment.java:244)
	at net.hasor.dataql.fx.db.likemybatis.MybatisFragment.runFragment(MybatisFragment.java:47)
	at net.hasor.dataql.runtime.mem.RefFragmentCall.call(RefFragmentCall.java:96)
	at net.hasor.dataql.runtime.mem.RefCall.invokeMethod(RefCall.java:53)
	at net.hasor.dataql.runtime.inset.CALL.doWork(CALL.java:57)
	at net.hasor.dataql.runtime.inset.OpcodesPool.doWork(OpcodesPool.java:45)
	at net.hasor.dataql.runtime.mem.RefLambdaCall.call(RefLambdaCall.java:53)
	at net.hasor.dataql.runtime.mem.RefCall.invokeMethod(RefCall.java:53)
	at net.hasor.dataql.runtime.inset.CALL.doWork(CALL.java:57)
	at net.hasor.dataql.runtime.inset.OpcodesPool.doWork(OpcodesPool.java:45)
	at net.hasor.dataql.runtime.QueryImpl.execute(QueryImpl.java:83)
	at net.hasor.dataql.runtime.QueryImpl.execute(QueryImpl.java:37)
	at net.hasor.dataql.Query.execute(Query.java:50)
	at net.hasor.dataway.service.ApiCallService._doCall(ApiCallService.java:143)
	at net.hasor.dataway.service.ApiCallService.doCallWithoutError(ApiCallService.java:54)
	at net.hasor.dataway.service.InterfaceApiFilter.doInvoke(InterfaceApiFilter.java:132)
	at net.hasor.web.binder.FilterDef.doInvoke(FilterDef.java:99)
	at net.hasor.web.invoker.InvokerChainInvocation.doNext(InvokerChainInvocation.java:41)
	at net.hasor.dataql.fx.web.FxWebInterceptor.doInvoke(FxWebInterceptor.java:40)
	at net.hasor.web.binder.FilterDef.doInvoke(FilterDef.java:99)
	at net.hasor.web.invoker.InvokerChainInvocation.doNext(InvokerChainInvocation.java:41)
	at net.hasor.web.render.RenderInvokerFilter.doRenderInvoker(RenderInvokerFilter.java:118)
	at net.hasor.web.render.RenderInvokerFilter.doInvoke(RenderInvokerFilter.java:74)
	at net.hasor.web.binder.FilterDef.doInvoke(FilterDef.java:99)
	at net.hasor.web.invoker.InvokerChainInvocation.doNext(InvokerChainInvocation.java:41)
	at net.hasor.web.invoker.InvokerContext.lambda$genCaller$3(InvokerContext.java:108)
	at net.hasor.web.invoker.InvokerContext.lambda$null$5(InvokerContext.java:118)
	at net.hasor.web.invoker.HttpParameters.preInvoke(HttpParameters.java:50)
	at net.hasor.web.invoker.InvokerContext.lambda$genCaller$6(InvokerContext.java:117)
	at net.hasor.web.startup.RuntimeFilter.doFilter(RuntimeFilter.java:124)
	at net.hasor.web.startup.RuntimeFilter.doFilter(RuntimeFilter.java:113)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.boot.web.servlet.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:126)
	at org.springframework.boot.web.servlet.support.ErrorPageFilter.access$000(ErrorPageFilter.java:64)
	at org.springframework.boot.web.servlet.support.ErrorPageFilter$1.doFilterInternal(ErrorPageFilter.java:101)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
	at org.springframework.boot.web.servlet.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:119)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:544)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:616)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:818)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1626)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)

杭州开云集致科技有限公司/hasor

内容风险标识

net.hasor.db.jdbc.core.JdbcTemplate - java.sql.SQLException: Connection is closed

评论 (1)

杭州开云集致科技有限公司/hasor .gitee-modal { width: 500px !important; }

内容风险标识