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:

• Derby 10.13.1.1
• Firebird 3.0.2 with the jaybird 3.0.1 driver
• H2 1.4.196
• HSQLDB 2.4.0
• MariaDB 10.3 with the 2.1.0 driver
• MySQL 5.7 with the 6.0.6 driver
• Oracle 12.1c with the 12.1c driver
• PostgreS 9.6 with the 42.1.4 driver
• SQL Server 2016 with the 6.3.0 preview 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

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 hit and miss.