连接池放弃 . 使用Hibernate的StoreProcedureQuery

遇到连接池问题 . 共享日志：

2017-12-14 13：26：33.858 WARN 27768 --- [：1513143129019]] oatomcat.jdbc.pool.ConnectionPool：连接已被放弃PooledConnection [com.sybase.jdbc4.jdbc.SybConnection@5657736e]：java . org.apache中的org.apache.tomcat.jdbc.pool.ConnectionPool.getThreadDump（ConnectionPool.java:1102）中的orng.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection（ConnectionPool.java:807）中的lang.Exception . tomcat.jdbc.pool.ConnectionPool.borrowConnection（ConnectionPool.java:651）位于org.apache.tomcat.jdbc.pool.DataSourceProxy的org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection（ConnectionPool.java:198） . org.hibernate.internal.AbstractSessionImpl上的org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection（DatasourceConnectionProviderImpl.java:122）中的getConnection（DataSourceProxy.java:132）$ NonContextualJdbcConnectionAccess.obtainConnection（AbstractSessionImpl.java:386）在org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNee ded（LogicalConnectionManagedImpl.java:84）位于org.hibernate.js上的org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.getPhysicalConnection（LogicalConnectionManagedImpl.java:109）中 . （StatementPreparerImpl.java：47） at or.:::::: or or or or or or在org.hibernate.loader.Loader.executeQueryStatement（Loader.java:1903）的org.hibernate.loader.Loader.prepareQueryStatement（Loader.java:1934）的engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement（StatementPreparerImpl.java:148） org.hibernate.loader.Loader.executeQueryStatement（Loader.java:1881）org.hibernate.loader.Loader.doQuery（Loader.java:925）org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections（Loader.java:342） ）org.hiberna org.hibernate.loader.doList（Loader.java:2605）中的or.Hader.Loader.doList（Loader.java:2622）org.hibernate.loader.Loader.listIgnoreQueryCache（Loader.java:2434）atg位于org.hibernate.internal.SessionImpl.listCustomQuery（SessionImpl.java:1980）org.hibernate.loader.custom.CustomLoader.list（CustomLoader.java:336）的.hibernate.loader.Loader.list（Loader.java:2429） ）org.hibernate.internal.Aternal.Inp.:::::: or or or or or or or or or or or or or or or or or or or or or or or or or or or or or or or or or or or or or or or or or or or or or or or or or or or or java：606）atg.hibernate.jpa.internal.QueryImpl.getResultList（QueryImpl.java:483）at sun.reflect.GeneratedMethodAccessor3587.invoke（Unknown Source）at sun.reflect.DelegatingMethodAccessorImpl.invoke（DelegatingMethodAccessorImpl.java:43） at java.lang.reflect.Method.invoke（Method.java:498）at org.springframework.orm.jpa.SharedEntityManagerCreator $ DeferredQueryInvocationHandler.invoke（SharedEntityManagerCreator.java:372）at at com.sun.proxy . $ Proxy1789.getResultList（未知来源）at org . ***** . persistence.repository.impl . *（ RepositoryImpl.java:93）sun.reflect.NativeMethodAccessorImpl.invoke0（Native Method）at sun.reflect.NativeMethodAccessorImpl.invoke（NativeMethodAccessorImpl.java:62）at sun.reflect.DelegatingMethodAccessorImpl.invoke（DelegatingMethodAccessorImpl.java:43）at java位于org.springframework.data.repository.core的org.springframework.data.repository.core.support.RepositoryFactorySupport $ QueryExecutorMethodInterceptor.executeMethodOn（RepositoryFactorySupport.java:504）的.lang.reflect.Method.invoke（Method.java:498） .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）at Org.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上的org.springframework.transaction.intercts.TransactionAspectSupport.invokeWithinTransaction（TransactionAspectSupport.java:282）org.springframework.transaction.interceptor.TransactionInterceptor.invoke（TransactionInterceptor.java:96） . aop.framework.ReflectiveMethodInvocation.proceed（ReflectiveMethodInvocation.java:179）org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke（PersistenceExceptionTranslationInterceptor.java:136）at atorg.springframework.aop.framework.ReflectiveMethodInvocation.proceed（ReflectiveMethodInvocation.java:179）位于org.springframework.aop的org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor $ CrudMethodMetadataPopulatingMethodInterceptor.invoke（CrudMethodMetadataPostProcessor.java:133） . 在org.springframework.aop.frame.RevlectiveMethodInvocation.proceed（ReflectiveMethodInvocation.java:179）的org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke（ExposeInvocationInterceptor.java:92）中的framework.ReflectiveMethodInvocation.proceed（ReflectiveMethodInvocation.java:179）在org.springframework.aop.framework的org.springframework.aop.framework.ReflectiveMethodInvocation.proceed（ReflectiveMethodInvocation.java:179）的org.springframework.data.repository.core.support.SurroundingTransactionDetectorMethodInterceptor.invoke（SurroundingTransactionDetectorMethodInterceptor.java:57） com.sun.proxy上的.JdkDynamicAopProxy.invoke（JdkDynamicAopProxy.java:213） . $ Prox y1749.findConnectionMTRoutingBySmscId（Unknown Source）at sun.reflect.NativeMethodAccessorImpl.invoke0（Native Method）at sun.reflect.NativeMethodAccessorImpl.invoke（NativeMethodAccessorImpl.java:62）at sun.reflect.DelegatingMethodAccessorImpl.invoke（DelegatingMethodAccessorImpl.java:43）at at java.lang.reflect.Method.invoke（Method.java:498）org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection（AopUtils.java:333）at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint（ReflectiveMethodInvocation . 的java：190）在org.springframework.aop.framework.ReflectiveMethodInvocation.proceed（ReflectiveMethodInvocation.java:157）在org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke（ExposeInvocationInterceptor.java:92）在org.springframework.aop.framework .ReflectiveMethodInvocation.proceed（ReflectiveMethodInvocation.java:179）位于com.sun.proxy的org.springframework.aop.framework.JdkDynamicAopProxy.invoke（JdkDynamicAopProxy.java:213） . $ Proxy1749.f ind ****** Id（未知来源）在org . ***** . business.service.impl . ***** ServiceImpl.get （ ServiceImpl.java： 104）at org . ***** . controller . ****** Controller.get （ Controller.java:121）at sun.reflect.NativeMethodAccessorImpl.invoke0（Native Method） ）在sun.reflect.NativeMethodAccessorImpl.invoke（NativeMethodAccessorImpl.java:62）在sun.reflect.DelegatingMethodAccessorImpl.invoke（DelegatingMethodAccessorImpl.java:43）在java.lang.reflect.Method.invoke（Method.java:498）在有机位于org.springframework.web.servlet.mvc的org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest（InvocableHandlerMethod.java:133）中的.springframework.web.method.support.InvocableHandlerMethod.doInvoke（InvocableHandlerMethod.java:205） org.springf上的org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod（RequestMappingHandlerAdapter.java:827）中的.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle（ServletInvocableHandlerMethod.java:97） ramework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal（RequestMappingHandlerAdapter.java:738）在org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle（AbstractHandlerMethodAdapter.java:85）在org.springframework . web.servlet.DispatcherServlet.doDispatch（DispatcherServlet.java:963）在org.springframework.web.servlet.DispatcherServlet.doService（DispatcherServlet.java:897）在org.springframework.web.servlet.FrameworkServlet.processRequest（FrameworkServlet.java： 970）在org.springframework.web.servlet.FrameworkServlet.doGet（FrameworkServlet.java:861）在javax.servlet.http.HttpServlet.service（HttpServlet.java:635）在org.springframework.web.servlet.FrameworkServlet.service （FrameworkServlet.java:846）位于org.apache.catalina的org.apache.catalina.core.ApplicationFilterChain.internalDoFilter（ApplicationFilterChain.java:231）的javax.servlet.http.HttpServlet.service（HttpServlet.java:742） . core.ApplicationFilterChain.doFilter（ApplicationFilte rChain.java:166）atg.apache.tomcat.websocket.server.WsFilter.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.ApplicationContextHeaderFilter.doFilterInternal（ApplicationContextHeaderFilter.java:55）org.springframework.web.filter.OncePerRequestFilter.doFilter（OncePerRequestFilter）的.java：107）在org.apache.catalina.core.ApplicationFilterChain.internalDoFilter（ApplicationFilterChain.java:193）在org.apache.catalina.core.ApplicationFilterChain.doFilter（ApplicationFilterChain.java:166）在org.springframework.web . filter.OncePerRequestFilter.doFilter（OncePerRequestFilter.java:101）org.apache.catalina.core.ApplicationFilterChain.internalDoFilter（ApplicationFilterChain.java:193）org.apache.catalina.core.ApplicationFilterChain.doFilter（ApplicationFilterChain.java:166）在org.apringframe.web.filter.OncePerRequestFilter.doFilter（OncePerRequestFilter.java:101）org.apache.catalina.core.ApplicationFilterChain.internalDoFilter（ApplicationFilterChain.java:193）org.apache.catalina.core.ApplicationFilterChain.doFilter（ ApplicationFilterChain.java:166）在org.apache的org.springframework.wef.filter.OncePerRequestFilter.doFilter（OncePerRequestFilter.java:107）的org.springframework.boot.actuate.trace.WebRequestTraceFilter.doFilterInternal（WebRequestTraceFilter.java:110） .catalina.core.ApplicationFilterChain.internalDoFilter（ApplicationFilterChain.java:193）org.apache.catalina.core.ApplicationFilterChain.doFilter（ApplicationFilterChain.java:166）org.springframework.security.web.FilterChainProxy $ VirtualFilterChain.doFilter（FilterChainProxy） .java：317）在org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doF的org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke（FilterSecurityInterceptor.java:127） ILTER（FilterSecurityInterceptor.java:91）在org.springframework.security.web.FilterChainProxy $ VirtualFilterChain.doFilter（FilterChainProxy.java:331）在org.springframework.security.web.access.ExceptionTranslationFilter.doFilter（ExceptionTranslationFilter.java:114）在org.springframework.security.web.FilterChainProxy $ VirtualFilterChain.doFilter（FilterChainProxy.java:331）在org.springframework.security.web.session.SessionManagementFilter.doFilter（SessionManagementFilter.java:137）在org.springframework.security.web在org.springframework.security.web.FilterChainProxy $ VirtualFilterChain.doFilter（FilterChainProxy）的org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter（AnonymousAuthenticationFilter.java:111）上的.FilterChainProxy $ VirtualFilterChain.doFilter（FilterChainProxy.java:331） .java：331）在org.springframework.s的org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter（SecurityContextHolderAwareRequestFilter.java:170） ecurity.web.FilterChainProxy $ VirtualFilterChain.doFilter（FilterChainProxy.java:331）org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter（RequestCacheAwareFilter.java:63）at org.springframework.security.web.FilterChainProxy $ VirtualFilterChain . 的doFilter（FilterChainProxy.java:331）在有机 . security.filter.JwtAuthenticationTokenFilter.doFilterInternal（JwtAuthenticationTokenFilter.java:94）在org.springframework.web.filter.OncePerRequestFilter.doFilter（OncePerRequestFilter.java:107）在org.springframework.security.web.FilterChainProxy $ VirtualFilterChain.doFilter（FilterChainProxy.java:331）在org.springframework.security.web.authentication.logout.LogoutFilter.doFilter（LogoutFilter.java:116）在org.springframework.security org.springframework.web.filter.OncePerRequestFilter.doFi上的org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal（HeaderWriterFilter.java:64）中的.web.FilterChainProxy $ VirtualFilterChain.doFilter（FilterChainProxy.java:331） lter（OncePerRequestFilter.java:107）org.springframework.security.web.FilterChainProxy $ VirtualFilterChain.doFilter（FilterChainProxy.java:331）org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter（SecurityContextPersistenceFilter.java:105）在Org.springframework的org.springframework.security.web.FilterChainProxy $ VirtualFilterChain.doFilter（FilterChainProxy.java:331）org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal（WebAsyncManagerIntegrationFilter.java:56） .gb.filter.OncePerRequestFilter.doFilter（OncePerRequestFilter.java:107）org.springframework.security.web.FilterChainProxy $ VirtualFilterChain.doFilter（FilterChainProxy.java:331）org.springframework.web.filter.OncePerRequestFilter.doFilter（OncePerRequestFilter） .java：101）org.springframework.security.web.FilterChainProxy $ VirtualFilterChain.doFilter（FilterChainProxy.java:331）org.springframework.web.filter.CorsFilter.doFilterInternal（C） orsFilter.java:96）在org.springframework.web.filter.OncePerRequestFilter.doFilter（OncePerRequestFilter.java:107）在org.springframework.security.web.FilterChainProxy $ VirtualFilterChain.doFilter（FilterChainProxy.java:331）在org.springframework位于org.springframework.security.web.FilterChainProxy.doFilter（FilterChainProxy.java:177）的.security.web.FilterChainProxy.doFilterInternal（FilterChainProxy.java:214）org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate（DelegatingFilterProxy.java） ：346）在org.springframework.web.filter.DelegatingFilterProxy.doFilter（DelegatingFilterProxy.java:262）在org.apache.catalina.core.ApplicationFilterChain.internalDoFilter（ApplicationFilterChain.java:193）在org.apache.catalina.core . ApplicationFilterChain.doFilter（ApplicationFilterChain.java:166）位于org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal（CharacterEncodingFilter.java:197）at atorg.apringframework.web.filter.OncePerRequestFilter.doFilter（OncePerRequestFilter.java:107）org.apache.catalina.core.ApplicationFilterChain.internalDoFilter（ApplicationFilterChain.java:193）org.apache.catalina.core.ApplicationFilterChain.doFilter（ ApplicationFilterChain.java:166）位于org.apache的org.springframework.wef.filter.OncePerRequestFilter.doFilter（OncePerRequestFilter.java:107）的org.springframework.boot.actuate.autoconfigure.MetricsFilter.doFilterInternal（MetricsFilter.java:106） .catalina.core.ApplicationFilterChain.internalDoFilter（ApplicationFilterChain.java:193）org.apache.catalina.core.ApplicationFilterChain.doFilter（ApplicationFilterChain.java:166）org.springframework.boot.web.support.ErrorPageFilter.doFilter（ErrorPageFilter） .java：115）org.springframework.boot.web.support.ErrorPageFilter.access $ 000（ErrorPageFilter.java:59）at org.springframework.boot.web.support.ErrorPageFilter $ 1.doFilterInternal（ErrorPageFilter.java:90）at at org.springframework.web.filter.Onc egerRequestFilter.doFilter（OncePerRequestFilter.java:107）org.apringframework.boot.web.support.ErrorPageFilter.doFilter（ErrorPageFilter.java:108）org.apache.catalina.core.ApplicationFilterChain.internalDoFilter（ApplicationFilterChain.java:193） org.apache.catalina.core.ApplicationFilterChain.doFilter（ApplicationFilterChain.java:166）org.apache.catalina.core.StandardWrapperValve.invoke（StandardWrapperValve.java:198）org.apache.catalina.core.StandardContextValve.invoke （StandardContextValve.java:96）位于org.apache的org.apache.catalina.authenticator.AuthenticatorBase.invoke（AuthenticatorBase.java:478）org.apache.catalina.core.StandardHostValve.invoke（StandardHostValve.java:140） . 位于org.apache.catalina.valve.AbstractAccessLogValve.invoke（AbstractAccessLogValve.java:624）的catalina.valves.ErrorReportValve.invoke（ErrorReportValve.java:80）org.apache.catalina.core.StandardEngineValve.invoke（StandardEngineValve.java： 87）at org.apache.catalina.connector.CoyoteAdapter.service（C oyoteAdapter.java:342）org.apache.coyote.http11.Http11Processor.service（Http11Processor.java:799）org.apache.coyote.AbstractProcessorLight.process（AbstractProcessorLight.java:66）at org.apache.coyote.AbstractProtocol位于org.apache.tomcat.util.net.NioEndpoint $ SocketProcessor.doRun（NioEndpoint.java:1455）的$ ConnectionHandler.process（AbstractProtocol.java:861）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:748）