-
Type: Task
-
Status: Resolved
-
Priority: Minor
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 9.1
-
Component/s: Core, Core VCS, Distribution / Installers
-
Sprint:nxFG 9.1.2, nxFG 9.1.3, nxFG 9.1.4, nxFG 9.1.5
-
Story Points:1
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.