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