[ https://issues.apache.org/jira/browse/SYNCOPE-375?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13669061#comment-13669061 ]
Hudson commented on SYNCOPE-375: -------------------------------- Integrated in Syncope-1_1_X #51 (See [https://builds.apache.org/job/Syncope-1_1_X/51/]) [SYNCOPE-375] Patch applied (changing 'TYPE=InnoDB' into 'ENGINE=InnoDB') (Revision 1487333) Result = SUCCESS ilgrosso : Files : * /syncope/branches/1_1_X/core/src/main/resources/quartz/tables_mysql_innodb.sql > 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.1 > Environment: linux fedora 17 Fedora release 17 (Beefy Miracle) > and > Mac OSX Mountain lion > Reporter: Nik Tetteh-Lartey > Assignee: Francesco Chicchiriccò > Fix For: 1.1.2, 1.2.0 > > Attachments: tables_mysql_innodb.sql > > > 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> -- 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