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

Our look is the result of reader comments, our own experimentation, and feedback from distribution channels. Distinctive covers complement our distinctive approach to technical topics, breathing personality and life into potentially dry subjects. The animals on the cover of Java Programming with Oracle JDBC are hummingbird moths. As its name suggests, this moth looks much like a hummingbird at a glance. It feeds by hovering in front of a flower and sipping nectar through its proboscis (its feeding structure) in much the same way as the hummingbird. However, at a closer look, the insect's antennae mark it as a moth. Belonging to the family Sphingidae, this moth is commonly called "hummingbird," "sphinx," or "hawk moth."

The hummingbird moth is a strong flyer, with a rapid wingbeat. Most are medium to large moths with heavy bodies, with wing spreads up to five inches. Although few are active in the daytime, most fly on cloudy days or at dusk. Though most don't cause damage to garden plants, some feed on tomatoes and tobacco when in caterpillar form. The tomato hornworm, for example, feeds on potato, tomato, and tobacco plants, and can cause severe economic loss in those crops. Leaves provide an additional source of food for the moth. Matt Hutchinson was the production editor and copyeditor for Java Programming with Oracle JDBC. Leanne Soylemez and Rachel Wheeler provided quality control. Joe Wizda wrote the index. Edie Shapiro provided production assistance.

Ellie Volckhausen designed the cover of this book, based on a series design by Edie Freedman. The cover image is from Animal Creation, Volume 2. Emma Colby produced the cover layout with QuarkXPress 4.1 using Adobe's ITC Garamond font. David Futato designed the interior layout. Neil Walls converted the files from Microsoft Word to FrameMaker 5.5.6 using tools created by Mike Sierra. The text font is Linotype Birka; the heading font is Adobe Myriad Condensed; and the code font is LucasFont's TheSans Mono Condensed. The illustrations that appear in the book were produced by Robert Romano and Jessamyn Read using Macromedia Free-Hand 9 and Adobe Photoshop 6. The tip and warning icons were drawn by Christopher Bing. This colophon was written by Sarah Sherman.

Whenever possible, our books use a durable and flexible lay-flat binding. If the page count exceeds this binding's limit, perfect binding is used.