Re: [Dev] [Blocker] Issues with AM_DB scripts for Oracle

2014-05-06 Thread Nirodha Pramod
Hi Lakmali, There is another blocking issue[6] with Oracle when generating Keys in store. Please have a look. regards, Nirodha [6] https://wso2.org/jira/browse/APIMANAGER-2302 On Mon, May 5, 2014 at 9:38 PM, Lakmali Baminiwatta lakm...@wso2.comwrote: Hi, Please find the fixed oracle

Re: [Dev] [Blocker] Issues with AM_DB scripts for Oracle

2014-05-06 Thread Lakmali Baminiwatta
On 6 May 2014 23:18, Nirodha Pramod niro...@wso2.com wrote: Hi Lakmali, There is another blocking issue[6] with Oracle when generating Keys in store. Please have a look. regards, Nirodha [6] https://wso2.org/jira/browse/APIMANAGER-2302 Fixed in r202087and r202103. On Mon, May 5,

Re: [Dev] [Blocker] Issues with AM_DB scripts for Oracle

2014-05-05 Thread Nirodha Pramod
Hi, For issue [2] I have given the privileges as mentioned in [4] but did not work. And as Lakmali mentioned offline we need to give privileges as below. Hence the docs need to be updated. Created a JIRA [5] for that. sqlpluscreate user lakmaliuser identified by wso2; sqlplusgrant

Re: [Dev] [Blocker] Issues with AM_DB scripts for Oracle

2014-05-05 Thread Nirodha Pramod
Hi Lakmali, Can we have a patch for this issue [3] this is an absolute blocker for testing on Oracle. regards, Nirodha On Mon, May 5, 2014 at 10:56 AM, Lakmali Baminiwatta lakm...@wso2.comwrote: Hi, On 3 May 2014 00:26, Nirodha Pramod niro...@wso2.com wrote: Hi, Following two blocking

Re: [Dev] [Blocker] Issues with AM_DB scripts for Oracle

2014-05-05 Thread Lakmali Baminiwatta
Hi, Please find the fixed oracle script attached. Thanks, Lakmali On 5 May 2014 21:11, Nirodha Pramod niro...@wso2.com wrote: Hi Lakmali, Can we have a patch for this issue [3] this is an absolute blocker for testing on Oracle. regards, Nirodha On Mon, May 5, 2014 at 10:56 AM,

Re: [Dev] [Blocker] Issues with AM_DB scripts for Oracle

2014-05-05 Thread Charitha Kankanamge
Hi, Can we please have the corresponding MSSQL script as well? Charitha Kankanamge cell: +1 812-391-7730 http://charithaka.blogspot.com *SOA and Testing without nonsense* On Mon, May 5, 2014 at 9:38 PM, Lakmali Baminiwatta lakm...@wso2.comwrote: Hi, Please find the fixed oracle script

Re: [Dev] [Blocker] Issues with AM_DB scripts for Oracle

2014-05-05 Thread Charitha Kankanamge
CREATE TABLE AM_API_DEFAULT_VERSION ( DEFAULT_VERSION_ID INTEGER NOT NULL IDENTITY, API_NAME VARCHAR(256) NOT NULL , API_PROVIDER VARCHAR(256) NOT NULL , DEFAULT_API_VERSION VARCHAR(30) , PUBLISHED_DEFAULT_API_VERSION VARCHAR(30) ,

Re: [Dev] [Blocker] Issues with AM_DB scripts for Oracle

2014-05-05 Thread Lakmali Baminiwatta
Hi, On 6 May 2014 02:37, Charitha Kankanamge chari...@wso2.com wrote: CREATE TABLE AM_API_DEFAULT_VERSION ( DEFAULT_VERSION_ID INTEGER NOT NULL IDENTITY, API_NAME VARCHAR(256) NOT NULL , API_PROVIDER VARCHAR(256) NOT NULL ,

Re: [Dev] [Blocker] Issues with AM_DB scripts for Oracle

2014-05-04 Thread Lakmali Baminiwatta
Hi, On 3 May 2014 00:26, Nirodha Pramod niro...@wso2.com wrote: Hi, Following two blocking issues were found with the oracle script for AM_DB on 29th April pack. Please have a look. [1] https://wso2.org/jira/browse/APIMANAGER-2266 Had been Fixed now. [2]

[Dev] [Blocker] Issues with AM_DB scripts for Oracle

2014-05-02 Thread Nirodha Pramod
Hi, Following two blocking issues were found with the oracle script for AM_DB on 29th April pack. Please have a look. [1] https://wso2.org/jira/browse/APIMANAGER-2266 [2] https://wso2.org/jira/browse/APIMANAGER-2268 regards, Nirodha -- *Nirodha Gallage* Senior Software Engineer, QA. WSO2