CData Virtuality Server ランタイムタイプ

Type

Description

Java Runtime Class

JDBC Type

ODBC Type

string or varchar

Variable length character string with a maximum length of 4000

java.lang.String

VARCHAR

VARCHAR

varbinary

Variable length binary string with a maximum length of 8192

byte[]

VARBINARY

VARBINARY

char

A single Unicode character

java.lang.Character

CHAR

CHAR

boolean

A single bit, or boolean, that can be TRUE, FALSE, or NULL (unknown)

java.lang.Boolean

BIT

SMALLINT

byte or tinyint

Numeric, integral type, signed 8-bit

java.lang.Byte

TINYINT

SMALLINT

short or smallint

Numeric, integral type, signed 16-bit

java.lang.Short

SMALLINT

SMALLINT

integer or serial

Numeric, integral type, signed 32-bit. The serial type also implies not null and has an auto-incrementing value that starts at 1. serial types are not automatically UNIQUE

java.lang.Integer

INTEGER

INTEGER

long or bigint

Numeric, integral type, signed 64-bit

java.lang.Long

BIGINT

NUMERIC

biginteger

Numeric, integral type, arbitrary precision of up to 1000 digits

java.lang.BigInteger

NUMERIC

NUMERIC

float or real

Numeric, floating point type, 32-bit IEEE 754 floating-point numbers

java.lang.Float

REAL

FLOAT

double

Numeric, floating point type, 64-bit IEEE 754 floating-point numbers

java.lang.Double

DOUBLE

DOUBLE

bigdecimal or decimal

Numeric, floating point type, arbitrary precision of up to 1000 digits. Note that the precision and scale cannot be explicitly set with the type literal, e.g. decimal(38, 2)

java.math.BigDecimal

NUMERIC

NUMERIC

date

Datetime, representing a single day (year, month, day)

java.sql.Date

DATE

DATE

time

Datetime, representing a single time (hours, minutes, seconds, milliseconds)

java.sql.Time

TIME

TIME

timestamp

Datetime, representing a single date and time (year, month, day, hours, minutes, seconds, milliseconds, nanoseconds)

java.sql.Timestamp

TIMESTAMP

TIMESTAMP

object

Any arbitrary Java object, must implement java.lang.Serializable

Any

JAVA_OBJECT

VARCHAR

blob

Binary large object, representing a stream of bytes

java.sql.Blob

BLOB

VARCHAR

clob

Character large object, representing a stream of characters

java.sql.Clob

CLOB

VARCHAR

xml

XML document

java.sql.SQLXML

JAVA_OBJECT

VARCHAR