Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-21350

Use specific template and JDBC driver for MariaDB

    XMLWordPrintable

    Details

      Description

      In order to support milliseconds correctly on MariaDB (NXP-21338), we need to use the MariaDB Connector/J JDBC driver instead of the MySQL Connector/J.

      The reason is that the driver formats timestamps by default without milliseconds, and passing milliseconds is activated differently depending on the actual driver/database.
      1. the MySQL connector automatically detects that the MySQL server is at version >= 5.6.4 but MariaDB still reports 5.5.5.
      2. the MariaDB connector uses milliseconds by default (useFractionalSeconds=true).

      So the MySQL connector by itself is not enough to work with MariaDB and we must use the MariaDB connector.


      To use MariaDB, the template mariadb must be used instead of mysql.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: