| apache.org > db > ddlutils |
HsqlDB
DdlUtils supports the HSQLDB database, version 1.7.2 or newer. SQL Documentation for HSQLDB can be found in the distribution, and for the newest version here.
Platform identifier:
- HsqlDb
Recognized JDBC driver:
- org.hsqldb.jdbcDriver
Recognized JDBC sub protocol:
- jdbc:hsqldb
| The database supports SQL comments | yes |
| The database supports delimited identifiers | yes |
| The database's maximum identifier length | unlimited |
| The database supports default values for LONG types | yes |
| DdlUtils uses sequences for identity columns | no |
| The database supports non-primary key columns as identity columns | no |
| The database allows INSERT/UPDATE statements to set values for identity columns | yes |
| DdlUtils can read back the auto-generated value of an identity column | yes |
| The database supports non-unique indices | yes |
| DdlUtils can create a database via JDBC | no |
| DdlUtils can drop a database via JDBC | no |
| JDBC Type | Database Type | Additional comments | |
|---|---|---|---|
| ARRAY | LONGVARBINARY | Will be read back as LONGVARBINARY | |
| BIGINT | BIGINT | ||
| BINARY | BINARY | ||
| BIT | BOOLEAN | Will be read back as BOOLEAN | |
| BLOB | LONGVARBINARY | Will be read back as LONGVARBINARY | |
| BOOLEAN | BOOLEAN | BOOLEAN is supported natively by Hsqldb only since version 1.7.2 | |
| CHAR | CHAR | The size is optional because per default Hsqldb does not enforce it | |
| CLOB | LONGVARCHAR | Will be read back as LONGVARCHAR | |
| DATALINK | LONGVARBINARY | Will be read back as LONGVARBINARY | |
| DATE | DATE | ||
| DECIMAL | DECIMAL | Precision and scale are ignored by Hsqldb, as it uses unlimited precision and scale | |
| DISTINCT | LONGVARBINARY | Will be read back as LONGVARBINARY | |
| DOUBLE | DOUBLE | ||
| FLOAT | DOUBLE | Will be read back as DOUBLE | |
| INTEGER | INTEGER | ||
| JAVA_OBJECT | OBJECT | ||
| LONGVARBINARY | LONGVARBINARY | ||
| LONGVARCHAR | LONGVARCHAR | ||
| NULL | LONGVARBINARY | Will be read back as LONGVARBINARY | |
| NUMERIC | NUMERIC | Precision and scale are ignored by Hsqldb, as it uses unlimited precision and scale | |
| OTHER | OTHER | ||
| REAL | REAL | ||
| REF | LONGVARBINARY | Will be read back as LONGVARBINARY | |
| SMALLINT | SMALLINT | ||
| STRUCT | LONGVARBINARY | Will be read back as LONGVARBINARY | |
| TIME | TIME | ||
| TIMESTAMP | TIMESTAMP | ||
| TINYINT | SMALLINT | JDBC's TINYINT requires a value range of -255 to 255, but HsqlDb's is only -128 to 127 Will be read back as SMALLINT |
|
| VARBINARY | VARBINARY | ||
| VARCHAR | VARCHAR | The size is optional because per default Hsqldb does not enforce it |