Derby

Supported Versions

10.15 (Important: see ‘Compatibility’ below)
10.14
10.13
10.12
10.11

Driver

URL format	`jdbc:derby:subsubprotocol:databaseName`
Maven Central coordinates	`org.apache.derby:derbyclient:10.14.1.0`
Supported versions	`10.11` and later
Default Java class	`org.apache.derby.jdbc.EmbeddedDriver`

SQL Script Syntax

Standard SQL syntax with statement delimiter ;

Compatibility

DDL exported by Derby can be used unchanged in a MigrateDB migration
Any Derby SQL script executed by MigrateDB, can be executed by the Derby tools (after the placeholders have been replaced)
The Derby 10.15 driver requires Java 9+.

Example

/* Single line comment */
CREATE TABLE test_data (
  value VARCHAR(25) NOT NULL PRIMARY KEY
);

/*
Multi-line
comment
*/

-- Sql-style comment

-- Placeholder
INSERT INTO ${tableName} (value) VALUES ('Mr. T');

Limitations

None

Snowflake ➡️