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
