xviii
List of Tables
1–1 Feature Differences Between JDBC OCI and JDBC Thin Drivers....................................... 1-5
1–2 Feature List............................................................................................................................... 1-10
3–1 Import Statements for JDBC Driver ........................................................................................ 3-2
4–1 JDBC 3.0 Feature Support......................................................................................................... 4-3
4–2 Key Areas of JDBC 3.0 Functionality ...................................................................................... 4-3
4–3 BLOB Method Equivalents....................................................................................................... 4-8
4–4 CLOB Method Equivalents....................................................................................................... 4-8
5–1 Oracle Data Type Classes ......................................................................................................... 5-5
5–2 Key Interfaces and Classes of the oracle.jdbc Package...................................................... 5-17
5–3 PL/SQL Types and Corresponding JDBC Types............................................................... 5-29
5–4 Arguments of the setPlsqlIndexTable Method................................................................... 5-30
5–5 Arguments of the registerIndexTableOutParameter Method.......................................... 5-32
5–6 Argument of the getPlsqlIndexTable Method.................................................................... 5-33
5–7 Argument of the getOraclePlsqlIndexTable Method ........................................................ 5-34
5–8 Arguments of the getPlsqlIndexTable Method .................................................................. 5-34
7–1 OCI Instant Client Shared Libraries........................................................................................ 7-2
7–2 Data Shared Library for Instant Client and Instant Client Light (English)....................... 7-8
9–1 Standard Data Source Properties............................................................................................. 9-3
9–2 Oracle Extended Data Source Properties................................................................................ 9-4
9–3 Connection Properties Recognized by Oracle JDBC Drivers .............................................. 9-8
9–4 Supported Database Specifiers ............................................................................................. 9-14
10–1 Client/Server Negotiations for Encryption or Integrity ................................................... 10-3
10–2 OCI Driver Client Parameters for Encryption and Integrity............................................ 10-4
10–3 Thin Driver Client Parameters for Encryption and Integrity........................................... 10-4
13–1 Default Mappings Between SQL Types and Java Types................................................... 13-2
13–2 getObject and getOracleObject Return Types..................................................................... 13-7
13–3 Summary of getXXX Return Types .................................................................................... 13-10
13–4 Summary of setXXX Input Parameter Types.................................................................... 13-13
13–5 Size Limitations for setBytes and setString Methods ...................................................... 13-15
14–1 LONG and LONG RAW Data Conversions ....................................................................... 14-3
15–1 JPublisher SQL Type Categories, Supported Settings, and Defaults ............................ 15-35
19–1 Visibility of Internal and External Changes for Oracle JDBC......................................... 19-19
20–1 The JDBC and Cached Row Sets Compared....................................................................... 20-9
22–1 Comparing Methods Used in Statement Caching.............................................................. 22-3
22–2 Methods Used in Statement Allocation and Implicit Statement Caching...................... 22-6
22–3 Methods Used to Retrieve Explicitly Cached Statements................................................. 22-8
25–1 Valid Column Type Specifications..................................................................................... 25-19
27–1 onsctl commands..................................................................................................................... 27-4
29–1 Connection Mode Transitions............................................................................................... 29-4
29–2 Oracle-XA Error Mapping................................................................................................... 29-14
30–1 Maximum Lengths for End-to-End Metrics........................................................................ 30-1
A–1 Valid SQL Data Type-Java Class Mappings ......................................................................... A-1
A–2 Support for SQL Data Types ................................................................................................... A-3
A–3 Support for ANSI-92 SQL Data Types................................................................................... A-4
A–4 Support for SQL User-Defined Types.................................................................................... A-4
A–5 Support for PL/SQL Data Types............................................................................................ A-5
B–1 Mapping of SQL Data Types to Java Classes that Represent SQL Data Types ............... B-3