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

setQueryTimeout(int seconds)●
setReadOnly(boolean value)●
setShort(int parameterIndex, short x)●
setString(int parameterIndex, java.langString x)●
setTimestamp(int parameterIndex, java.sql.Timestamp x)
setTimestamp(int parameterIndex, java.sql.Timestamp x,, java.util.Calendar
cal)
●
setTransactionIsolation(int level)●
setType(int type)●
setUrl(java.lang.String url)●
setUserName(java.lang.String name)●
The following CachedRowSet methods are not supported:
setArray(int i, java.sql.Array x)●
setEscapeProcessing(boolean enable)●
setNull(int paramIndex, int sqlType, java.lang.String typeName)●
setRef(int i, java.sql.Ref x)●
setTypeMap(java.util.Map map)●
SQLMPClob
An SQLMPClob is a transaction duration reference to a CLOB (Character Large OBject). This means that a
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()●