Apache DB | DdlUtils | for

Home

Section |
apache.org > db > ddlutils | PDF
## Axion Database support for Axion is legacy in DdlUtils because Axion does not appear to be actively developed anymore. Also, support for fundamential JDBC functionality necessary for DdlUtils (such as database metadata) is lacking to a certain degree in Axion. Info about the datatypes supported by Axion can be found here. Platform identifier: Axion Recognized JDBC driver: org.axiondb.jdbc.AxionDriver Recognized JDBC sub protocol: jdbc:axiondb
The database supports SQL comments | no
The database supports delimited identifiers | no
The database's maximum identifier length | unlimited
The database supports default values for LONG types | yes
DdlUtils uses sequences for identity columns | no
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 | no
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 BLOB
BIGINT | BIGINT | This requires Axion CVS head
BINARY | BINARY |
BIT | BOOLEAN |
BLOB | BLOB |
BOOLEAN | BOOLEAN |
CHAR | CHAR |
CLOB | CLOB |
DATALINK | VARBINARY | Will be read back as VARBINARY
DATE | DATE | Axion handles DATE, TIME the same as TIMESTAMP
DECIMAL | DECIMAL | scale is currently fixed to 2 in Axion (though a different one can be specified)
DISTINCT | VARBINARY | Will be read back as VARBINARY
DOUBLE | DOUBLE |
FLOAT | FLOAT |
INTEGER | INTEGER |
JAVA_OBJECT | JAVA_OBJECT |
LONGVARBINARY | LONGVARBINARY |
LONGVARCHAR | LONGVARCHAR |
NULL | VARBINARY | Will be read back as VARBINARYd
NUMERIC | NUMERIC | scale is currently fixed to 2 (though a different one can be specified)
OTHER | BLOB | Will be read back as BLOB
REAL | REAL | Will be read back as FLOAT
REF | VARBINARY | Will be read back as VARBINARY
SMALLINT | SMALLINT |
STRUCT | VARBINARY | Will be read back as VARBINARY
TIME | TIME | Axion handles DATE, TIME the same as TIMESTAMP
TIMESTAMP | TIMESTAMP |
TINYINT | SMALLINT | Will be read back as SMALLINT
VARBINARY | VARBINARY |
VARCHAR | VARCHAR |