Show TOC

Type Conversions Supported by ResultSet Getter MethodsLocate this document in the navigation structure

Use

The java.sql.ResultSet interface provides getter methods for retrieving column values from the row where the cursor is currently positioned. The method names follow the pattern "get<Type>". The recommended getter methods for each supported JDBC type is shown in the following Table (upper-case X). The table also shows all possible type conversions that Open SQL for Java supports (lower-case x). The invocation of a non-supported (that is, not marked) getter method causes an SQL exception.

Type/get<Type>()

Object

String

Boolean

Bytes

Byte

Short

Int

Long

Float

Double

BigDecimal

Date

Time

Timestamp

CharacterStream

BinaryStream

Clob

Blob

VARCHAR

x

X

x

LONGVARCHAR

x

X

x

CLOB

x

x

x

X

BINARY

x

X

x

LONGVARBINARY

x

X

x

BLOB

x

x

x

X

SMALLINT

x

X

x

x

x

x

x

INTEGER

x

X

x

x

x

x

BIGINT

x

X

x

x

x

REAL

x

X

x

x

DOUBLE

x

X

x

DECIMAL(P[,S])

x

X

DATE

x

X

TIME

x

X

TIMESTAMP

x

X