[jira] [Commented] (OFBIZ-9496) MySql Database related warning related to DATETIME filed

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-9496?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16097317#comment-16097317 ]

Deepak Dixit commented on OFBIZ-9496:
-------------------------------------

Slightly modified patch has been committed at ofbiz framework trunk at r#1802693
- Removed formatting
- Use OR instead of AND while checking DATETIME/TIME field.

> MySql Database related warning related to DATETIME filed
> --------------------------------------------------------
>
>                 Key: OFBIZ-9496
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-9496
>             Project: OFBiz
>          Issue Type: Improvement
>            Reporter: Deepak Dixit
>            Assignee: Deepak Dixit
>            Priority: Minor
>         Attachments: OFBIZ-9496.patch
>
>
> Here are the following warnings that we are getting for all the datetime related filed.
> this is due to incorrect handling of database filed type comparison in DatabaseUtil.java
> {code}
> 2017-07-18 12:30:19,137 |OFBiz-batch-2        |DatabaseUtil                  |W| Column [LAST_UPDATED_TX_STAMP] of table [RUNTIME_DATA] of entity [RuntimeData] has a column size of [19] in the database, but is defined to have a column size of [3] in the entity definition.
> {code}

--
This message was sent by Atlassian JIRA
(v6.4.14#64029)