Apache DB | DdlUtils | for

Home

Section |
apache.org > db > ddlutils | PDF
## Interbase DdlUtils supports Interbase version 7.0 and above. Platform identifier: Interbase Recognized JDBC driver: interbase.interclient.Driver Recognized JDBC sub protocol: jdbc:interbase
The database supports SQL comments | yes
The database supports delimited identifiers | yes
The database's maximum identifier length | 31
The database supports default values for LONG types | yes
DdlUtils uses sequences for identity columns | sort-of, DdlUtils uses a GENERATOR
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 | yes
DdlUtils can create a database via JDBC | no
DdlUtils can drop a database via JDBC | no
JDBC Type | Database Type | Additional comments
--- | --- | ---
ARRAY | BLOB | Will be read back as LONGVARBINARY
BIGINT | NUMERIC(18,0) |
BINARY | BLOB | We could use CHAR(n) CHARACTER SET OCTETS but the JDBC driver cannot handle these types properly. Will be read back as LONGVARBINARY
BIT | SMALLINT | Interbase has no native boolean type Will be read back as SMALLINT
BLOB | BLOB | Will be read back as LONGVARBINARY
BOOLEAN | SMALLINT | Interbase has no native boolean type Will be read back as SMALLINT
CHAR | CHAR |
CLOB | BLOB SUB_TYPE TEXT |
DATALINK | BLOB | Will be read back as LONGVARBINARY
DATE | DATE |
DECIMAL | DECIMAL |
DISTINCT | BLOB | Will be read back as LONGVARBINARY
DOUBLE | DOUBLE PRECISION |
FLOAT | DOUBLE PRECISION | Will be read back as DOUBLE
INTEGER | INTEGER |
JAVA_OBJECT | BLOB | Will be read back as LONGVARBINARY
LONGVARBINARY | BLOB |
LONGVARCHAR | BLOB SUB_TYPE TEXT | Will be read back as CLOB
NULL | BLOB | Will be read back as LONGVARBINARY
NUMERIC | NUMERIC |
OTHER | BLOB | Will be read back as LONGVARBINARY
REAL | FLOAT |
REF | BLOB | Will be read back as LONGVARBINARY
SMALLINT | SMALLINT |
STRUCT | BLOB | Will be read back as LONGVARBINARY
TIME | TIME |
TIMESTAMP | TIMESTAMP |
TINYINT | SMALLINT | Will be read back as SMALLINT
VARBINARY | BLOB | We could use VARCHAR(n) CHARACTER SET OCTETS but the JDBC driver cannot handle these types properly. Will be read back as LONGVARBINARY
VARCHAR | VARCHAR |