JDBC Type 2 Driver 3.0 Programmer's Reference (SQL/MX 3.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 Oracle
(http://java.sun.com/developer/earlyAccess/jdbc/jdbc-
rowset.html).
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
The JdbcRowSet API methods are supported except
for these that throw an
Unsupported feature -
method-name
SQLMXException.