Change in scheduling db quartz.properties

Hello Team,

Hi. I’m trying to start Helical Insight in docker. You use quartz library, looks like I need to setup DB for it. Can I use MySQL for that? What configuration (quartz.properties) should look like?

Thank You
Tarun.

1 Like

Hello Tarun,

From version 4.0 onwards we have saving scheduling related information in db. Yes it is possible to migrate from derby to some other db.

Steps to Migrate Quarz DB to MySQL :

  1. Create some empty database into MySQL DB server. Let us say i have created db “scheduler”

  2. Dump the data from this file into newly created “scheduler” DB : https://github.com/elventear/quartz-scheduler/blob/master/distribution/src/main/assembly/root/docs/dbTables/tables_mysql.sql

  3. Change the credentials of “quartz.properties” file located at “…hi\apache-tomcat-9\webapps\hi-ee\WEB-INF\classes” to configure the db server and driver details of “scheduler” db
    image

  4. Save the file and close it

  5. Restart Helical Insight service

Thank You
From Team Helical