Hi All, It seems that the API-Mngmnt ORACLE Script used by EMM 1.1.0 has not been updated accordingly.
I have created the following JIRA to track this issue. https://wso2.org/jira/browse/EMM-780 Thanks. Dilan. *Dilan U. Ariyaratne* Software Engineer WSO2 Inc. <http://wso2.com/> Mobile: +94775149066 lean . enterprise . middleware On Thu, Feb 19, 2015 at 11:11 AM, Dilan Udara Ariyaratne <[email protected]> wrote: > Hi Folks, > > After going through the script, found out following to be the reasons for > error messages popped up at the SQL-prompt. > > [1] Oracle does not support "AUTO_INCREMENT" syntax. > > CREATE TABLE AM_WORKFLOWS ( > WF_ID INTEGER AUTO_INCREMENT, > WF_REFERENCE VARCHAR(255) NOT NULL, > WF_TYPE VARCHAR(255) NOT NULL, > WF_STATUS VARCHAR(255) NOT NULL, > WF_CREATED_TIME TIMESTAMP, > WF_UPDATED_TIME TIMESTAMP, > WF_STATUS_DESC VARCHAR(1000), > TENANT_ID INTEGER, > TENANT_DOMAIN VARCHAR(255), > WF_EXTERNAL_REFERENCE VARCHAR(255) NOT NULL UNIQUE, > PRIMARY KEY (WF_ID) > ) > > [2] Missing "TRIGGER" word at AM_WORKFLOWS_TRIGGER operation. > > CREATE OR REPLACE 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; > > > A verification is highly appreciated. > > I was not able to find any available JIRA for this. > > Thanks. > > > > *Dilan U. Ariyaratne* > Software Engineer > WSO2 Inc. <http://wso2.com/> > Mobile: +94775149066 > lean . enterprise . middleware > > On Wed, Feb 18, 2015 at 9:06 PM, Dilan Udara Ariyaratne <[email protected]> > wrote: > >> Hi Folks, >> >> I have been testing the ORACLE Support Scripts of API Management module >> that resides inside EMM 1.1.0. >> >> When I ran the .sql file of API Manager Table creation script of EMM, >> few errors complaining the wrong syntax of queries popped up >> as in the attached image. >> >> Is this an already known bug that has not yet been fixed? >> >> Appreciate your feedback on this. >> >> Thanks. >> >> *Dilan U. Ariyaratne* >> Software Engineer >> WSO2 Inc. <http://wso2.com/> >> Mobile: +94775149066 >> lean . enterprise . middleware >> > >
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
