Please apply following changes to h2.sql script inside the feature.
This has been fixed in latest feature (4.2.2) that will get shipped with AM
1.7.0.
@@ -1,5 +1,5 @@
CREATE TABLE AM_WORKFLOWS(
- WF_ID INTEGER AUTO_INCREMENT,
+ WF_ID INTEGER,
WF_REFERENCE VARCHAR(255) NOT NULL,
WF_TYPE VARCHAR(255) NOT NULL,
WF_STATUS VARCHAR(255) NOT NULL,
@@ -16,14 +16,14 @@
CREATE SEQUENCE AM_WORKFLOWS_SEQUENCE START WITH 1 INCREMENT BY 1
/
-CREATE OR REPLACE AM_WORKFLOWS_TRIGGER
+CREATE OR REPLACE TRIGGER AM_WORKFLOWS_TRIGGER
BEFORE INSERT
ON AM_WORKFLOWS
REFERENCING NEW AS NEW
FOR EACH ROW
BEGIN
SELECT AM_WORKFLOWS_SEQUENCE.nextval INTO :NEW.WF_ID
FROM dual;
- END
+ END;
/
ALTER TABLE AM_APPLICATION ADD APPLICATION_STATUS VARCHAR2(50) DEFAULT
'APPROVED'
On Sun, May 4, 2014 at 10:10 AM, Gayan Gunawardana <[email protected]> wrote:
> Hi,
>
> Default database scripts which are coming from APIM features does not have
> "APPLICATION_STATUS" attribute inside AM_APPLICATION table which causes to
> throw
>
> Failed to add Application
> org.h2.jdbc.JdbcSQLException: Column "APPLICATION_STATUS" not found; SQL
> statement:
> INSERT INTO AM_APPLICATION (NAME, SUBSCRIBER_ID, APPLICATION_TIER,
> CALLBACK_URL, DESCRIPTION, APPLICATION_STATUS) VALUES (?,?,?,?,?,?)
> [42122-140]
> at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
> at org.h2.message.DbException.get(DbException.java:167)
>
>
> --
> Gayan Gunawardana
> Software Engineer; WSO2 Inc.; http://wso2.com/
> Email: [email protected]
> Mobile: +94 (71) 8020933
>
> _______________________________________________
> Dev mailing list
> [email protected]
> http://wso2.org/cgi-bin/mailman/listinfo/dev
>
>
--
/sumedha
m: +94 773017743
b : bit.ly/sumedha
_______________________________________________
Dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev
