Apache DB | DdlUtils | for

Home

Section |
apache.org > db > ddlutils | PDF
## 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 |