Neoview JDBC Type 4 Driver Programmer's Reference (R2.2, R2.3, R2.4, R2.5)

DOUBLE PRECISIONYes
Types.DOUBLE
FLOAT(p)Yes
Types.FLOAT
INTEGERYes
Types.INTEGER
N. A.No
Types.JAVA_OBJECT
VARCHAR(n)¹Data type is mapped by Neoview SQL. Data type
varies from that used for table creation.
Types.LONGVARBINARY
VARCHAR[(n)]Yes
Maximum length is 4018.
Types.LONGVARCHAR
N. A.No
Types.NULL
NUMERIC(p,s)Yes
Types.NUMERIC
FLOAT(p)Yes
Types.REAL
N. A.No
Types.REF
SMALLINTYes
Types.SMALLINT
N. A.No
Types.STRUCT
TIMEYes
Types.TIME
TIMESTAMPYes
Types.TIMESTAMP
SMALLINTData type is mapped by Neoview SQL. Data type
varies from that used for table creation.
Types.TINYINT
VARCHAR(n)¹Data type is mapped by Neoview SQL. Data type
varies from that used for table creation.
Types.VARBINARY
VARCHAR(n)Yes
Types.VARCHAR
CHAR(1)Data type is mapped by Neoview SQL. Data type
varies from that used for table creation.
Types.BOOLEAN
N. A.No
Types.DATALINK
¹ Because of mapping provided by Neoview SQL, 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:
Neoview SQL Data Type
INTERVAL YEAR(p)
INTERVAL YEAR(p) TO MONTH
INTERVAL MONTH(p)
INTERVAL DAY(p)
INTERVAL DAY(p) TO HOUR
INTERVAL DAY(p) TO MINUTE
INTERVAL DAY(p) TO SECOND
INTERVAL HOUR(p)
INTERVAL HOUR(p) TO MINUTE
INTERVAL HOUR(p) TO SECOND
INTERVAL MINUTE(p)
70 Type 4 Driver Compliance