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

The following methods in the java.sql package throw an SQLException with the message "Data type not supported:"
Method Comments
CallableStatement.getBytes(int parameterIndex)
CallableStatement.getBytes(String parameterName)
The particular data type is not
supported.
CallableStatement.setBytes(String parameterIndex,
bytes[] x)
Supports only BLOB, VARCHAR,
BINARY, LONGVARCHAR,
VARBINARY, and
LONGVARBINARY; otherwise, the
particular data type is not supported.
PreparedStatement.setBytes(int ColumnIndex, bytes[]
x)
Supports only BLOB, CHAR, DATE,
TIME, TIMESTAMP, VARCHAR,
BINARY, LONGVARCHAR,
VARBINARY, and
LONGVARBINARY; otherwise, the
particular data type is not supported.
PreparedStatement.setObject(int parameterIndex,
Object x int targetSqlType)
PreparedStatement.setString(int parameterIndex,
String x)
Does not support the ARRAY,
BINARY, BIT, DATALINK,
JAVA_OBJECT, and REF types.
ResultSet.getBytes(int ColumnIndex)
ResultSet.getBytes(String ColumnName)
Supports only BLOB, CHAR,
VARCHAR, BINARY,
LONGVARCHAR, VARBINARY, and
LONGVARBINARY; otherwise, the
particular data type is not supported.
The following optional interfaces in the javax.sql package are not implemented in the JDBC/MX driver:
Method Comments
javax.sql.XAConnection
javax.sql.XADataSource
Distributed Transactions, as described in the JDBC 3.0
API specification, are not yet implemented.
javax.sql.RowSet
javax.sql.RowSetInternal
javax.sql.RowSetListener
javax.sql.RowSetMetaData
javax.sql.RowSetReader
javax.sql.RowSetWriter
RowSet
is not implemented in the JDBC/MX driver. You
can, however, download reference implementation of
RowSet from Sun Microsystems
(http://developer.java.sun.com/developer/earlyAccess/crs/).
javax.sql.JdbcRowSet.getArray(int
columnIndex)
javax.sql.JdbcRowSet.getArray(String
columnName)
javax.sql.JdbcRowSet.getObject(int
columnIndex, Map map)
javax.sql.JdbcRowSet.getObject(String
columnName, Map map)
javax.sql.JdbcRowSet.getRef(int
columnIndex)
javax.sql.JdbcRowSet.getRef(String
columnName)
javax.sql.JdbcRowSet.getURL(int
columnIndex)
The JdbcRowSet API methods are supported except for
these that throw an Unsupported feature - method-
name
SQLMXException.