JDBC Type 4 Driver Programmer's Reference for SQL/MX Release 3.1 (H06.23+, J06.12+)

Type 4 driver, through the MXCS Service, Accesses an SQL/MX Database
Samples
The following samples are provided with the Type 4 driver.
Sample
Description
CallableStatementSample Demonstrates the invocation of a stored procedure in Java (SPJ).(1)
DBMetaSample Gets metadata from a table by using the Connection interface and ResultSetMetaData
interface. The information retrieved includes Type, (of what getTypeInfo()), catalogs, tables,
procedures, columns, columns, column count on tables, and so forth.(1)
PreparedStatementSample
Using the PreparedStatement interface, performs a select all and parameterized select for
data type of CHAR, INT, TIMESTAMP, DECIMAL, NUMERIC, and DATE.(1)
ResultSetSample
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)
SQLMPSample
Executes a simple select statement on an SQL/MP table, 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. (Access an existing
SQL/MP table through the SQL/MX engine.)
StatementSample
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)
Demonstrates that a J2EE application built to work with a database like Oracle can work with