[jira] [Resolved] (GRIFFIN-231) Database initialisation fails on Postgresql

["William Guo (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/GRIFFIN-231?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

William Guo resolved GRIFFIN-231.
---------------------------------
    Resolution: Fixed

> Database initialisation fails on Postgresql
> -------------------------------------------
>
>                 Key: GRIFFIN-231
>                 URL: https://issues.apache.org/jira/browse/GRIFFIN-231
>             Project: Griffin (Incubating)
>          Issue Type: Bug
>    Affects Versions: 0.5.0
>            Reporter: Dimitris Stafylarakis
>            Priority: Minor
>          Time Spent: 20m
>  Remaining Estimate: 0h
>
> The script service/src/main/resources/Init_quartz_postgres.sql contains the following statements that lead to an exception (table does not exist)
> {code:java}
> // code SQL
> drop table qrtz_fired_triggers;
> DROP TABLE QRTZ_PAUSED_TRIGGER_GRPS;
> DROP TABLE QRTZ_SCHEDULER_STATE;
> DROP TABLE QRTZ_LOCKS;
> drop table qrtz_simple_triggers;
> drop table qrtz_cron_triggers;
> drop table qrtz_simprop_triggers;
> DROP TABLE QRTZ_BLOB_TRIGGERS;
> drop table qrtz_triggers;
> drop table qrtz_job_details;
> drop table qrtz_calendars;
> {code}
> Other platforms (e.g., mysql) use the DROP TABLE IF EXISTS statement instead. The postgres variant should use this as well.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)