今天遇到一个小问题，springboot2+mybatisplus集成activiti后，控制台不停地输出：
Opening JDBC Connection
==> Preparing: SELECT SUB.* FROM ( select RES.* , row_number() over (ORDER BY RES.ID_ asc) rnk FROM ( select distinct RES.* from ACT_RU_JOB RES LEFT OUTER JOIN ACT_RU_EXECUTION PI ON PI.ID_ = RES.PROCESS_INSTANCE_ID_ where (RES.RETRIES_ > 0) and (RES.DUEDATE_ is null or RES.DUEDATE_ <= ?) and (RES.LOCK_OWNER_ is null or RES.LOCK_EXP_TIME_ <= ?) and TYPE_ = 'timer' and ( (RES.EXECUTION_ID_ is null) or (PI.SUSPENSION_STATE_ = 1) ) )RES ) SUB WHERE SUB.rnk >= ? AND SUB.rnk < ?
==> Parameters: 2022-01-23 15:41:48.99(Timestamp), 2022-01-23 15:41:48.99(Timestamp), 1(Integer), 2(Integer)
<== Total: 0
Closing JDBC Connection [Transaction-aware proxy for target Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@bc6be32]]

本人解决步骤如下：

1、注释红色字体。即mybatis-plus自带的日志打印。（如果只是不想看到activiti日志，这个跳过）

mybatis-plus:
  mapper-locations: classpath:mapper/**/*.xml
  type-aliases-package: com.lj.services.**.entity
  configuration:
#    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
    map-underscore-to-camel-case: false
    database-id: sqlserver
    cache-enabled: false

2、再加上这句

        spring.activiti.async-executor-activate=false

3、log4j2的配置文件中加入如下配置：

<Logger name="com.lj.services" level="debug" additivity="false">
    <appender-ref ref="CONSOLE" />
</Logger>

希望能帮到有缘人！