Supported Databases

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.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.