List of Tables

3-1 Standard Datasource Properties

3-2 Oracle Extended Datasource Properties

3-3 Supported Database Specifiers

4-1 Connection Properties Recognized by Oracle JDBC Drivers

4-2 Default Mappings Between SQL Types and Java Types

4-3 LONG and LONG RAW Data Conversions

4-4 Bind-Size Limitations By

5-1 JDBC 3.0 Feature Support

5-2 Key Areas of JDBC 3.0 Functionality

5-3 BLOB Method Equivalents

5-4 CLOB Method Equivalents

6-1 Comparing Methods Used in Statement Caching

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

6-3 Methods Used to Retrieve Explicitly Cached Statements

8-1 onsctl commands

9-1 Connection Mode Transitions

9-2 Oracle-XA Error Mapping

10-1 Oracle Datatype Classes

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

11-1 Summary of getObject() and getOracleObject() Return Types

11-2 Summary of getXXX() Return Types

11-3 Summary of setXXX() Input Parameter Types

11-4 Size Limitations for setBytes() and setString() Methods

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

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

18-1 The JDBC and Cached Row Sets Compared

19-1 PL/SQL Types and Corresponding JDBC Types

19-2 Arguments of the setPlsqlIndexTable () Method

19-3 Arguments of the registerIndexTableOutParameter () Method

19-4 Argument of the getPlsqlIndexTable () Method

19-5 Argument of the getOraclePlsqlIndexTable () Method

19-6 Arguments of the getPlsqlIndexTable () Method

20-1 OCI Instant Client Shared Libraries

22-1 Valid Column Type Specifications

23-1 Client/Server Negotiations for Encryption or Integrity

23-2 OCI Driver Client Parameters for Encryption and Integrity

23-3 Thin Driver Client Parameters for Encryption and Integrity

24-1 Valid SQL Datatype-Java Class Mappings

24-2 Support for SQL Datatypes

24-3 Support for ANSI-92 SQL Datatypes

24-4 Support for SQL User-Defined Types

24-5 Support for PL/SQL Datatypes

26-1 Mapping of SQL Datatypes to Java Classes that Represent SQL Datatypes