JDBC/MX 5.0 Driver for SQL/MX Programmer's Reference (SQL/MX 2.x)

Types.BLOB
Yes
Types.CHAR
Yes
CHAR(n)
Types.CLOB
Yes
Types.DATE
Yes
DATE
Types.DECIMAL
Yes
DECIMAL(p,s)
Types.DISTINCT
No
Types.DOUBLE
(*)
Yes
DOUBLE PRECISION
Types.FLOAT
(*)
Yes
FLOAT(p)
Types.INTEGER
Yes
INTEGER
Types.JAVA_OBJECT
No
Types.LONGVARBINARY
No
Types.LONGVARCHAR
Yes**
VARCHAR[(n)]
Types.NULL
No
Types.NUMERIC
Yes
NUMERIC(p,s)
Types.REAL
Yes
FLOAT(p)
Types.REF
No
Types.SMALLINT
Yes
SMALLINT
Types.STRUCT
No
Types.TIME
Yes
TIME
Types.TIMESTAMP
Yes
TIMESTAMP
Types.TINYINT
No
Types.VARBINARY
No
Types.VARCHAR
Yes
VARCHAR(n)
* See Floating Point Support.
** For details about maximum length, see the SQL/MX Reference Manual.
The JDBC/MX driver maps the following SQL/MX data types to the JDBC data type Types.OTHER:
DATETIME YEAR
DATETIME YEAR TO MONTH
DATETIME YEAR TO DAY
DATETIME YEAR TO HOUR