JDBC Driver User Manual V3

• JDBC Driver Overview
  • What is a JDBC Driver?
  • JDBC Specifications and Standards
  • Result Sets
• Using JDBC Driver
  • Setting up the JDBC Driver at a Customer Site
    • Prerequisites
    • Installation Instructions
    • Loading the Driver Interface
    • Making the Connection
  • Changing Connection Properties
  • Connecting Through the Physical Connection Pool
    • JDBC Connection Using a Connection Pool
    • Creating Pools for two Different MTMs from the Same Program
  • Stored Procedure Calls and Profile Service Classes
    • Setting Parameters
      • IN Parameters
      • OUT Parameters
    • Types of Profile Service Classes
      • MRPC Call Syntax
        • Examples
          • Method 1 Example
          • Method 2 Example
          • Method 3 (XBAD Calls) Example
          • HTML Call Syntax
          • XML Call Syntax
          • TSSP Call Syntax:
          • Construction of ScTsspRecord:
        • TSSP Error Handling
      • AGGMSG Call Syntax
        • AGGMSG Error Handling
  • Submitting Batch Updates
  • Timestamp Support
  • Internationalized Messages
  • BLOB and CLOB Support
    • BLOB Example
    • CLOB Example
  • UTF8 and UTF-16 Encoding for Unicode™
  • Resultset Holdability Support
  • Retrieving Auto-Generated Keys
  • Profile Stored Procedure for SQL Query Support
  • JCA and JNDI Support