JDBC^TM Guide: Getting Started

Contents

1 Introduction

1.1 What Is JDBC^TM?

1.1.1 What Does JDBC Do?

1.1.2 JDBC Is a Low-level API and a Base for Higher-level APIs

1.1.3 JDBC versus ODBC and other APIs

1.1.4 Two-tier and Three-tier Models

1.1.5 SQL Conformance

1.2 JDBC Products

1.2.1 JavaSoft Framework

1.2.2 JDBC Driver Types

1.2.3 Obtaining JDBC Drivers

1.2.4 Other Products

2 Connection

2.1 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

3 DriverManager

3.1 Overview

3.1.1 Keeping Track of Available Drivers

3.1.2 Establishing a Connection

4 Statement

4.1 Overview

4.1.1 Creating Statement Objects

4.1.2 Executing Statements Using Statement objects

4.1.3 Statement Completion

4.1.4 Closing Statement Objects

4.1.5 SQL Escape Syntax in Statement Objects

4.1.6 Using the Method execute

5 ResultSet

5.1 Overview

5.1.1 Rows and Cursors

5.1.2 Columns

5.1.3 Data Types and Conversions

5.1.4 Using Streams for Very Large Row Values

5.1.5 NULL Result Values

5.1.6 Optional or Multiple Result Sets

6 PreparedStatement

6.1 Overview

6.1.1 Creating PreparedStatement Objects

6.1.2 Passing IN Parameters

6.1.3 Data Type Conformance on IN Parameters

6.1.4 Using setObject

6.1.5 Sending JDBC NULL as an IN parameter

6.1.6 Sending Very Large IN Parameters

7 CallableStatement

7.1 Overview

7.1.1 Creating a CallableStatement Object

7.1.2 IN and OUT Parameters

7.1.3 INOUT Parameters

7.1.4 Retrieve OUT Parameters after Results

7.1.5 Retrieving NULL Values as OUT Parameters

8 Mapping SQL and Java Types

8.1 Overview

8.2 Mapping SQL Data Types into Java

8.3 JDBC Types

8.3.1 CHAR, VARCHAR, and LONGVARCHAR

8.3.2 BINARY, VARBINARY, and LONGVARBINARY

8.3.3 BIT

8.3.4 TINYINT

8.3.5 SMALLINT

8.3.6 INTEGER

8.3.7 BIGINT

8.3.8 REAL

8.3.9 DOUBLE

8.3.10 FLOAT

8.3.11 DECIMAL and NUMERIC

8.3.12 DATE, TIME, and TIMESTAMP

8.4 Examples of Mapping

8.4.1 Simple SQL Statement

8.4.2 SQL Statement with IN Parameters

8.4.3 SQL Statement with INOUT Parameters

8.5 Dynamic Data Access

8.6 Tables for Data Type Mapping

8.6.1 JDBC Types Mapped to Java Types

8.6.2 Java Types Mapped to JDBC Types

8.6.3 JDBC Types Mapped to Java Object Types

8.6.4 Java Object Types Mapped to JDBC Types

8.6.5 Conversions by setObject

8.6.6 JDBC Types Retrieved by ResultSet.getXXX Methods

9 Sample Code

10 JDBC-ODBC Bridge Driver

10.1 JDBC-ODBC Bridge

10.1.1 What Is the JDBC-ODBC Bridge?

10.1.2 What Version of ODBC Is Supported?

10.1.3 The Bridge Implementation

10.1.4 Installation

10.2 Using the Bridge

10.2.1 Using the Bridge from an Applet

10.2.2 Most Browsers Do Not Support the Bridge

10.2.3 Tested Configurations

10.2.4 ODBC Drivers Known to Work with the Bridge

10.2.5 ODBC Driver Incompatibilities

10.2.6 What Is the JDBC URL Supported by the Bridge?

10.2.7 Debugging

10.3 General Notes