20. MariaDB
Prev | Appendix 2. Supported Databases | Next

## 20. MariaDB

Example 2.17. Example properties for MariaDB

                    openjpa.ConnectionDriverName: org.mariadb.jdbc.Driver
                    openjpa.ConnectionURL: jdbc:mariadb://SERVER_NAME/DB_NAME

### 20.1. Known issues with MariaDB

- As of MariaDB 10.2 the `DATETIME` data type supports sub-second fractions. The default of MariaDB internally is to use no fractions. The number of fractions can be explicitly set via scale: `@Column(scale=6)` will lead to a `DATETIME(6)` column and able to store microseconds. A value of `@Column(scale=-1)` will explicitly turn off all fractions.

- As of MariaDB 10.7 the `UUID` data type is supported, but the JDBC driver does not writes the object directly, so UUID field support is made through UUID to String conversion.

Prev | Up | Next
19. MySQL | Home | 21. Oracle