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

Saturday, October 19, 2019 Labels: , , ,

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!

0 comments :

Post a Comment

 
Waqas Sadiq © 2014