Database Support

In theory any database with a JDBC 4.1 or later driver is supported.

In practice only the following databases have been tested:

• DB2 LUW 11.5.0.0
• Derby 10.15.1.3
• Firebird 3.0.4 with the jaybird 4.0.0 driver
• H2 1.4.200
• HSQLDB 2.5.0
• MariaDB 10.4 with the 2.6.0 driver
• MySQL 8.0 with the 8.0.19 driver
• Oracle 19.3.0.0c with the 19.3.0.0c driver
• PostgreS 12.2 with the 42.2.12 driver
• SQL Server 2019 with the 8.2.2 driver

Notes

In general we recommend using the latest JDBC drivers from your vendor.

Firebird

• @OutParameter, @ReturnValue or no annotation at all, all of them work

H2

• does not support out parameters, use either @ReturnValue or no annotation at all
• 1.4.193 or later is required

HSQLDB

• functions do not support out parameters, do not use @ReturnValue, use no annotation at all

MariaDB

• ref cursors only work if you use neither @OutParameter nor @ReturnValue

MySQL

• ref cursors only work if you use neither @OutParameter nor @ReturnValue

Oracle

• JDBC 4.2 is not supported with the 12.1c or earlier driver so OracleTypes.CURSOR is required for ref cursors
• the 12.2c driver is required for PL/SQL boolean support

Postgres

• pgjdbc 9.4.1210 or later is recommended
• ref cursors may not support fetchSize util https://github.com/pgjdbc/pgjdbc/pull/925 is fixed

SQL Server

• mssql-jdbc 6.3.0 or later is recommend
• ref cursors are only supported server side, not client side

Java 8 Date and Time API

Driver support is quite good except for DB2.