JDBC Type 4 Driver Programmer's Reference

A method used to modify a data item. For example, the

Connection.setAutoCommit() method changes the transaction mode of the

JDBC driver's connection to an SQL/MX database. Compare to get() method.

SQL context

An instantiation of the SQL executor with its own environment.

SQLJ

Also referred to as SQLJ Part 0, the "Database Language SQL—Part 10: Object

Language Bindings (SQL/OLB)" part of the ANSI SQL-2002 standard that allows static

SQL statements to be embedded directly in a Java program.

SQL/MP

See HP NonStop SQL/MP.

SQL/MX

See HP NonStop SQL/MX.

statement pooling

A framework for pooling PreparedStatement objects.

stored procedure

A procedure registered with SQL/MX and invoked by SQL/MX during execution of a

CALL statement. Stored procedures are especially important for client/server database

systems because storing the procedure on the server side means that it is available to all

clients. And when the procedure is modified, all clients automatically get the new

version.

stored procedure in Java (SPJ)

A stored procedure whose body is a static Java method.

stub

One of the following:

A dummy procedure used when linking a program with a run-time library. The

stub need not contain any code. Its only purpose is to prevent "undefined label"

errors at link time.

❍

A local procedure in a remote procedure call (RPC). A client calls the stub to

perform a task, not necessarily aware that the RPC is involved. The stub transmits

parameters over the network to the server and returns results to the caller.

❍

thread

A task that is separately dispatched and that represents a sequential flow of control within

a process.

threads