Books & Videos

Table of Contents

  1. Overview

    1. Chapter 1 Introduction to JDBC

      1. The JDBC API
      2. Clients
      3. Using SQL
  2. Connections

    1. Chapter 2 Application Database Connections

      1. JDBC Drivers
      2. Installation
      3. Connecting to a Database
      4. Handling Exceptions
    2. Chapter 3 Applet Database Connections

      1. Oracle Drivers and JDK Versions
      2. It’s an Applet’s Life
      3. Packaging Your Applet
      4. Getting Around the Sandbox
      5. Establishing a Connection Through a Firewall
      6. Guidelines for Choosing a Workaround
    3. Chapter 4 Servlet Database Connections

      1. Oracle Driver Selection
      2. Servlet Connection Strategies
      3. Guidelines for Choosing a Connection Strategy
    4. Chapter 5 Internal Database Connections

      1. Server-Side Driver Types
      2. Using the Server-Side Internal Driver
      3. Using the Server-Side Thin Driver
      4. JServer Program Support
    5. Chapter 6 Oracle Advanced Security

      1. Authentication
      2. Data Encryption
      3. Data Integrity
      4. A Data Encryption and Integrity Example
      5. Secure Sockets Layer
    6. Chapter 7 JNDI and Connection Pooling

      1. DataSources
      2. Oracle’s Connection Cache
  3. Relational SQL

    1. Chapter 8 A Relational SQL Example

      1. Relational Database Analysis
      2. Refining the Analysis
      3. Relational Database Design
    2. Chapter 9 Statements

      1. Creating a Statement Object
      2. The execute( ) Method
      3. The executeUpdate( ) Method
      4. The executeQuery( ) Method
      5. OracleStatement Implements Statement
    3. Chapter 10 Result Sets

      1. Basic Cursor Positioning
      2. Data Types
      3. Accessor Methods
      4. Scrollable, Updateable Result Sets
      5. ResultSet Is an OracleResultSet
    4. Chapter 11 Prepared Statements

      1. A Prepared Statement Versus a Statement
      2. Formulating SQL Statements
      3. Batching
      4. PreparedStatement Is an OraclePreparedStatement
    5. Chapter 12 Streaming Data Types

      1. BLOBs
      2. CLOBs
      3. BFILEs
      4. LONG RAWs
      5. LONGs
    6. Chapter 13 Callable Statements

      1. Understanding Stored Procedures
      2. Calling Stored Procedures
      3. CallableStatement Is an OracleCallableStatement
  4. Object-Relational SQL

    1. Chapter 14 An Object-Relational SQL Example

      1. From Relational Tables to Object Views
      2. Object Tables
    2. Chapter 15 Weakly Typed Object SQL

      1. Accessing Objects as Relational Tables
      2. Structs
      3. Arrays
      4. Refs
      5. Calling Object Methods
      6. Putting It All Together
      7. Oracle’s Implementations
    3. Chapter 16 Strongly Typed Object SQL

      1. JPublisher
      2. The SQLData Interface
      3. Oracle’s CustomDatum Interface
  5. Essentials

    1. Chapter 17 Transactions

      1. Manual Transactions
      2. Transaction Scope
      3. Implicit Locking and Visibility
      4. Isolation Levels
      5. Distributed Transactions
    2. Chapter 18 Detection and Locking

      1. Oracle’s Locking Mechanisms
      2. Detection
      3. Data Integrity Solutions
    3. Chapter 19 Performance

      1. A Testing Framework
      2. Auto-Commit
      3. SQL92 Token Parsing
      4. Statement Versus PreparedStatement
      5. Batching
      6. Predefined SELECT Statements
      7. CallableStatements
      8. OCI Versus Thin Drivers
    4. Chapter 20 Troubleshooting

      1. The “Gotchas”
      2. Unsupported Features
      3. Debugging
      4. Net8 Tracing
      5. Wait for the Cure
  1. Colophon