This post adresses how Hibernate, HibernateJPA, EclipseLink and OpenJPA are supported to work in conjunction with different databases to form a compatibility matrix. More information on this topic can be found here.
TreeDB supports the JPA compatible propriety object database ObjectDB (tested with version 2.6.4), which is not mapped through the matrix. As a persistence framework and database in one, it is exception to the rule.
The demo database of our online version was reconstructed during each of our tests, to accomodate different types of data, (user data, text, images and videos) .
| SQL-Datenbank | DB-Version | JDBC-Version | H | HJ | EJ | OJ | License |
|---|---|---|---|---|---|---|---|
| H2 | 1.4.185 | - |  |
|
|
|
Open Source |
| Apache Derby | 10.12.1.1 | - | |
|
|
|
Open Source |
| HSQLDB | 2.3.2 | - | |
|
 1 |
|
Open Source |
| MSSQL 2014 | 12 | Version 4 | |
|
|
|
Propriety |
| Oracle Express | 11g | 12.1.0.2 | 2 |
2 |
|
2 |
Propriety |
| IBM DB2 Express | 10.1.2 | 4.19.26 | |
|
|
3 |
Propriety |
| MySQL | 5.6.27 | 5.1.37 | |
|
|
|
Open Source |
| MariaSQL | 10.0.22 | 1.3.2 | |
|
|
4 |
Open Source |
| Postgres | 9.4 | 9.4-1205 | |
|
|
|
Open Source |
| sqlite-jdbc | 3.8.11.2 | - | |
|
! |
|
Open Source |
| Description | Notes/Issues |
|---|---|
| H/HJ | Hibernate/Hibernate JPA 5.0.4.Final |
| EJ | EclipseLink JPA 2.6.1 |
| OJ | OpenJPA 2.4.0 |
| 1 | java.sql.SQLDataException: data exception: string data, right truncation |
| 2 | java.sql.SQLException: ORA-01691: unable to extend lob segment |
| 3 | Automatic DROP for existing tables is not functional. |
| 4 | Only functional with a MySQL-JDBC connection |
| ! | Experimental, sqlite is not multi-threading compatible!! |