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

SQLMPClob
An SQLMPClob is a transaction duration reference to a CLOB (Character Large OBject). This means that an SQLMPClob
object is valid for the duration of the transaction in which it was created. The SQLMPClob class provides methods for getting
the length of an SQLMPClob value, for materializing a CLOB value on the client, and for searching for a substring or CLOB
object within a CLOB value. Methods in the interfaces ResultSet and PreparedStatement, such as getClob and
setClob, allow you to access an SQLMPClob. Because SQL/MP does not support a Clob data type, JDBC has provided a
work-around to allow you to create and retrieve CLOBs.
The SQL/MP drivers support the following methods of the SQLMPClob class:
getAsciiStream()●
getCharacterStream()●
getSubString(long pos, int length)●
length()●
position(Clob searchstr, long start)●
SQLMPConnection
SQLMPConnection represents a session or connection to an SQL/MP database. Within this session, a program or servlet can
execute SQL/MP statements and obtain the results.
The SQL/MP drivers support the following SQLMPConnection methods:
clearWarnings()●
close()●
commit()●
createStatement()
createStatement(int resultSetType, int resultSetConcurrency)
●
getCatalog()●
getAutoCommit()●
getMetaData()●
getTransactionIsolation(), which always returns TRANSACTION_READ_COMMITTED●
getWarnings()●
isClosed()●
isReadOnly()●
nativeSQL()●
nativeSQL(String str), which returns a translated statement; that is, any long-name macros in the original
statement are translated to the appropriate Guardian names
●
prepareStatement(String)
prepareStatement(String sql, int resultSetType, int resultSetConcurrency)
●
rollback()●
setAutoCommit(boolean)●
setCatalog()●
setCatalog(String str), which can accept a long-name macro indicating the catalog to select●
The SQL/MP drivers do not support the following SQLMPConnection methods:
prepareCall()●
setReadOnly()●
setTransactionIsolation(int)●
The transaction-aware driver throws an SQLMPException if any of the following methods are called:
commit()●
rollback()●