JDBC Data Types
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 |
ActiveSpaces JDBC driver supports only the JDBC data types that are listed in the table.
A table defined in ActiveSpaces has the data types of its columns mapped to the following JDBC data types when using the JDBC driver:
| ActiveSpaces Data Type | JDBC Data Type |
|---|---|
| string | VARCHAR |
| long | BIGINT |
| double | DOUBLE |
| opaque | VARBINARY |
| TibDateTime | TIMESTAMP |