[SYNCOPE-375] QUARTZ tables are not written into an innodb mysql DB for an mvn generated and created project

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.1.1
• Fix Version/s: 1.1.2, 1.2.0-M1
• Component/s: core
• Environment: linux fedora 17 Fedora release 17 (Beefy Miracle); and; Mac OSX Mountain lion
• Assignee: Francesco Chicchiriccò
• Reporter: Nik Tetteh-Lartey
• Created: 28/May/13 15:32
• Updated: 11/Jun/13 10:48
• Resolved: 29/May/13 06:54

Description

building a snapshot 1.1.2 project (as per the wiki) and deploying the war file on a glassfish container using
a mysql DB as persistant storage (re: wiki) results in a target DB being built without any of the QUARTZ tables used by syncope idm.

WORK AROUND:
1. drop and create syncope db again (or just make empty) with current MySQL database
2. download attached file, save it under core/src/main/resources/quartz/ (create required path)
3. rebuild and redeploy
4. verify Quartz tables are now created as follows:
bash-4.1# mysql -uroot -pwelcome syncope -A
:
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>