Getting Started with the JDBC API

1.1 What the JDBC 3.0 API Includes . . . . . . . . . . . . .

1.2 What Is the JDBC API?

1.2.1 What Does the JDBC API Do?

1.2.2 A Base for Other APIs

1.2.3 The JDBC API Versus ODBC and UDA

1.2.4 Two-tier and Three-tier Models

1.2.5 SQL Conformance

1.2.6 JDBC Products

1.2.7 Java Software Framework

1.2.8 JDBC Driver Types

1.2.9 Obtaining JDBC Drivers

1.2.10 Java-relational DBMSs

1.2.11 Other Products

2.1 Connection Overview . . . . . . . . . . . . .

2.1.1 Opening a Connection

2.1.2 URLs in General Use

2.1.3 JDBC URLs

2.1.4 The odbc Subprotocol

2.1.5 Registering Subprotocols

2.1.6 Sending SQL Statements

2.1.7 Transactions

2.1.8 Transaction Isolation Levels

2.1.9 Savepoints

2.1.10 Freeing DBMS Resources

2.1.11 Using Type Maps

3.1 DriverManager Overview . . . . . . . . . . . . .

3.1.1 Keeping Track of Available Drivers

3.1.2 Establishing a Connection

3.1.3 DriverManager Methods Are Static

4.1 DataSource Overview . . . . . . . . . . . . .

4.1.1 Properties

4.1.2 Using JNDI

4.1.3 Creating and Registering a DataSource Object

4.1.4 Connecting to a Data Source

4.1.5 DataSource Implementations

4.1.6 Logging and Tracing

4.1.7 Advantages of Using JNDI

5.1 Statement Overview . . . . . . . . . . . . .

5.1.1 Creating Statement Objects

5.1.2 Executing Statements Using Statement Objects

5.1.3 Statement Completion

5.1.4 Retrieving Automatically Generated Keys

5.1.5 Closing Statements

5.1.6 SQL Escape Syntax in Statements

5.1.7 Sending Batch Updates

5.1.8 Giving Performance Hints

5.1.9 Executing Special Kinds of Statements

6.1 ResultSet Overview . . . . . . . . . . . . .

6.1.1 Rows and Columns

6.1.2 Cursors

6.1.3 Cursor Movement Examples

6.1.4 Determining the Number of Rows in a Result Set

6.1.5 Retrieving Column Values

6.1.6 Which getter Method to Use

6.1.7 Types of Result Sets

6.1.8 Concurrency Types

6.1.9 Holdability

6.1.10 Providing Performance Hints

6.1.11 Creating Different Types of Result Sets

6.1.12 Using a Prepared Statement to Create Result Sets

6.1.13 Requesting Features That Are Not Supported

6.1.14 Using updater Methods

6.1.15 Deleting a Row

6.1.16 Inserting Rows

6.1.17 Positioned Updates

6.1.18 Queries That Produce Updatable Result Sets

6.1.19 Using Streams for Very Large Row Values

6.1.20 NULL Result Values

6.1.21 Closing a ResultSet Object

6.1.22 JDBC Compliance

7.1 PreparedStatement Overview . . . . . . . . . . . . .

7.1.1 Creating PreparedStatement Objects

7.1.2 Passing IN Parameters

7.1.3 Parameter Metadata

7.1.4 Data Type Conformance on IN Parameters

7.1.5 Using setObject

7.1.6 Sending JDBC NULL as an IN parameter

7.1.7 Sending Very Large IN Parameters

7.1.8 Using PreparedStatement Objects in Batch Updates

8.1 CallableStatement Overview . . . . . . . . . . . . .

8.1.1 Creating a CallableStatement Object

8.1.2 IN Parameters

8.1.3 Making Batch Updates

8.1.4 OUT Parameters

8.1.5 Numbering of Parameters

8.1.6 INOUT Parameters

8.1.7 Retrieve OUT Parameters after Results

8.1.8 Retrieving NULL Values as OUT Parameters

9.1 Mapping Overview . . . . . . . . . . . . .

9.2 Mapping SQL Types to Java Types

9.3 Basic JDBC Types

9.3.1 CHAR, VARCHAR, and LONGVARCHAR

9.3.2 BINARY, VARBINARY, and LONGVARBINARY

9.3.3 BIT

9.3.4 BOOLEAN

9.3.5 TINYINT

9.3.6 SMALLINT

9.3.7 INTEGER

9.3.8 BIGINT

9.3.9 REAL

9.3.10 DOUBLE

9.3.11 FLOAT

9.3.12 DECIMAL and NUMERIC

9.3.13 DATE, TIME, and TIMESTAMP

9.4 Advanced JDBC Data Types

9.4.1 DATALINK

9.4.2 BLOB

9.4.3 CLOB

9.4.4 ARRAY

9.4.5 DISTINCT

9.4.6 STRUCT

9.4.7 REF

9.4.8 JAVA_OBJECT

9.5 Examples of Mapping

9.5.1 Simple SQL Statement

9.5.2 SQL Statement with IN Parameters

9.5.3 SQL Statement with INOUT Parameters

9.6 Custom Mapping

9.7 Dynamic Data Access

9.8 Storing Java Objects in a Database

9.9 Tables for Type Mapping

9.9.1 JDBC Types Mapped to Java Types

9.9.2 Java Types Mapped to JDBC Types

9.9.3 JDBC Types Mapped to Java Object Types

9.9.4 Java Object Types Mapped to JDBC Types

9.9.5 Conversions by setObject

9.9.6 Conversions by ResultSet.getter Methods

9.9.7 JDBC Types Mapped to Database-specific SQL Types

10.1 Rowset Overview

10.1.1 The Event Model for Rowsets

10.1.2 Properties for a Rowset

10.1.3 Setting Parameters for the Command String

10.1.4 Traversing a RowSet Object

10.1.5 Executing a Command

10.1.6 Using a RowSet Object's Metadata

10.2 Standard Implementations

10.2.1 Implementation Basics

10.2.2 Overview of the JdbcRowSet Implementation

10.2.3 Overview of the CachedRowSet Implementation

10.2.4 Uses for a CachedRowSet Object

10.2.5 Creating a CachedRowSet Object

10.2.6 Setting a SyncProvider Object

10.2.7 Populating a CachedRowSet Object

10.2.8 Accessing Data

10.2.9 Modifying Data

10.2.10 Customizing Readers and Writers

10.2.11 Other Methods

10.2.12 Using the javax.sql.rowset.spi Package

10.2.13 CachedRowSet Summary

10.2.14 WebRowSet Implementation

10.2.15 FilteredRowSet Implementation

10.2.16 JoinRowSet Implementation

A.1 Overview of JDBC 3.0 API Changes

A.1.1 Features Introduced in the JDBC 3.0 API

A.1.2 Features Introduced in the JDBC 2.0 Optional Package

A.2 Overview of JDBC 2.0 Core API Changes

A.3 Summary of New Functionality

A.3.1 Scrollable Result Sets

A.3.2 Batch Updates

A.3.3 Programmatic Updates

A.3.4 Other New Features

A.4 Support for Advanced Data Types

A.4.1 What Are the SQL99 Data Types?

A.4.2 Summary of Support for the SQL99 Data Types

A.4.3 Mapping of the SQL99 Types

A.4.4 SQL Locators

A.4.5 Support for Storing Java Objects