Supported Databases

DB2
Derby / JavaDB
H2
HSQLDB (HyperSQL)
Microsoft SQL Server
MySQL
Oracle
PostgreSQL
SQLite

Other SQL databases can be accessed right away with a reduced feature set. Writing a fully featured plugin for your own SQL-based backend can be achieved with a reasonable amount of work. Support for other backends (like NoSQL) is under development but not yet available.

The following capabilities are supported by the profiles. A checkmark means that a capability is fully supported. In other cases it may be partially supported or not at all. See the individual profile’s API documentation for details.

Capability	`DB2`	`Derby`	`H2`	`Hsqldb`	`MySQL`	`Oracle`	`Postgres`	`SQLite`	`SQLServer`
`relational.other`	✅	✅	✅	✅	✅	✅	✅	✅	✅
`relational.columnDefaults`	✅	✅	✅	✅	✅	✅	✅	✅	✅
`relational.foreignKeyActions`	✅	✅	✅	✅	✅		✅	✅	✅
`relational.functionDatabase`	✅		✅	✅	✅	✅	✅		✅
`relational.functionUser`	✅	✅	✅	✅	✅	✅	✅		✅
`relational.indexOf`	✅	✅	✅	✅	✅	✅	✅	✅	✅
`relational.joinFull`	✅			✅		✅	✅		✅
`relational.joinLeft`	✅	✅	✅	✅	✅	✅	✅	✅	✅
`relational.joinRight`	✅	✅	✅	✅	✅	✅	✅		✅
`relational.likeEscape`	✅	✅	✅	✅	✅	✅	✅	✅	✅
`relational.pagingDrop`	✅	✅	✅	✅	✅	✅	✅	✅	✅
`relational.pagingNested`	✅		✅	✅	✅	✅	✅	✅	✅
`relational.pagingPreciseTake`	✅	✅	✅	✅	✅	✅	✅	✅	✅
`relational.repeat`	✅		✅	✅	✅	✅	✅	✅	✅
`relational.replace`	✅		✅	✅	✅	✅	✅	✅	✅
`relational.reverse`				✅	✅	✅	✅	✅	✅
`relational.setByteArrayNull`	✅	✅	✅	✅	✅	✅	✅	✅	✅
`relational.typeBigDecimal`	✅	✅	✅	✅	✅	✅	✅		✅
`relational.typeBlob`	✅	✅	✅	✅	✅	✅	✅		✅
`relational.typeLong`	✅	✅	✅	✅	✅	✅	✅	✅	✅
`relational.zip`	✅		✅	✅	✅	✅	✅		✅
`sql.other`	✅	✅	✅	✅	✅	✅	✅	✅	✅
`sql.sequence`	✅	✅	✅	✅	✅	✅	✅
`sql.sequenceCurr`	✅		✅		✅	✅	✅	✅	✅
`sql.sequenceCycle`	✅			✅	✅	✅	✅	✅	✅
`sql.sequenceLimited`	✅	✅	✅	✅		✅	✅	✅	✅
`sql.sequenceMax`	✅	✅		✅	✅	✅	✅	✅	✅
`sql.sequenceMin`	✅	✅		✅	✅	✅	✅	✅	✅
`jdbc.other`	✅	✅	✅	✅	✅	✅	✅	✅	✅
`jdbc.booleanMetaData`			✅	✅	✅		✅		✅
`jdbc.createModel`	✅	✅	✅	✅	✅	✅	✅	✅	✅
`jdbc.defaultValueMetaData`	✅	✅	✅	✅	✅	✅	✅		✅
`jdbc.distinguishesIntTypes`	✅	✅	✅	✅			✅		✅
`jdbc.forShare`					✅		✅		✅
`jdbc.forUpdate`	✅	✅	✅	✅	✅	✅	✅		✅
`jdbc.forceInsert`	✅	✅	✅	✅	✅	✅	✅	✅
`jdbc.insertMultipleRowsWithSingleStatement`	✅	✅	✅	✅	✅		✅	✅
`jdbc.insertOrUpdate`					✅
`jdbc.insertOrUpdateWithPrimaryKeyOnly`	✅		✅	✅	✅	✅		✅	✅
`jdbc.mutable`	✅	✅	✅	✅	✅	✅	✅		✅
`jdbc.nullableNoDefault`	✅	✅	✅	✅		✅		✅	✅
`jdbc.returnInsertKey`	✅	✅	✅	✅	✅	✅	✅	✅	✅
`jdbc.returnInsertOther`	✅			✅		✅	✅
`jdbc.returnMultipleInsertKey`	✅		✅	✅	✅		✅
`jdbc.supportsByte`			✅	✅	✅

The source code for this page can be found here.

Next: Schema Code Generation