| apache.org > db > ddlutils |
Mckoi
The open source database McKoi is supported in version 1.0.3. Details on the supported SQL and datatypes can be found in Chapter 2 of the Database Manual.
Platform identifier:
- McKoi
Recognized JDBC driver:
- com.mckoi.JDBCDriver
Recognized JDBC sub protocol:
- jdbc:mckoi
| 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 | yes |
| The database supports non-primary key columns as identity columns | yes |
| 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 | no |
| DdlUtils can create a database via JDBC | yes |
| DdlUtils can drop a database via JDBC | no |
| JDBC Type | Database Type | Additional comments |
|---|---|---|
| ARRAY | BLOB | Will be read back as BLOB |
| BIGINT | BIGINT | |
| BINARY | BINARY | |
| BIT | BOOLEAN | Will be read back as BOOLEAN |
| BLOB | BLOB | |
| BOOLEAN | BOOLEAN | |
| CHAR | CHAR | |
| CLOB | CLOB | |
| DATALINK | BLOB | Will be read back as BLOB |
| DATE | DATE | |
| DECIMAL | DECIMAL | |
| DISTINCT | BLOB | Will be read back as BLOB |
| DOUBLE | DOUBLE | |
| FLOAT | DOUBLE | Will be read back as DOUBLE |
| INTEGER | INTEGER | |
| JAVA_OBJECT | JAVA_OBJECT | |
| LONGVARBINARY | LONGVARBINARY | |
| LONGVARCHAR | LONGVARCHAR | |
| NULL | BLOB | Will be read back as BLOB |
| NUMERIC | NUMERIC | |
| OTHER | BLOB | Will be read back as BLOB |
| REAL | REAL | |
| REF | BLOB | Will be read back as BLOB |
| SMALLINT | SMALLINT | |
| STRUCT | BLOB | Will be read back as BLOB |
| TIME | TIME | |
| TIMESTAMP | TIMESTAMP | |
| TINYINT | TINYINT | |
| VARBINARY | VARBINARY | |
| VARCHAR | VARCHAR |