List of Tables

1-1 Feature Differences Between JDBC OCI and JDBC Thin Drivers

1-2 Feature List

3-1 Import Statements for JDBC Driver

4-1 JDBC 3.0 Feature Support

4-2 Key Areas of JDBC 3.0 Functionality

4-3 BLOB Method Equivalents

4-4 CLOB Method Equivalents

5-1 Oracle Data Type Classes

5-2 Key Interfaces and Classes of the oracle.jdbc Package

5-3 PL/SQL Types and Corresponding JDBC Types

5-4 Arguments of the setPlsqlIndexTable Method

5-5 Arguments of the registerIndexTableOutParameter Method

5-6 Argument of the getPlsqlIndexTable Method

5-7 Argument of the getOraclePlsqlIndexTable Method

5-8 Arguments of the getPlsqlIndexTable Method

7-1 OCI Instant Client Shared Libraries

7-2 Data Shared Library for Instant Client and Instant Client Light (English)

9-1 Standard Data Source Properties

9-2 Oracle Extended Data Source Properties

9-3 Connection Properties Recognized by Oracle JDBC Drivers

9-4 Supported Database Specifiers

10-1 Client/Server Negotiations for Encryption or Integrity

10-2 OCI Driver Client Parameters for Encryption and Integrity

10-3 Thin Driver Client Parameters for Encryption and Integrity

13-1 Default Mappings Between SQL Types and Java Types

13-2 getObject and getOracleObject Return Types

13-3 Summary of getXXX Return Types

13-4 Summary of setXXX Input Parameter Types

13-5 Size Limitations for setBytes and setString Methods

14-1 LONG and LONG RAW Data Conversions

15-1 JPublisher SQL Type Categories, Supported Settings, and Defaults

19-1 Visibility of Internal and External Changes for Oracle JDBC

20-1 The JDBC and Cached Row Sets Compared

22-1 Comparing Methods Used in Statement Caching

22-2 Methods Used in Statement Allocation and Implicit Statement Caching

22-3 Methods Used to Retrieve Explicitly Cached Statements

25-1 Valid Column Type Specifications

27-1 onsctl commands

29-1 Connection Mode Transitions

29-2 Oracle-XA Error Mapping

30-1 Maximum Lengths for End-to-End Metrics

A-1 Valid SQL Data Type-Java Class Mappings

A-2 Support for SQL Data Types

A-3 Support for ANSI-92 SQL Data Types

A-4 Support for SQL User-Defined Types

A-5 Support for PL/SQL Data Types

B-1 Mapping of SQL Data Types to Java Classes that Represent SQL Data Types