You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@syncope.apache.org by "Hudson (JIRA)" <ji...@apache.org> on 2013/05/29 09:25:19 UTC
[jira] [Commented] (SYNCOPE-375) QUARTZ tables are not written into
an innodb mysql DB for an mvn generated and created project
[ https://issues.apache.org/jira/browse/SYNCOPE-375?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13669060#comment-13669060 ]
Hudson commented on SYNCOPE-375:
--------------------------------
Integrated in Syncope-trunk #225 (See [https://builds.apache.org/job/Syncope-trunk/225/])
[SYNCOPE-375] Merge from 1_1_X (Revision 1487334)
Result = SUCCESS
ilgrosso :
Files :
* /syncope/trunk
* /syncope/trunk/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