Also can we do something
<file>
<source>../../distribution/product/target/repository/database/WSO2AM_DB.h2.db</source>
<outputDirectory>wso2am-${pom.version}/repository/database</outputDirectory>
<filtered>true</filtered>
<fileMode>666</fileMode>
</file>
As a fix like APIM 1.6
On Sun, May 4, 2014 at 11:11 AM, Gayan Gunawardana <[email protected]> wrote:
> 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/
>
--
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
