Open topic with navigation

TIBCO ActiveSpaces® - Enterprise Edition 5.0.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

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

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO ActiveSpaces® - Enterprise Edition

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