JDBC Type 2 Driver Programmer's Reference for SQL/MX Release 3.2 (H06.25+, J06.14+)

Contents
About this manual.........................................................................................7
New and changed information...................................................................................................7
Supported Release Version Updates (RVUs)..................................................................................7
Audience.................................................................................................................................7
Organization...........................................................................................................................8
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.......................................................................................................19
3 Accessing SQL Databases with SQL/MX.....................................................20
Connecting to SQL/MX...........................................................................................................20
Connecting Using the DriverManager Class..........................................................................20
Connecting Using the DataSource Interface...........................................................................22
JdbcRowSet Implementation.....................................................................................................24
JDBC/MX Properties...............................................................................................................24
Default Catalog and Schema...............................................................................................25
LOB Table Name Properties................................................................................................25
ISO88591 Property............................................................................................................26
mploc Property..................................................................................................................26
maxStatements Property......................................................................................................26
minPoolSize Property..........................................................................................................26
maxPoolSize Property.........................................................................................................27
initialPoolSize property.......................................................................................................27
maxIdletime property.........................................................................................................27
language Property.............................................................................................................28
transactionMode Property...................................................................................................28
queryExecuteTime Property..................................................................................................29
T2QueryExecuteLogFile Property..........................................................................................30
Setting Properties in the Command Line................................................................................30
Transactions...........................................................................................................................32
Autocommit Mode and Transaction Boundaries......................................................................32
Disabling Autocommit Mode...............................................................................................32
Stored Procedures...................................................................................................................33
Limitations.........................................................................................................................33
SQL Context Management.......................................................................................................33
Holdable Cursors...................................................................................................................34
Connection Pooling.................................................................................................................34
Connection Pooling by an Application Server........................................................................34
Contents 3