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

PreparedStatement object. The sets of parameter values together with the update command can be sent to the underlying

DBMS for execution as a single unit.

If an error occurs during a batch update, a BatchUpDateException is thrown. The getUpdateCounts() method can

be called to return an integer array of update counts for the commands in the batch that were executed successfully.

Advanced SQL Data Types

The JDBC 2.0 API provides support for storing persistent Java objects and a mapping for SQL3 data types such as Binary

Large OBjects and structured types. It also provides support for customized mapping of SQL3 structured types into Java

language classes.

Persistent Java Objects

Because SQL/MP does not support storing Java objects, NonStop

Server for Java does not support storing and retrieving

Java objects from a database.

SQL3 Data Types

The next version of the ANSI/ISO SQL standard is commonly referred to as SQL3. The JDBC 2.0 API incorporates a model of

the new SQL3 types. The SQL/MP drivers support the familiar "column" data types, such as CHAR and FLOAT, plus the new

types BLOB, a Binary Large Object, and CLOB, a Character Large Object.

The SQL/MP drivers do not support the following data types:

Structured types●

Distinct types●

Constructed types based on a given base type●

Locator types, which designate a datum that resides in the server●

Customized SQL Types

The JDBC 2.0 API provides support for customizing the mapping of SQL3 structured and distinct types into Java classes.

NonStop

Server for Java does not support customized SQL types, so methods of the following classes throw an exception

stating that the method is unsupported:

SQLData●

SQLInput●

SQLOutput●

Unsupported SQL3 Items

The following methods for various classes and objects are not supported because they use SQL3 data types:

Array.getArray●

Array.getBaseType●

Array.getBaseTypeName●

Array.getResultSet●

Connection.setTypeMap●

PreparedStatement.setArray●

PreparedStatement.setRef●

Ref.getBaseTypeName●

ResultSet.getArray●

ResultSet.getObject(...,Map map)●

ResultSet.getRef●

Struct.getAttributes●

Sruct.getSQLTypeName●