ActiveSpaces uses a small set of data types for storing data in a data grid. When using the ActiveSpaces JDBC driver, it is important to know how the JDBC data types map to the ActiveSpaces data types.
The following table lists the JDBC data types and how they map to the ActiveSpaces data types:
JDBC Data Type
ActiveSpaces Data Type
CHAR, VARCHAR, LONGVARCHAR
string
BIT, BOOLEAN, TINYINT, SMALLINT,INTEGER, BIGINT
long
REAL, FLOAT, DOUBLE
double
BINARY, VARBINARY, LONGVARBINARY,BLOB
opaque
DATE, TIME, TIMESTAMP
TibDateTime
Any JDBC data types not listed above are not supported by the ActiveSpaces JDBC driver.
A table defined in ActiveSpaces has the data types of its columns mapped to the following JDBC data types when using the JDBC driver:
