Home
 

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