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

[GSS] (6.3.z) Unable to get log tables precision up to milliseconds when using MariaDB/MySQL

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 6.3.4, 6.3.4.GA
    • 6.3.0
    • Business Central
    • None
    • BxMS 6.3 since MariaDB is certified only on it

    • CR1

      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/

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

              Created:
              Updated:
              Resolved: