Uploaded image for project: 'OFBiz'
  1. OFBiz
  2. OFBIZ-9496

MySql Database related warning related to DATETIME filed

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Minor
    • Resolution: Unresolved
    • None
    • None
    • None
    • None

    Description

      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

      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.

      Attachments

        1. OFBIZ-9496.patch
          4 kB
          Jacopo Cappellato

        Issue Links

          is related to

          Improvement - An improvement or enhancement to an existing feature or task. OFBIZ-9337 Update msyql sql-type for datetime field-type to support Fractional Seconds in Time Values

          • Major - Major loss of function.
          • Closed

          Activity

            People

              deepak Deepak Dixit
              deepak Deepak Dixit
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated: