What is the value of the 'quartz.sql' property in your
core/src/main/resources/persistence.properties?
quartz.sql=tables_mysql_innodb.sql
Ok: could you please:
1. drop and create again (or just make empty) your current MySQL database
2. download [1], save it under core/src/main/resources/quartz/ (create
required directories if needed)
3. change "TYPE=InnoDB" to "ENGINE=InnoDB" (or any relevant change
needed to make it work)
4. rebuild and redeploy
5. see if Quartz tables are now created
That works (thanks):
mysql> show tables like 'QRTZ%';
+---------------------------+
| Tables_in_syncope (QRTZ%) |
+---------------------------+
| QRTZ_BLOB_TRIGGERS |
| QRTZ_CALENDARS |
| QRTZ_CRON_TRIGGERS |
| QRTZ_FIRED_TRIGGERS |
| QRTZ_JOB_DETAILS |
| QRTZ_LOCKS |
| QRTZ_PAUSED_TRIGGER_GRPS |
| QRTZ_SCHEDULER_STATE |
| QRTZ_SIMPLE_TRIGGERS |
| QRTZ_SIMPROP_TRIGGERS |
| QRTZ_TRIGGERS |
+---------------------------+
11 rows in set (0.00 sec)
mysql>
