这是生产环境 对于连接池什么都没有配置 默认HiKari连接池 

    1. #region Spring config
    2. spring:
    3.   application:
    4.     name: org-ex-mng-wf-ms
    5.   datasource:
    6.     driverClassName: com.mysql.jdbc.Driver
    7.     username: xxx
    8.     password: '%xxxxx#KXiUAJa'
    9.     url: jdbc:mysql://mysqlxxxxx.prd.db:3310/xxxxxxxx?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true&useSSL=false&allowPublicKeyRetrieval=true

    hikariCP 连接池配置

    1. [ERROR] [2022-05-30 10:58:57,924] [cn.com.yto56.basic.framework.rest.monitor.GlobalExceptionHandler] [XNIO-1 task-12] [10.7.72.93] [3ddb099f-23c3-4c03-8c54-e045719f6875] [] url:/workflow/processTaskHandler/doAction, case:Could not open J
    2. DBC Connection for transaction; nested exception is java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30000ms.
    3. org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out
    4.  after 30000ms.
    5.         at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:305)
    6.         at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:378)
    7.         at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:137)
    8.         at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:45)
    9.         at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:29)
    10.         at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:44)
    11.         at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:39)
    12.         at org.activiti.engine.impl.ManagementServiceImpl.executeCustomSql(ManagementServiceImpl.java:197)
    13.         at cn.com.yto56.basic.framework.wf.impl.process.ProcessTaskServiceImpl.queryUnFinishTask(ProcessTaskServiceImpl.java:54)
    14.         at cn.com.yto56.basic.framework.wf.impl.handler.ProcessTaskHandler.execute(ProcessTaskHandler.java:38)
    15.         at cn.com.yto56.basic.framework.wf.impl.handler.ProcessTaskHandler.execute(ProcessTaskHandler.java:17)
    16.         at cn.com.yto56.basic.framework.base.handler.BaseWfHandler.execute(BaseWfHandler.java:78)
    17.         at cn.com.yto56.basic.framework.wf.rest.WorkflowHandlerController.doAction(WorkflowHandlerController.java:46)
    18.         at cn.com.yto56.basic.framework.wf.rest.WorkflowHandlerController$$FastClassBySpringCGLIB$$31b15853.invoke(<generated>)
    19.         at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
    20.         at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:749)
    21.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
    22.         at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:93)
    23.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
    24.         at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:88)
    25.         at cn.com.yto56.basic.framework.rest.signature.SourceMapAspect.around(SourceMapAspect.java:83)
    26.         at sun.reflect.GeneratedMethodAccessor190.invoke(Unknown Source)
    27.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    28.         at java.lang.reflect.Method.invoke(Method.java:498)
    29.         at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:644)
    30.         at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:633)
    31.         at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)
    32.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175)
    33.         at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
    34.         at cn.com.yto56.basic.framework.wf.rest.WorkflowHandlerController$$EnhancerBySpringCGLIB$$2a996ec3.doAction(<generated>)
    35.         at sun.reflect.GeneratedMethodAccessor198.invoke(Unknown Source)
    36.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    37.         at java.lang.reflect.Method.invoke(Method.java:498)
    38.         at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:189)
    39.         at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
    40.         at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102)
    41.         at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
    42.         at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800)
    43.         at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
    44.         at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038)
    45.         at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942)
    46.         at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005)
    47.         at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:908)
    48.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:665)
    49.         at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882)
    50.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:750)
    51.         at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
    52.         at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
    53.         at org.springframework.boot.actuate.web.trace.servlet.HttpTraceFilter.doFilterInternal(HttpTraceFilter.java:90)
    54.         at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    55.         at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
    56.         at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
    57.         at cn.com.yto56.basic.framework.plugin.cat.remote.CatCrossFilter.doFilter(CatCrossFilter.java:83)
    58.         at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
    59.         at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
    60.          ........
    61.     Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30000ms.
    62.         at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:676)
    63.         at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:190)
    64.         at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:155)
    65.         at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
    66.         at com.zaxxer.hikari.HikariDataSource$$FastClassBySpringCGLIB$$eeb1ae86.invoke(<generated>)
    67.         at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
    68.         at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:749)
    69.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
    70.         at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:136)
    71.         at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:124)
    72.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
    73.         at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
    74.         at com.zaxxer.hikari.HikariDataSource$$EnhancerBySpringCGLIB$$948ca078.getConnection(<generated>)
    75.         at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:262)