Tip: How to handle custom database schema name while configuring Quartz with Spring Boot

Saturday, October 19, 2019 Labels: daily-tip , Java , Quartz , spring-boot

Plenty of tutorials are there on how to integrate Quartz Scheduler with Spring-Boot. You can also easily find all the SQL scripts on Github. But you might get into difficulty if you have to create these tables in a custom schema, other than the default.

Here goes the tip:

Add this line in the application.properties

spring.quartz.properties.org.quartz.jobStore.tablePrefix=schemaname.QRTZ_

Or

spring.quartz.properties.org.quartz.jobStore.tablePrefix=mySchema.QRTZ_

After, this, Spring Boot would be able to recognize where your Quartz related tables are.

Happy development!