Apache DB | DdlUtils | for

Home

Section |
apache.org > db > ddlutils | PDF
## Firebird DdlUtils supports Firebird, version 1 and above. Platform identifier: Firebird Recognized JDBC driver: org.firebirdsql.jdbc.FBDriver Recognized JDBC sub protocol: jdbc:firebirdsql
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 | 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 | 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 | BIGINT |
BINARY | BLOB | Will be read back as LONGVARBINARY
BIT | SMALLINT | Firebird has no native boolean type Will be read back as SMALLINT
BLOB | BLOB | Will be read back as LONGVARBINARY
BOOLEAN | SMALLINT | Firebird has no native boolean type Will be read back as SMALLINT
CHAR | CHAR |
CLOB | BLOB SUB_TYPE TEXT | Will be read back as LONGVARCHAR
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 |
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 | Will be read back as LONGVARBINARY
VARCHAR | VARCHAR |