Nik Tetteh-Lartey created SYNCOPE-375:
-----------------------------------------
Summary: QUARTZ tables are not written into an innodb mysql DB for
an mvn generated and created project
Key: SYNCOPE-375
URL: https://issues.apache.org/jira/browse/SYNCOPE-375
Project: Syncope
Issue Type: Bug
Components: core
Affects Versions: 1.1.2
Environment: linux fedora 17 Fedora release 17 (Beefy Miracle)
and
Mac OSX Mountain lion
Reporter: Nik Tetteh-Lartey
Priority: Blocker
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
with any of the QUARTZ tables used by syncope idm.
WORK AROUND:
1. drop and create again (or just make empty) with current MySQL database
2. download attached file, save it under core/src/main/resources/quartz/
(create required paths required)
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>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
