What is TreeDB?

TreeDB is a web based programmable database system for hierarchical data structures, which are organised in the form of a tree. Every leaf or node can be interlinked with desired data (data fields, text, multimedia data or documents). Diverse data also has the option of being worked into the body of a presentation in HTML format or can be displayed in collaboration with programme logic. 

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-DatenbankDB-VersionJDBC-VersionHHJ EJOJ License
H2 1.4.185 - Open Source
Apache Derby -   Open Source
HSQLDB 2.3.2 - 1 Open Source
MSSQL 2014 12 Version 4 Propriety
Oracle Express 11g 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 - ! 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!!