Uploaded image for project: 'JBoss BPMS Platform'
  1. JBoss BPMS Platform
  2. RHBPMS-4207

Unable to get log tables precision up to milliseconds when using MariaDB/MySQL

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Critical
    • 6.4.0
    • 6.3.0
    • Business Central
    • None
    • BxMS 6.3 since MariaDB is certified only on it

    • Documentation (Ref Guide, User Guide, etc.)
    • ER3

    Description

      BxMS 6.3 does not store milliseconds when using MariaDB for log tables (e.g. NodeInstanceLog - log_date column). Looking in DDLs I see that tables are created as follows:

      create table NodeInstanceLog (
      id bigint not null auto_increment,
      connection varchar(255),
      log_date datetime,
      ...

      According to [1], datetime will not store milliseconds. I have modified it as follows:

      log_date datetime (6)

      However, the value is not store properly. The milliseconds is stored properly and work well if using PostgreSQL for instance.

      [1] https://mariadb.com/kb/en/mariadb/datetime/

      Attachments

        Issue Links

          Activity

            People

              swiderski.maciej Maciej Swiderski (Inactive)
              rhn-support-ajuricic Amana Juricic
              Jan Hrcek Jan Hrcek (Inactive)
              Jan Hrcek Jan Hrcek (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: