Informix JDBC Driver Programmer's Guide

Informix JDBC Driver Programmer's Guide
Chapter 2: Programming with Informix JDBC Driver

Contents Index

JDBC API Data Types from java.sql.Types

getXXX() Method JDBC API Data Types from java.sql.Types
TINYINT SMALLINT INTEGER BIGINT REAL FLOAT DOUBLE DECIMAL NUMERIC BIT CHAR VARCHAR LONGVARCHAR BINARY VARBINARY LONGVARBINARY DATE TIME TIMESTAMP
getByte()
X

x

x

x

x

x

x

x

x

x¹

x¹

getShort()
x

X

x

x

x

x

x

x

x

x¹

x¹

getInt()
x

x

X

x

x

x

x

x

x

x¹

x¹

getLong()
x

x

x

X

x

x

x

x

x

x¹

x¹

getFloat()
x

x

x

x

X

x

x

x

x

x¹

x¹

getDouble()
x

x

x

x

x

X

X

x

x

x¹

x¹

getBigDecimal()
x

x

x

x

x

x

x

X

X

x

x

getBoolean()
x

x

x

x

x

x

x

x

x

x

x

getString()
x

x

x

x

x

x

x

x

x

X

X

x

x

x

x

x

x

x

getBytes()

x

X

X

x

getDate()

x

x

X

x

getTime()

x

x

X

x

getTimestamp()

x

x

x

X

getAsciiStream()

X

x

x

x

getUnicodeStream()

getBinaryStream()

x

x

x

X

getObject()
x

x

x

x

x

x

x

x

x

x

x

x²

x

x

x²

x

x³

x

Notes:
¹ The column value must match the type of getXXX() exactly, or an SQLException is raised. If the column value is not within the allowed value range, the getXXX() method raises an exception instead of converting the data type. For example, getByte(1) raises an SQLException if the column value is `1000`.
² A byte array is returned.
³ A Timestamp object is returned instead of a Time object.

The getXXX() methods return a null value if the retrieved column value is an SQL null value.

Informix JDBC Driver Programmer's Guide, Version 1.22
Copyright © 1998, Informix Software, Inc. All rights reserved.