SQL Data Types Mapping

This chapter provides information about how data is mapped between SQL and Java Stored Procedure parameters.

SQL Data Types Mapping Table

The following table defines how data is mapped between SQL and Java Stored Procedure parameters. The SQL data type is converted to or converted from corresponding Java data type, based on the type of parameter mapping. Simple mapping is the default. Use the External Name clause to specify object mapping.

SQL Data Type

IN Parameter

OUT Parameter

INOUT Parameter

Simple Map

Object Map

Simple Map

Object Map

Simple Map

Object Map

CHARACTER

–

java.lang.String

–

java.lang.String[]

–

java.lang.String[]

VARCHAR

–

java.lang.String

–

java.lang.String[]

–

java.lang.String[]

NUMERIC

–

java.math.BigDecimal

–

java.math.BigDecimal[]

–

java.math.BigDecimal[]

DECIMAL

–

java.math.BigDecimal

–

java.math.BigDecimal[]

–

java.math.BigDecimal[]

BIGINT

long

java.lang.Long

long[]

java.lang.Long[]

long[]

java.lang.Long[]

SMALLINT

short

java.lang.Short

short[]

java.lang.Short[]

short[]

java.lang.Short[]

INTEGER

int

java.lang.Integer

int[]

java.lang.Integer[]

int[]

java.lang.Integer[]

REAL

double

java.lang.Double

double[]

java.lang.Double[]

double[]

java.lang.Double[]

FLOAT

double

java.lang.Double

double[]

java.lang.Double[]

double[]

java.lang.Double[]

DOUBLE PRECISION

double

java.lang.Double

double[]

java.lang.Double[]

double[]

java.lang.Double[]

BYTE

byte[]

–

byte[][]

–

byte[][]

–

VARBYTE

byte[]

–

byte[][]

–

byte[][]

–

DATE

–

java.sql.Date

–

java.sql.Date[]

–

java.sql.Date[]

TIME

–

java.sql.Time

–

java.sql.Time[]

–

java.sql.Time[]

TIMESTAMP

–

java.sql.Timestamp

–

java.sql.Timestamp[]

–

java.sql.Timestamp[]

BYTEINT

byte

java.lang.Byte

byte[]

java.lang.Byte[]

byte[]

java.lang.Byte[]

CLOB

–

java.sql.Clob

–

java.sql.Clob[]

–

java.sql.Clob[]

BLOB

–

java.sql.Blob

–

java.sql.Blob[]

–

java.sql.Blob[]

INTERVAL

–

java.lang.String

–

java.lang.String[]

–

java.lang.String[]

GRAPHIC and VARGRAPHIC data types are not supported for Java Stored Procedure parameters.