JDBC to Proficy Portal Data Type Mappings

The following table maps data types for JDBC to Proficy Portal data conversion.

JDBC to Proficy Portal Data Type Mappings 

JDBC Type

Java Type

Proficy Portal Type

BOOLEAN

boolean

IA_BOOLEAN

BIT

byte

IA_BIT

TINYINT

byte

IA_BYTE

SMALLINT

short

IA_SHORT

INTEGER

int

IA_INTEGER

DOUBLE

double

IA_DOUBLE

FLOAT

double

IA_DOUBLE

REAL

float

IA_FLOAT

BIGINT

long

IA_LONG

CHAR

String

IA_STRING

VARCHAR

String

IA_STRING

LONGVARCHAR

String

IA_STRING

NULL

N/A

IA_NULL

DATE

java.util.Date

IA_DATE (Oracle)

DATE

java.sql.Date

IA_DATE_ONLY
(not Oracle)

TIME

java.sql.Time

IA_TIMEONLY
(not Oracle)

TIMESTAMP

java.sql.Timestamp

IA_TIMESTAMP

NUMERIC

BigDecimal

IA_BIGDECIMAL

DECIMAL

BigDecimal

IA_BIGDECIMAL

BINARY

Unsupported

IA_NOT_SUPPORTED

VARBINARY

Unsupported

IA_NOT_SUPPORTED

LONGVARBINARY

Unsupported

IA_NOT_SUPPORTED

OTHERA

Unsupported

IA_NOT_SUPPORTED

JAVA_OBJECT

Unsupported

IA_NOT_SUPPORTED

DISTINCT

Unsupported

IA_NOT_SUPPORTED

STRUCT

Unsupported

IA_NOT_SUPPORTED

ARRAY

Unsupported

IA_NOT_SUPPORTED

BLOB

Unsupported

IA_NOT_SUPPORTED

CLOB

Unsupported

IA_NOT_SUPPORTED

REF

Unsupported

IA_NOT_SUPPORTED

DATALINK

Unsupported

IA_NOT_SUPPORTED

See Also

Relational Data Type Mappings