JDBC Type 2 Driver 3.0 Programmer's Reference (SQL/MX 3.x)

run concurrently. This program displays the thread ID and status of the

SQL operation before and after each operation. When the program runs

in blocking mode, you observe only one thread switch because the

begin-transaction operation starts a transaction in SQL nowait mode.

When the program runs in nonblocking mode, you can observe many

thread switches.

holdJdbcMx.java

Illustrates the holdable cursor support in the JDBC/MX driver. The

program creates a subscriber thread that subscribes to a message queue.

When all the rows in the message queue are read, the subscriber times

out after five seconds.

TestConnectionPool.java

Demonstrates the benefits of connection pooling and statement pooling.

This program performs a loop for a 100 times that makes a JDBC

connection, runs a few SQL statements, and closes the connection. You

use the OSS time() command to measure the performance benefits of

connection pooling and statement pooling in this program.

CreateTraceDS.java

TestTraceDS.java

Demonstrates tracing by creating a wrapper around the driver-specific

data source to be traced. These demonstration programs are located in

the /demo directory of the product installation directory.

JdbcRowSetSample.java

Demonstrates how to create an SQLMXJdbcRowSet object and invoke

several JdbcRowSet methods.

LobSample.java

Demonstrates the LOB feature in the JDBC/MX driver.

TransactionMode.java

Demonstrates internal, external, and mixed transaction modes.

ISO88591Sample.java

Demonstrates the ISO88591 property.

For information on running these sample programs, see the README file provided with the JDBC/MX driver

software.

HP JDBC/MX 5.0 Driver for SQL/MX Programmer's Reference (640330-002)