JDBC Type 4 Driver Programmer's Reference for SQL/MX Release 3.2.1

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
Demonstrates that a J2EE application built to work with a database like Oracle
can work with NonStop SQL/MX by just reconfiguring the application in BEA
WLS_MedRecSample
WebLogic Server. No coding changes or recompilation are required to switch
to NonStop SQL/MX from a different relational database management system
(RDBMS).(2)
Demonstrates that a connected pooling, particularly the number physical
connections created does not exceed the maximum number of physical
connections configured in BEA WebLogicServer 8.1.(2)
WLS_TwoPhaseandPoolingSample
Demonstrates that a Type 4 driver can be configured as a XA driver exhibiting
two-phase commit with BEA WebLogic Server 8.1. The Type 4 driver can
participate in a two-phase commit
WLS_TwoPhaseSample
NOTE:
1. Creates, populates, and drops sample SQL/MX tables.
2. The sample’s documentation explains how to create the SQL/MX tables.
For information on these samples, see the README file provided with the Type 4 driver software
under the samples directory.
Samples 15