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

SQLMPStatement
SQLMPStatement executes a static SQL/MP statement and obtains the results of the statement.
The SQL/MP drivers support the following SQLMPStatement methods:
addBatch(String sql)●
clearBatch()●
clearWarnings()●
close()●
execute()●
executeBatch()●
executeQuery(String)●
executeUpdate(String)●
getConnection()●
getFetchDirection()●
getFetchSize()●
getMaxFieldSize()●
getMoreResults()●
getResultSet()●
getResultSetConcurrency()●
getResultSetType()●
getUpdateCount()●
getWarnings()●
setCursorName()●
setFetchDirection(int direction)●
setFetchSize(int rows)●
setMaxFieldSize()●
The SQL/MP drivers do not support the following SQLMPStatement methods:
cancel()●
getMaxRows()●
setEscapeProcessing()●
setMaxRows()●
setQueryTimeout()●
Transactions and JDBC
The original SQL/MP driver can connect to an SQL/MP database using either autocommit mode or nonautocommit
mode. The transaction-aware SQL/MP driver must connect to an SQL/MP database using nonautocommit mode; trying
to connect the transaction-aware driver to a database using autocommit mode will cause an exception.
In both modes, the driver calls the Transaction Management Facility (TMF) procedures for each transaction. You
cannot call these TMF procedures directly. The TMF procedures that the drivers call are BEGINTRANSACTION,
ENDTRANSACTION, and ABORTTRANSACTION.
Each connection to an SQL/MP database has a unique TMF transaction identifier (Transid); therefore, if a connection
commits or rolls back a transaction, other connections are not affected.