今天遇到一个小问题,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>
希望能帮到有缘人!