Repository: airavata Updated Branches: refs/heads/master 4ee4b1a1e -> 9ee0df7c1
Changing the reason field in status table to CLOB(derby) and LONGTEXT(mysql) Project: http://git-wip-us.apache.org/repos/asf/airavata/repo Commit: http://git-wip-us.apache.org/repos/asf/airavata/commit/c6cfa329 Tree: http://git-wip-us.apache.org/repos/asf/airavata/tree/c6cfa329 Diff: http://git-wip-us.apache.org/repos/asf/airavata/diff/c6cfa329 Branch: refs/heads/master Commit: c6cfa329000572b76335e0a23762f12d32cbb006 Parents: 0a90a40 Author: Supun Nakandala <[email protected]> Authored: Mon Jun 22 20:42:52 2015 +0530 Committer: Supun Nakandala <[email protected]> Committed: Mon Jun 22 20:42:52 2015 +0530 ---------------------------------------------------------------------- .../core/experiment/catalog/model/ExperimentStatus.java | 1 + .../registry/core/experiment/catalog/model/ProcessStatus.java | 1 + .../registry/core/experiment/catalog/model/TaskStatus.java | 1 + .../registry-core/src/main/resources/expcatalog-derby.sql | 6 +++--- .../registry-core/src/main/resources/expcatalog-mysql.sql | 6 +++--- .../registry-core/src/test/resources/expcatalog-derby.sql | 6 +++--- 6 files changed, 12 insertions(+), 9 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/airavata/blob/c6cfa329/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/ExperimentStatus.java ---------------------------------------------------------------------- diff --git a/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/ExperimentStatus.java b/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/ExperimentStatus.java index 7e892f0..0ccd5b0 100644 --- a/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/ExperimentStatus.java +++ b/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/ExperimentStatus.java @@ -79,6 +79,7 @@ public class ExperimentStatus { } @Basic + @Lob @Column(name = "REASON") public String getReason() { return reason; http://git-wip-us.apache.org/repos/asf/airavata/blob/c6cfa329/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/ProcessStatus.java ---------------------------------------------------------------------- diff --git a/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/ProcessStatus.java b/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/ProcessStatus.java index c727953..b816df2 100644 --- a/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/ProcessStatus.java +++ b/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/ProcessStatus.java @@ -80,6 +80,7 @@ public class ProcessStatus { } @Basic + @Lob @Column(name = "REASON") public String getReason() { return reason; http://git-wip-us.apache.org/repos/asf/airavata/blob/c6cfa329/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/TaskStatus.java ---------------------------------------------------------------------- diff --git a/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/TaskStatus.java b/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/TaskStatus.java index 1e08a43..544e29e 100644 --- a/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/TaskStatus.java +++ b/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/TaskStatus.java @@ -79,6 +79,7 @@ public class TaskStatus { } @Basic + @Lob @Column(name = "REASON") public String getReason() { return reason; http://git-wip-us.apache.org/repos/asf/airavata/blob/c6cfa329/modules/registry/registry-core/src/main/resources/expcatalog-derby.sql ---------------------------------------------------------------------- diff --git a/modules/registry/registry-core/src/main/resources/expcatalog-derby.sql b/modules/registry/registry-core/src/main/resources/expcatalog-derby.sql index 3156aa2..f776e25 100644 --- a/modules/registry/registry-core/src/main/resources/expcatalog-derby.sql +++ b/modules/registry/registry-core/src/main/resources/expcatalog-derby.sql @@ -123,7 +123,7 @@ CREATE TABLE EXPERIMENT_STATUS ( EXPERIMENT_ID varchar(255), STATE varchar(255), TIME_OF_STATE_CHANGE timestamp DEFAULT '0000-00-00 00:00:00', - REASON varchar(255), + REASON CLOB, PRIMARY KEY (STATUS_ID, EXPERIMENT_ID), FOREIGN KEY (EXPERIMENT_ID) REFERENCES EXPERIMENT(EXPERIMENT_ID) ON DELETE CASCADE ); @@ -225,7 +225,7 @@ CREATE TABLE PROCESS_STATUS ( PROCESS_ID varchar(255), STATE varchar(255), TIME_OF_STATE_CHANGE timestamp DEFAULT '0000-00-00 00:00:00', - REASON varchar(255), + REASON CLOB, PRIMARY KEY (STATUS_ID, PROCESS_ID), FOREIGN KEY (PROCESS_ID) REFERENCES PROCESS(PROCESS_ID) ON DELETE CASCADE ); @@ -273,7 +273,7 @@ CREATE TABLE TASK_STATUS ( TASK_ID varchar(255), STATE varchar(255), TIME_OF_STATE_CHANGE timestamp DEFAULT '0000-00-00 00:00:00', - REASON varchar(255), + REASON CLOB, PRIMARY KEY (STATUS_ID, TASK_ID), FOREIGN KEY (TASK_ID) REFERENCES TASK(TASK_ID) ON DELETE CASCADE ); http://git-wip-us.apache.org/repos/asf/airavata/blob/c6cfa329/modules/registry/registry-core/src/main/resources/expcatalog-mysql.sql ---------------------------------------------------------------------- diff --git a/modules/registry/registry-core/src/main/resources/expcatalog-mysql.sql b/modules/registry/registry-core/src/main/resources/expcatalog-mysql.sql index 39b9aeb..802c5da 100644 --- a/modules/registry/registry-core/src/main/resources/expcatalog-mysql.sql +++ b/modules/registry/registry-core/src/main/resources/expcatalog-mysql.sql @@ -123,7 +123,7 @@ CREATE TABLE EXPERIMENT_STATUS ( EXPERIMENT_ID varchar(255), STATE varchar(255), TIME_OF_STATE_CHANGE timestamp DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP, - REASON varchar(255), + REASON LONGTEXT, PRIMARY KEY (STATUS_ID, EXPERIMENT_ID), FOREIGN KEY (EXPERIMENT_ID) REFERENCES EXPERIMENT(EXPERIMENT_ID) ON DELETE CASCADE ); @@ -227,7 +227,7 @@ CREATE TABLE PROCESS_STATUS ( PROCESS_ID varchar(255), STATE varchar(255), TIME_OF_STATE_CHANGE timestamp DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP, - REASON varchar(255), + REASON LONGTEXT, PRIMARY KEY (STATUS_ID, PROCESS_ID), FOREIGN KEY (PROCESS_ID) REFERENCES PROCESS(PROCESS_ID) ON DELETE CASCADE ); @@ -275,7 +275,7 @@ CREATE TABLE TASK_STATUS ( TASK_ID varchar(255), STATE varchar(255), TIME_OF_STATE_CHANGE timestamp DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP, - REASON varchar(255), + REASON LONGTEXT, PRIMARY KEY (STATUS_ID, TASK_ID), FOREIGN KEY (TASK_ID) REFERENCES TASK(TASK_ID) ON DELETE CASCADE ); http://git-wip-us.apache.org/repos/asf/airavata/blob/c6cfa329/modules/registry/registry-core/src/test/resources/expcatalog-derby.sql ---------------------------------------------------------------------- diff --git a/modules/registry/registry-core/src/test/resources/expcatalog-derby.sql b/modules/registry/registry-core/src/test/resources/expcatalog-derby.sql index 3156aa2..f776e25 100644 --- a/modules/registry/registry-core/src/test/resources/expcatalog-derby.sql +++ b/modules/registry/registry-core/src/test/resources/expcatalog-derby.sql @@ -123,7 +123,7 @@ CREATE TABLE EXPERIMENT_STATUS ( EXPERIMENT_ID varchar(255), STATE varchar(255), TIME_OF_STATE_CHANGE timestamp DEFAULT '0000-00-00 00:00:00', - REASON varchar(255), + REASON CLOB, PRIMARY KEY (STATUS_ID, EXPERIMENT_ID), FOREIGN KEY (EXPERIMENT_ID) REFERENCES EXPERIMENT(EXPERIMENT_ID) ON DELETE CASCADE ); @@ -225,7 +225,7 @@ CREATE TABLE PROCESS_STATUS ( PROCESS_ID varchar(255), STATE varchar(255), TIME_OF_STATE_CHANGE timestamp DEFAULT '0000-00-00 00:00:00', - REASON varchar(255), + REASON CLOB, PRIMARY KEY (STATUS_ID, PROCESS_ID), FOREIGN KEY (PROCESS_ID) REFERENCES PROCESS(PROCESS_ID) ON DELETE CASCADE ); @@ -273,7 +273,7 @@ CREATE TABLE TASK_STATUS ( TASK_ID varchar(255), STATE varchar(255), TIME_OF_STATE_CHANGE timestamp DEFAULT '0000-00-00 00:00:00', - REASON varchar(255), + REASON CLOB, PRIMARY KEY (STATUS_ID, TASK_ID), FOREIGN KEY (TASK_ID) REFERENCES TASK(TASK_ID) ON DELETE CASCADE );
