Hi,

A public JIRA is raised in [1].

[1] https://wso2.org/jira/browse/REGISTRY-3610

Thanks.

On Tue, May 10, 2016 at 12:11 PM, Janaka Ranabahu <jan...@wso2.com> wrote:

> Hi Thushara
>
> On Tue, May 10, 2016 at 12:06 PM, Thushara Ranawaka <thusha...@wso2.com>
> wrote:
>
>> Hi Thilini,
>>
>> AFAIU you workaround need to be updated with the current timestamp[1][2].
>> Setting default value to zero is not nice. You might have to figure out the
>> correct syntax for other DB types and test against them.
>>
> ​What Thilini is pointing is an issue in the Registry database creation
> script. Hence we will create a public JIRA and assign it to you guys.
> Please fix them.
>
> We can not modify the Registry database creation script since API Manager
> would not capture the complete scenarios of G-Reg.
>
> Thanks,
> Janaka​
>
>
>>
>>
>> [1] - DEFAULT CURRENT_TIMESTAMP
>> [2] -
>> http://stackoverflow.com/questions/168736/how-do-you-set-a-default-value-for-a-mysql-datetime-column
>>
>> Thanks,
>> Thushara.
>>
>> On Tue, May 10, 2016 at 11:52 AM, Thilini Cooray <thili...@wso2.com>
>> wrote:
>>
>>> Hi GReg team,
>>>
>>> We encounter following issue [1] while testing API Manager with MySQL 5.7
>>> MySQL 5.7 has enabled NO_ZERO_IN_DATE, NO_ZERO_DATE policies by
>>> default. Therefore it does not allow 0 as a valid default value for
>>> date/time.
>>>
>>> As a workaround we can set MySQL server to accept 0 changing the default
>>> server settings if the database owner agrees on it.
>>> [2] contains the related table creation script.
>>>
>>> Appreciate your feedback on a fix for this.
>>>
>>> [1] https://wso2.org/jira/browse/APIMANAGER-4645
>>>
>>> [2] CREATE TABLE IF NOT EXISTS REG_RESOURCE (
>>>             REG_PATH_ID         INTEGER NOT NULL,
>>>             REG_NAME            VARCHAR(256),
>>>             REG_VERSION         INTEGER NOT NULL AUTO_INCREMENT,
>>>             REG_MEDIA_TYPE      VARCHAR(500),
>>>             REG_CREATOR         VARCHAR(31) NOT NULL,
>>>             REG_CREATED_TIME    TIMESTAMP NOT NULL *DEFAULT 0*,
>>>             REG_LAST_UPDATOR    VARCHAR(31),
>>>             REG_LAST_UPDATED_TIME    TIMESTAMP NOT NULL *DEFAULT 0*,
>>>             REG_DESCRIPTION     VARCHAR(1000),
>>>             REG_CONTENT_ID      INTEGER,
>>>             REG_TENANT_ID INTEGER DEFAULT 0,
>>>             REG_UUID VARCHAR(100) NOT NULL,
>>>             CONSTRAINT PK_REG_RESOURCE PRIMARY KEY(REG_VERSION,
>>> REG_TENANT_ID)
>>> )ENGINE INNODB;
>>>
>>> Thanks.
>>>
>>> --
>>> Best Regards,
>>>
>>> *Thilini Cooray*
>>> Software Engineer
>>> Mobile : +94 (0) 774 570 112 <%2B94%20%280%29%20773%20451194>
>>> E-mail : thili...@wso2.com
>>>
>>> WSO2 Inc. www.wso2.com
>>> lean.enterprise.middleware
>>>
>>> _______________________________________________
>>> Dev mailing list
>>> Dev@wso2.org
>>> http://wso2.org/cgi-bin/mailman/listinfo/dev
>>>
>>>
>>
>>
>> --
>> Thanks,
>> Thushara Kasun Ranawaka
>> Software Engineer
>> WSO2 Inc.; <http://www.wso2.com>
>> lean.enterprise.middleware
>> Mobile : *+94 (0) 773438949 <%2B94%20%280%29%20773438949>*
>> *thusha...@wso2.com <thusha...@wso2.com>*
>>
>
>
>
> --
> *Janaka Ranabahu*
> Associate Technical Lead, WSO2 Inc.
> http://wso2.com
>
>
> *E-mail: jan...@wso2.com <http://wso2.com>**M: **+94 718370861
> <%2B94%20718370861>*
>
> Lean . Enterprise . Middleware
>



-- 
Best Regards,

*Thilini Cooray*
Software Engineer
Mobile : +94 (0) 774 570 112 <%2B94%20%280%29%20773%20451194>
E-mail : thili...@wso2.com

WSO2 Inc. www.wso2.com
lean.enterprise.middleware
_______________________________________________
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

Reply via email to