Open topic with navigation

TIBCO ActiveSpaces® 4.8.0

# 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

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:

ActiveSpaces Data Type | JDBC Data Type
--- | ---
string | VARCHAR
long | BIGINT
double | DOUBLE
opaque | VARBINARY
TibDateTime | TIMESTAMP

Copyright © 2009-2022. Cloud Software Group, Inc. All Rights Reserved.