JDBC Type 2 Driver Programmer's Reference for SQL/MX Release 3.2.1 (H06.26+, J06.15+)

Contents
About this manual.........................................................................................7
New and changed information...................................................................................................7
Supported Release Version Updates (RVUs)..................................................................................7
Audience.................................................................................................................................7
Organization...........................................................................................................................7
Related documentation..............................................................................................................8
Notation conventions..............................................................................................................11
HP Encourages Your Comments................................................................................................12
Abbreviations.........................................................................................................................12
Publishing history....................................................................................................................14
1 Introduction to JDBC/MX Driver..................................................................15
JDBC/MX Architecture............................................................................................................15
JDBC API Packages.................................................................................................................16
Sample Programs Summary.....................................................................................................16
2 Installing and Verifying JDBC/MX...............................................................17
Installation Requirements..........................................................................................................17
Installing the JDBC/MX T2 Driver..............................................................................................17
JDBC/MX Driver File Locations.................................................................................................18
Verifying the JDBC/MX Driver..................................................................................................19
Setting CLASSPATH.................................................................................................................19
Setting the _RLD_LIB_PATH.......................................................................................................20
3 Accessing SQL Databases with SQL/MX.....................................................21
Connecting to SQL/MX...........................................................................................................21
Connecting Using the DriverManager Class..........................................................................21
Connecting Using the DataSource Interface...........................................................................23
JdbcRowSet Implementation.....................................................................................................25
JDBC/MX Properties...............................................................................................................25
Default Catalog and Schema...............................................................................................26
LOB Table Name Properties................................................................................................26
ISO88591 Property............................................................................................................27
mploc Property..................................................................................................................27
maxStatements Property......................................................................................................27
minPoolSize Property..........................................................................................................27
maxPoolSize Property.........................................................................................................28
initialPoolSize property.......................................................................................................28
maxIdletime property.........................................................................................................28
language Property.............................................................................................................29
transactionMode Property...................................................................................................29
queryExecuteTime Property..................................................................................................30
T2QueryExecuteLogFile Property..........................................................................................31
Setting Properties in the Command Line................................................................................31
Transactions...........................................................................................................................33
Autocommit Mode and Transaction Boundaries......................................................................33
Disabling Autocommit Mode...............................................................................................33
Stored Procedures...................................................................................................................34
Limitations.........................................................................................................................34
SQL Context Management.......................................................................................................34
Holdable Cursors...................................................................................................................35
Connection Pooling.................................................................................................................35
Connection Pooling by an Application Server........................................................................35
Contents 3