JDBC Type 4 Driver Programmer's Reference for SQL/MX Release 3.2 (H06.25+, J06.14+)
Figure 1 Type 4 driver, through the MXCS Service, Accesses an SQL/MX Database
Samples
The following samples are provided with the Type 4 driver.
DescriptionSample
Demonstrates the invocation of a stored procedure in Java (SPJ).(1)CallableStatementSample
Gets metadata from a table by using the Connection interface and
ResultSetMetaDatainterface. The information retrieved includes Type, (of what
DBMetaSample
getTypeInfo()), catalogs, tables, procedures, columns, columns, column count
on tables, and so forth.(1)
Using the PreparedStatement interface, performs a select all and parameterized
select for data type of CHAR, INT, TIMESTAMP, DECIMAL, NUMERIC, and
DATE.(1)
PreparedStatementSample
Executes a simple select statement, metadata information about the result set
returned by the simple select statement, and finally, uses the result-set metadata
to print out each row returned by the simple select statement.(1)
ResultSetSample
Executes a simple select statement on an SQL/MP table, retrieves metadata
information about the result set returned by the simple select statement, and,
SQLMPSample
uses the result-set metadata to print out each row returned by the simple select
statement. (Access an existing SQL/MP table through the SQL/MX engine.)
Executes a simple select statement, retrieves metadata information about the
result set returned by the simple select statement, and uses the result-set
metadata to print out each row returned by the simple select statement.(1)
StatementSample
14 Introduction to HP NonStop JDBC Type 4 Driver










