JDBC Driver for SQL/MP 3.0

ResultSet.updateArray(int columnIndex, java.sql.Array array)
ResultSet.updateRef(int columnIndex, java.sql.Ref ref)
ResultSet.updateRef(String columnName, java.sql.Ref ref)
These methods in the java.sql package throw an SQLException with the message "Auto generated keys not
supported":
Method Comments
Connection.prepareStatement(String sql, int
autoGeneratedKeys)
Connection.prepareStatement(String sql, int[]
columnIndexes)
Connection.prepareStatement(String sql, String[]
columnNames)
Connection.prepareStatement(String sql, int
resultSetType, int resultSetConcurrency, int
holdability)
Automatically generated keys are
not supported.
Statement.execute(String sql, int autoGeneratedKeys)
Statement.execute(String sql, int[] columnIndexes)
Statement.execute(String sql, String[] columnNames)
Statement.executeUpdate(String sql, int
autoGeneratedKeys)
Statement.executeUpdate(String sql, int[]
columnIndexes)
Statement.executeUpdate(String sql, String[]
columnNames)
Automatically generated keys are
not supported.
These methods in the java.sql package throw an SQLException with the message "SQL/MP: method-name Data type
not supported":
Method Comments
PreparedStatement.setArray(int i, Array x)
PreparedStatement.setBytes(int ColumnIndex, bytes[] x)
PreparedStatement.setRef(int i, Ref x)
The particular data type is not
supported.
Compliance Information
The JDBC/MP driver is not considered JDBC compliant for these reasons:
CallableStatement is not supported because SQL/MP does not support stored procedures. The
CallableStatement class exists, but every method in the class throws an "unsupported method" exception.
Positioned update and delete operations are not supported because SQL/MP does not support these operations
from dynamic SQL (the underlying method the JDBC Driver for SQL/MP uses for accessing a database).
However, positioned update and delete operations can be performed from scrollable, insensitive result sets.
Multithreading is not completely supported because calling both executeQuery() and executeUpdates() causes
the entire JVM (not just the thread executing the SQL operation) to block.
Column aliasing is not supported because SQL/MP does not support column aliasing.
The ODBC minimum SQL grammar is not supported. Therefore, the JDBC Driver for SQL/MP does not support
these:
Numeric functions, string functions, system functions, or the convert function.
Escape syntax for time or date literals, LIKE escape characters, or escape characters for outer joins.
Because SQL/MP does not support stored procedures, escape syntax is not supported for stored
procedures.
The ANSI92 entry-level SQL grammar is not supported because SQL/MP does not conform to Entry Level SQL
as described in the ANSI and ISO/IEC standards for that topic.