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

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.)❍
●
SQLMPBlob
An 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
An 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 different
components of a remote application. For example, an SQLMPCachedRowSet can be used to send the result of a query
executed by an Enterprise JavaBeans component running in a server environment to a client running in a web browser.
The SQL/MP drivers support the following methods of the SQLMPCachedRowSet interface:
addRowSetListener(RowSetListener
listener)
setClob(int i, java.sql.Clob x)
clearParameters() setCommand(java.lang.String cmd)
execute() setConcurrency(int concurrency)
getCommand() setDataSourceName(java.lang.String name)
getDataSourceName() setDate(int parameterIndex,
java.sql.Date x)
setDate(int parameterIndex,
java.sql.Date x,,
java.util.Calendar cal)
getEscapeProcessing() setDouble(int parameterIndex, double x)