Home
 

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