Hi, Thanks for the quick reply.
On Sun, May 4, 2014 at 11:04 AM, Sumedha Rubasinghe <[email protected]>wrote: > 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 > -- Gayan Gunawardana Software Engineer; WSO2 Inc.; http://wso2.com/ Email: [email protected] Mobile: +94 (71) 8020933 Blog: http://gayanj2ee.blogspot.com/
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
