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:

• Oracle 12.1c with the 12.1c driver
• MySQL 5.7 with the 6.0.3 driver
• PostgreS 9.5 with the 9.4.1210 driver
• Derby 10.12.1.1
• H2 1.4.192
• HSQLDB 2.3.3

###Caveats

H2

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

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 so OracleTypes.CURSOR is required for ref cursors

Java 8 Date and Time API

Driver support is hit and miss.