Соединение с пулом прекращено. Использование StoreProcedureQuery в Hibernate

Question

Застрял с проблемами пула соединений. Поделиться журналом:

2017-12-14 13: 26: 33.858 WARN 27768 --- [: 1513143129019]] oatomcat.jdbc.pool.ConnectionPool: Соединение разорвано PooledConnection[com.sybase.jdbc4.jdbc.SybConnection@5657736e]:java.lang.Exception в org.apache.tomcat.jdbc.pool.ConnectionPool.getThreadDump(ConnectionPool.java:1102) в org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:807) в org.apache.tom.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:651) в org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(ConnectionPool.java:198) в org.apache.tomcat.jdbc.pool.DataSourceProxy.get (DataSourceProxy.java:132) в org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:122) в org.hibernate.internal.AbstractSessionImplJ.ConnectSessionIconnect org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:84) по адресу org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.getPhysicalConnection(LogicalConnectionManagedImpl.java:109) по адресу org.hibernate.engine.jdbc.lava.jIII_Imp_Rj.Rare.Rec () в org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:146) в org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreperationTemplate.prepareStater2.lp. engine.jdbc.internal. в org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1881) в org.hibernate.loader.Loader.doQuery(Loader.java:925) в org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCol) в org.hibernate.loader.Loader.doList(Loader.java:2622) в org.hibernate.loader.Loader.doList(Loader.java:2605) в org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2434) в орг.hibernate.loader.Loader.list(Loader.java:2429) в org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:336) в org.hibernate.internal.SessionImpl.listCustomQuery(SessionImpl.java:1980) в org.hibernate.internal.AbstractSessionImpl.list(AbstractSessionImpl.java:322) в org.hibernate.internal.SQLQueryImpl.list(SQLQueryImpl.java:125) в org.hibernate.jpa.internal.QueryImpl.l. (запрос:606) в org.hibernate.jpa.internal.QueryImpl.getResultList(QueryImpl.java:483) в sun.reflect.GeneratedMethodAccessor3587.invoke(Неизвестный источник) в sun.reflect.DelegatingMethoccessAccessorImpl.etj (at). java.lang.reflect.Method.invoke(Method.java:498) в org.springframework.orm.jpa.SharedEntityManagerCreator$DeferredQueryInvocationHandler.invoke(SharedEntityManagerCreator.java:372) в com.sun.proxy.$Proxy1789.getResultList(Неизвестный источник) в орг.*****.persistence.repository.impl.************(********RepositoryImpl.java:93) в sun.reflect.NativeMethodAccessorImpl.invoke0(родной метод) в sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) в sun.reflect.DelegatingImphoid.lang.reflect.Method..support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.doInvoke(RepositoryFactorySupport.java:479) в org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:461) в org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) в или g.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:61) в org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) в org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99) в org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282) в org.springframework.transaction.interceptor.TransactionInterceptor. aop.framework.ReflectiveMethodInvocation.proceed (ReflectiveMethodInvocation.java:179) в org.springframework.dao.support. 179) в org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:133) в org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) в org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) в org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) в org.springframework.data.repository.core.support.Surrounding.aop.framework. sun.reflect.NativeMethodAccessorImpl.invoke0(собственный метод) в sun.reflect.NativeMethodAcc essorImpl.invoke (NativeMethodAccessorImpl.java:62) в sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) в java.lang.reflect.Method.invoke (метод) atra.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333) в org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) (рабочая точка org.springframework.aop.interceptor.JdkDynamicAopProxy.java:213) на com.sun.proxy.$Proxy1749.find******Id(неизвестный источник) на орг. *****. Business.service.impl.*****ServiceImpl. получить *****(*****ServiceImpl.java:104) в орг. *****. контроллер.******Controller.get******(****Controller.java:121) на sun.reflect.NativeMethodAccessorImpl.invoke0(собственный метод) на sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) на солнце. отражать. по адресу org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133) по адресу org.springframework.web.servlet.mvc.method.annotation.Serv.WeHHWHD.web.servlet.mvc.method.annotation. k.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85) в org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:963).serg.doService(DispatcherServlet.java:897) в org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970) в org.springframework.web.servlet.FrameworkServlet.doGet) в java (факс).http.HttpServlet.service(HttpServlet.java:635) в org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) в javax.servlet.http.HttpServlet.service: atvp) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) в org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) в org.apweso.cket.doFilter(WsFilter.java:52) в org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) по адресу org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) по адресу org.springframework.boot.web.filter.ApplicationContextHeaderFile.terf.Filter.Filter.File.springframework.web.filter.OncePerRequestFilter..java: 166) по адресу org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:101) по адресу org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (ApplicationFilterCapina.cat). org.cat. core.ApplicationFilterChain.doFilter (ApplicationFilterChain.java:166) в org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:101) в org.apache.catalina.cilDoFin.in ilter (ApplicationFilterChain.java:193) в org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) в org.springframework.boot.actuate.trace.WebRequestTraceFilter.avaFilter.jFF).springframework.web.filter.OncePerRequestFilter..java: 166) в org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317) в org.springframework.security.web.access.intercept.FilterSecurityInterceptor.jvv org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter (FilterSecurityInterceptor.java:91) в org.springframework.security.web.FilterChainProxy $ VirtualFilterChain.doFilter (FilterjhainPro33.) g.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114) в org.springframework.security.web.FilterChainProxy $ VirtualFilterChain. сеанс Java: 111) в org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) в org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestavaFraser.File.File.File.File.File.File.File.Ru.security.web.FilterChainProxy $ VirtualFilterChain.doFilter (FilterChainProxy.java:331) в org.springframework.security.web.savedrequest.RequestCacheAwareFilt er.doFilter (RequestCacheAwareFilter.java:63) в org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) в орг.*****.security.filter.JwtAuthenticationTokFilter java:94) в org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) в org.springframework.security.web.FilterChainProxy $ VirtualFilterChain.doFilter.prj.jpg: в классе FilterChag.web.authentication.logout.LogoutFilter..doFilterInternal (HeaderWriterFilter.java:64) по адресу org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) по адресу org.springframework.security.web.FilterChainFhainFactoryFacterChainProxy $:. org.spr ingframework.security.web.context.SecurityContextPersistenceFilter.doFilter (SecurityContextPersistenceFilter.java:105) в org.springframework.security.web.FilterChainProxy $ VirtualFilterChain.doFilter (FilterChag.Secine.Fe.in.fee.pr. request.async.WebAsyncManagerIntegrationFilter.doFilterInternal (WebAsyncManagerIntegrationFilter.java:56) по адресу org.springframework.web.filter.OncePerRequestFilter.doFilter (OncePerRequestFilter.java:ilProhaha.FirFFFFFFF.CrF_Cr_F_Cr_F_C_C_W_C_F_C_F_C_C_W_C_F_C_F_C_W_C_F_C_F_C_C_F_C_F_C_F_C_A__A__A__A__A__A__A_P_C_C_2_2__A_P_C_2_2_2_ru_P_C_F_2_02_2_ПОЛЬЗОВАТЬСЯ ПОЛЬЗОВАТЬСЯ НА СВЯЗИ С ФИЛЬМ "ЗАКАЗАТЬ" java: 331) по адресу org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:101) по адресу org.springframework.security.web.FilterChainProxy $ VirtualFilterChain.doFilter.web.rag:.filter.CorsFilter.doFilterInternal (CorsFilter.java:96) в org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) в org.springframework.security.web. erChainProxy $ VirtualFilterChain.doFilter (FilterChainProxy.java:331) в org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214) в org.springframework.secil.Proj.Proha.Fin.Fin.Fine.Fin.Fine.Fin.Fine.Fin.Fine.Fin.Fine.Fin.Fine.Fin.Fine.Fine.Fin.Fine.Fin.FF по адресу org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) по адресу org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:26apil.Fina.FF.in.FF). (ApplicationFilterChain.java:193) в org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) в org.springframework.web.filter.CharacterEncodingFilter.doFilterIntern.Fine.Fine.Fine.InF. web.filter.OncePerRequestFilter.doFilter (OncePerRequestFilter.java:107) в org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (ApplicationFilterChain.java:193) в org.apache.catalina.Fter. ain.doFilter (ApplicationFilterChain.java:166) в org.springframework.boot.actuate.autoconfigure.MetricsFilter.doFilterInternal(MetricsFilter.java:106) в org.springframework.web.filter.OncePerReFF в org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (ApplicationFilterChain.java:193) в org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) в org.spring.web.doFilter(ErrorPageFilter.java:115) в org.springframework.boot.web.support.ErrorPageFilter.access$000(ErrorPageFilter.java:59) в org.springframework.boot.web.support.ErrorPageFilFirter$ (:90) по адресу org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) по адресу org.springframework.boot.web.support.ErrorPageFilter.doFilter(ErrorPageFilache. at. core.ApplicationFilterChain.internalDoFilter (ApplicationFilterChain. Java: 193) в org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) в org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:19core) в org..StandardContextValve.invoke(StandardContextValve.java:96) в org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478) в org.apache.catalina.core.StandardHostValve.Valve.Valve.Inveke org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80) в org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624) в org.apache.catalina.veketacore StandardEngineValve.java:87) в org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) в org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:799) в org.ap.AbstractProcessorLight.process(AbstractProcessorLight.java:66) в org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:861) в org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455) в org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) в java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) в java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) в org.apache.thomcat.org.TaskThread$WrappingRunnable.run(TaskThread.java:61) в java.lang.Thread.run(Thread.java:748)