JDBC Type 4 Driver Programmer's Reference for SQL/MX Release 3.2.1

SQL/MX Data TypeSupport by JDBC Type 4 Driver for NonStop SQL/MXJDBC Data Type
LARGEINTYesTypes.CLOB
DATEYesTypes.DATE
DECIMAL(p,s)YesTypes.DECIMAL
N.A.NoTypes.DISTINCT
DOUBLE PRECISIONYesTypes.DOUBLE
FLOAT(p)YesTypes.FLOAT
INTEGERYesTypes.INTEGER
N.A.NoTypes.JAVA_OBJECT
VARCHAR(n)¹Data type is mapped by SQL/MX . Data type varies
from that used for table creation.
Types.LONGVARBINARY
VARCHAR[(n)]Yes
Maximum length is 4018
Types.LONGVARCHAR
N.A.NoTypes.NULL
NUMERIC(p,s)YesTypes.NUMERIC
FLOAT(p)YesTypes.REAL
N.A.NoTypes.REF
SMALLINTYesTypes.SMALLINT
N.A.NoTypes.STRUCT
TIMEYesTypes.TIME
TIMESTAMPYesTypes.TIMESTAMP
SMALLINTData type is mapped by SQL/MX . Data type varies
from that used for table creation.
Types.TINYINT
VARCHAR(n)¹Data type is mapped by SQL/MX . Data type varies
from that used for table creation.
Types.VARBINARY
VARCHAR(n)YesTypes.VARCHAR
CHAR(1)Data type is mapped by SQL/MX . Data type varies
from that used for table creation.
Types.BOOLEAN
N.A.NoTypes.DATALINK
¹ 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/MP Data TypeSQL/MX Data Type
DATETIME YEARINTERVAL YEAR(p)
DATETIME YEAR TO MONTHINTERVAL YEAR(p) TO MONTH
DATETIME YEAR TO HOURINTERVAL MONTH(p)
DATETIME YEAR TO MINUTEINTERVAL DAY(p)
DATETIME MONTHINTERVAL DAY(p) TO HOUR
DATETIME MONTH TO DAYINTERVAL DAY(p) TO MINUTE
78 Type 4 Driver Compliance