因为quartz引用了log4jdbc的datasource，导致项目启动后控制台频繁刷屏

因为quartz引用了log4jdbc的datasource，导致项目启动后控制台频繁刷屏

2018-11-23 21:22:36.705  INFO 11951 --- [_ClusterManager] jdbc.sqlonly                             : SELECT * FROM QRTZ_SCHEDULER_STATE WHERE SCHED_NAME = 'mng-scheduler' 

[default INFO ] 20181123-21:22:36.705 jdbc.sqlonly - SELECT * FROM QRTZ_SCHEDULER_STATE WHERE SCHED_NAME = 'mng-scheduler' 

2018-11-23 21:22:36.717  INFO 11951 --- [_ClusterManager] jdbc.sqlonly                             : UPDATE QRTZ_SCHEDULER_STATE SET LAST_CHECKIN_TIME = 1542979356717 WHERE SCHED_NAME = 'mng-scheduler' 
AND INSTANCE_NAME = 'bogon1542979114472' 

[default INFO ] 20181123-21:22:36.717 jdbc.sqlonly - UPDATE QRTZ_SCHEDULER_STATE SET LAST_CHECKIN_TIME = 1542979356717 WHERE SCHED_NAME = 'mng-scheduler' 
AND INSTANCE_NAME = 'bogon1542979114472' 

2018-11-23 21:22:56.722  INFO 11951 --- [_ClusterManager] jdbc.sqlonly                             : select 123 

[default INFO ] 20181123-21:22:56.722 jdbc.sqlonly - select 123 

2018-11-23 21:22:56.751  INFO 11951 --- [_ClusterManager] jdbc.sqlonly                             : SELECT * FROM QRTZ_SCHEDULER_STATE WHERE SCHED_NAME = 'mng-scheduler' 

[default INFO ] 20181123-21:22:56.751 jdbc.sqlonly - SELECT * FROM QRTZ_SCHEDULER_STATE WHERE SCHED_NAME = 'mng-scheduler' 

2018-11-23 21:22:56.765  INFO 11951 --- [_ClusterManager] jdbc.sqlonly                             : UPDATE QRTZ_SCHEDULER_STATE SET LAST_CHECKIN_TIME = 1542979376764 WHERE SCHED_NAME = 'mng-scheduler' 
AND INSTANCE_NAME = 'bogon1542979114472' 

解决方案

在application.yml添加

# quartz
---
sys:
  quartz:
    thread-pool:
      thread-name-prefix: XbdThreadPoolTaskExecutor-
      thread-priority: 5
      daemon: false
      thread-group-name: XbdThreadPoolTaskExecutorGroup
      core-pool-size: 20
      max-pool-size: 50
      keep-alive-seconds: 60
      queue-capacity: 100
      allow-core-thread-timeout: false
      waitfor-tasks-tocomplete-onshutdown: false
      await-termination-seconds: 900
    scheduler:
      scheduler-name: mng-scheduler
      application-context-scheduler-contextkey: applicationContext
      overwrite-existing-jobs: true
      auto-startup: true
      startup-delay: 10

在application-dev.yml添加

sys:
  quartz:
    scheduler:
      config-location: classpath:config/quartz/quartz-dev.properties

里面配置不同环境的数据库配置