Uploaded image for project: 'Spring Integration'
  1. Spring Integration
  2. INT-2987

MessageStore MySQL - Support Fractional Seconds

    XMLWordPrintable

    Details

      Description

      The SQL scripts to generate the MySQL table use the DATETIME datatype to store temporal information. Unfortunately, MySQL < 5.6.4 does not support fractional seconds. This, may cause non-deterministic behavior when messages are being polled from a MessageStore.

      "MySQL 5.6.4 and up expands fractional seconds support for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision"

      Therefore, I think we should improve the SQL scripts and a define maximum precision of:

      DATETIME(6)

      Furthermore, we should add a note to the documentation, that when using a MySQL- based message store, a version of MySQL >=5.6.4 shall be used and the reasons why.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              hillert Gunnar Hillert
              Reporter:
              hillert Gunnar Hillert
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: