JDBC Type 4 Driver 1.1 Programmer's Reference

Types.DATE
Yes DATE
Types.DECIMAL
Yes DECIMAL(p,s)
Types.DISTINCT
No N.A.
Types.DOUBLE
Yes DOUBLE PRECISION
Types.FLOAT
Yes FLOAT(p)
Types.INTEGER
Yes INTEGER
Types.JAVA_OBJECT
No N.A.
Types.LONGVARBINARY
Data type is mapped by SQL/MX . Data type varies from that used for table creation. VARCHAR(n)¹
Types.LONGVARCHAR
Yes
Maximum length is 4018
VARCHAR[(n)]
Types.NULL
No N.A.
Types.NUMERIC
Yes NUMERIC(p,s)
Types.REAL
Yes FLOAT(p)
Types.REF
No N.A.
Types.SMALLINT
Yes SMALLINT
Types.STRUCT
No N.A.
Types.TIME
Yes TIME
Types.TIMESTAMP
Yes TIMESTAMP
Types.TINYINT
Data type is mapped by SQL/MX . Data type varies from that used for table creation. SMALLINT
Types.VARBINARY
Data type is mapped by SQL/MX . Data type varies from that used for table creation. VARCHAR(n)¹
Types.VARCHAR
Yes VARCHAR(n)
Types.BOOLEAN
Data type is mapped by SQL/MX . Data type varies from that used for table creation. CHAR(1)
Types.DATALINK
No N.A.
¹ Because of mapping provided by SQL/MX, a ResultSet.getObject() method returns a string object instead of an array of bytes.
The Type 4 driver maps the following data types to the JDBC data type Types.OTHER:
SQL/MX Data Type SQL/MP Data Type
INTERVAL YEAR(p) DATETIME YEAR
INTERVAL YEAR(p) TO MONTH DATETIME YEAR TO MONTH
INTERVAL MONTH(p) DATETIME YEAR TO HOUR
INTERVAL DAY(p) DATETIME YEAR TO MINUTE
INTERVAL DAY(p) TO HOUR DATETIME MONTH
INTERVAL DAY(p) TO MINUTE DATETIME MONTH TO DAY
INTERVAL DAY(p) TO SECOND DATETIME MONTH TO HOUR
INTERVAL HOUR(p) DATETIME MONTH TO SECOND
INTERVAL HOUR(p) TO MINUTE DATETIME DAY
INTERVAL HOUR(p) TO SECOND DATETIME DAY TO HOUR
INTERVAL MINUTE(p) DATETIME DAY TO MINUTE
INTERVAL MINUTE(p) TO SECOND DATETIME DAY TO SECOND
INTERVAL SECOND(p) DATETIME HOUR