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