NonStop Server for Java (NSJ) Programmer's Guide (NSJ 2.0+)

SQL/MP Support for JDBC
The SQL/MP drivers support the following subset of the JDBC API:
Exceptions
BatchUpdateException❍
SQLException❍
SQLWarning❍
The following methods are inherited from SQLException:
getErrorCode❍
getNextException❍
getSQLState❍
setNextException❍
●
Interfaces
Blob (see SQLMPBlob)❍
Clob (see SQLMPClob)❍
Connection (see SQLMPConnection)❍
DatabaseMetaData (see SQLMPDatabaseMetaData)❍
Driver (see SQLMPDriver)❍
PreparedStatement (see SQLMPPreparedStatement)❍
ResultSet (see SQLMPResultSet)❍
ResultSetMetaData (see SQLMPResultSetMetaData)❍
Statement (see SQLMPStatement)❍
●
The SQL/MP drivers do not support the following subset of the JDBC API:
DataTruncation exceptions●
CallableStatement interface (because SQL/MP does not support stored procedures)●
SQLMPBlob
A SQLMPBlob is a transaction duration reference to a BLOB (Binary Large OBject). Methods in the interfaces
ResultSet and PreparedStatement, such as getBlob and setBlob, allow you to access the SQLMPBlob.
The Blob interface provides methods for getting the length of a BLOB value, for materializing a BLOB value on the
client, and for determining the position of a pattern of bytes within a BLOB value. Because SQL/MP does not support a
Blob data type, JDBC has provided a work-around to allow you to create and retrieve BLOBs.
The SQL/MP drivers support the following methods of the SQLMPBlob class:
getBinaryStream()●
getBytes(long pos, int length)●
length()●
position(Blob pattern, long start)●
position(byte[] pattern, long start)●
SQLMPCachedRowSet
A SQLMPCachedRowSet is a disconnected, serializable, scrollable container for tabular data. The purpose of the
SQLMPCachedRowSet class is to provide a representation of a JDBC ResultSet that can be passed between