spring-boot-data-source-decorator
spring-boot-data-source-decorator copied to clipboard
Published
20 hours ago •
gavlyukovskiy
gavlyukovskiy
Integrate with Quartz to output empty SQL
ENV
jdk21 和Springboot 3.4.5
dependencies
<dependency>
<groupId>com.github.gavlyukovskiy</groupId>
<artifactId>p6spy-spring-boot-starter</artifactId>
<version>1.11.0</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-quartz</artifactId>
<version>3.4.5</version>
</dependency>
application.yaml
decorator:
datasource:
p6spy:
enable-logging: true
log-format: "[executionTime]:%(executionTime) ms [sql]:%(sqlSingleLine)\n"
log-filter:
pattern: ^(?!.*(QRTZ_|\[sql\]:\s*$)).+$
spring:
quartz:
auto-startup: true
scheduler-name: schedulerName
job-store-type: jdbc
wait-for-jobs-to-complete-on-shutdown: true
properties:
org:
quartz:
scheduler:
instanceName: schedulerName
instanceId: AUTO
jobStore:
class: org.springframework.scheduling.quartz.LocalDataSourceJobStore
isClustered: true
clusterCheckinInterval: 1800000
misfireThreshold: 1800000
threadPool:
threadCount: 2
threadPriority: 5
class: org.quartz.simpl.SimpleThreadPool
jdbc:
initialize-schema: NEVER
console
2025-06-25 16:42:51.844 | INFO 59304 | schedulerName_QuartzSchedulerThread [TID: N/A] p6spy | [executionTime]:0 ms [sql]:
2025-06-25 16:43:16.713 | INFO 59304 | schedulerName_QuartzSchedulerThread [TID: N/A] p6spy | [executionTime]:0 ms [sql]:
2025-06-25 16:43:40.213 | INFO 59304 | schedulerName_QuartzSchedulerThread [TID: N/A] p6spy | [executionTime]:0 ms [sql]:
2025-06-25 16:44:05.266 | INFO 59304 | schedulerName_QuartzSchedulerThread [TID: N/A] p6spy | [executionTime]:0 ms [sql]:
2025-06-25 16:44:31.757 | INFO 59304 | schedulerName_QuartzSchedulerThread [TID: N/A] p6spy | [executionTime]:0 ms [sql]:
2025-06-25 16:44:56.495 | INFO 59304 | schedulerName_QuartzSchedulerThread [TID: N/A] p6spy | [executionTime]:1 ms [sql]:
2025-06-25 16:45:20.436 | INFO 59304 | schedulerName_QuartzSchedulerThread [TID: N/A] p6spy | [executionTime]:0 ms [sql]:
2025-06-25 16:45:46.401 | INFO 59304 | schedulerName_QuartzSchedulerThread [TID: N/A] p6spy | [executionTime]:5 ms [sql]:
2025-06-25 16:46:13.344 | INFO 59304 | schedulerName_QuartzSchedulerThread [TID: N/A] p6spy | [executionTime]:0 ms [sql]:
2025-06-25 16:46:41.241 | INFO 59304 | schedulerName_QuartzSchedulerThread [TID: N/A] p6spy | [executionTime]:0 ms [sql]:
2025-06-25 16:47:08.273 | INFO 59304 | schedulerName_QuartzSchedulerThread [TID: N/A] p6spy | [executionTime]:0 ms [sql]:
2025-06-25 16:47:32.997 | INFO 59304 | schedulerName_QuartzSchedulerThread [TID: N/A] p6spy | [executionTime]:0 ms [sql]:
expectation
Do not output empty SQL !!!
