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
• H2 1.4.193
• HSQLDB 2.3.3
• MySQL 5.7 with the 6.0.5 driver
• Oracle 12.1c with the 12.1c driver
• PostgreS 9.6 with the 9.4.1212 driver
• SQL Server 2016 with the 6.1.0 driver

Caveats

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

Postgres

• pgjdbc 9.4.1210 or later is recommended

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

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.