|
TINYINT |
SMALLINT |
INTEGER |
BIGINT |
REAL |
FLOAT |
DOUBLE |
DECIMAL |
NUMERIC |
BIT |
CHAR |
VARCHAR |
LONGVARCHAR |
BINARY |
VARBINARY |
LONGVARBINARY |
DATE |
TIME |
TIMESTAMP |
CLOB |
BLOB |
ARRAY |
REF |
STRUCT |
JAVA OBJECT |
getByte |
y |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
|
|
|
|
|
|
|
|
|
|
|
|
getShort |
x |
y |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
|
|
|
|
|
|
|
|
|
|
|
|
getInt |
x |
x |
y |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
|
|
|
|
|
|
|
|
|
|
|
|
getLong |
x |
x |
x |
y |
x |
x |
x |
x |
x |
x |
x |
x |
x |
|
|
|
|
|
|
|
|
|
|
|
|
getFloat |
x |
x |
x |
x |
y |
x |
x |
x |
x |
x |
x |
x |
x |
|
|
|
|
|
|
|
|
|
|
|
|
getDouble |
x |
x |
x |
x |
x |
y |
y |
x |
x |
x |
x |
x |
x |
|
|
|
|
|
|
|
|
|
|
|
|
getBigDecimal |
x |
x |
x |
x |
x |
x |
x |
y |
y |
x |
x |
x |
x |
|
|
|
|
|
|
|
|
|
|
|
|
getBoolean |
x |
x |
x |
x |
x |
x |
x |
x |
x |
y |
x |
x |
x |
|
|
|
|
|
|
|
|
|
|
|
|
getString |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
y |
y |
x |
x |
x |
x |
x |
x |
x |
|
|
|
|
|
|
getBytes |
|
|
|
|
|
|
|
|
|
|
|
|
|
y |
y |
x |
|
|
|
|
|
|
|
|
|
getDate |
|
|
|
|
|
|
|
|
|
|
x |
x |
x |
|
|
|
y |
|
x |
|
|
|
|
|
|
getTime |
|
|
|
|
|
|
|
|
|
|
x |
x |
x |
|
|
|
|
y |
x |
|
|
|
|
|
|
getTimestamp |
|
|
|
|
|
|
|
|
|
|
x |
x |
x |
|
|
|
x |
x |
y |
|
|
|
|
|
|
getAsciiStream |
|
|
|
|
|
|
|
|
|
|
x |
x |
y |
x |
x |
x |
|
|
|
|
|
|
|
|
|
getBinaryStream |
|
|
|
|
|
|
|
|
|
|
|
|
|
x |
x |
y |
|
|
|
|
|
|
|
|
|
getCharacterStream |
|
|
|
|
|
|
|
|
|
|
x |
x |
y |
x |
x |
x |
|
|
|
|
|
|
|
|
|
getClob |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
y |
|
|
|
|
|
getBlob |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
y |
|
|
|
|
getArray |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
y |
|
|
|
getRef |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
y |
|
|
getObject |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
y |
y |