Uploaded image for project: 'Syncope'
  1. Syncope
  2. SYNCOPE-375

QUARTZ tables are not written into an innodb mysql DB for an mvn generated and created project

    Details

    • 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
    • Labels:
      None
    • Environment:
      linux fedora 17 Fedora release 17 (Beefy Miracle)
      and
      Mac OSX Mountain lion

      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>

        Attachments

          Activity

            People

            • Assignee:
              ilgrosso Francesco Chicchiriccò
              Reporter:
              ntlartey Nik Tetteh-Lartey
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: