JDBC^TMGuide: 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 Sample Code

3 Connection

3.1 Overview

3.1.1 Opening a Connection

3.1.2 URLs in General Use

3.1.3 JDBC URLs

3.1.4 The "odbc" Subprotocol

3.1.5 Registering Subprotocols

3.1.6 Sending SQL Statements

3.1.7 Transactions

3.1.8 Transaction Isolation Levels

4 DriverManager

4.1 Overview

4.1.1 Keeping Track of Available Drivers

4.1.2 Establishing a Connection

5 Statement

5.1 Overview

5.1.1 Creating Statement Objects

5.1.2 Executing Statement Objects

5.1.3 Using the Method Execute

5.1.4 Statement Completion

5.1.5 SQL Escape Syntax in Statement Objects

6 ResultSet

6.1 Overview

6.1.1 Rows and Cursors

6.1.2 Columns

6.1.3 Data Types and Conversions

6.1.4 Using Streams for Very Large Row Values

6.1.5 NULL Result Values

6.1.6 Optional or Multiple Result Sets

7 PreparedStatement

7.1 Overview

7.1.1 Creating PreparedStatement Objects

7.1.2 Passing IN Parameters

7.1.3 Data Type Conformance on IN Parameters

7.1.4 Using setObject

7.1.5 Sending SQL NULL as an IN parameter

7.1.6 Sending Very Large IN Parameters

8 CallableStatement

8.1 Overview

8.1.1 Creating a CallableStatement Object

8.1.2 IN and OUT Parameters

8.1.3 INOUT Parameters

8.1.4 Retrieve OUT Parameters after Results

8.1.5 Retrieving NULL Values as OUT Parameters

9 Mapping SQL and Java Types

9.1 Overview

9.2 Mapping SQL Data Types into Java

9.3 SQL Types

9.3.1 CHAR, VARCHAR, and LONGVARCHAR

9.3.2 DECIMAL and NUMERIC

9.3.3 BINARY, VARBINARY, and LONGVARBINARY

9.3.4 BIT

9.3.5 TINYINT, SMALLINT, INTEGER, and BIGINT

9.3.6 REAL, FLOAT, and DOUBLE

9.3.7 DATE, TIME, and TIMESTAMP

9.4 Examples of Mapping

9.4.1 Simple SQL Statement

9.4.2 SQL Statement with IN Parameters

9.4.3 SQL Statement with INOUT Parameters

9.5 Tables for Data Type Mapping

9.5.1 SQL Types Mapped to Java Types

9.5.2 Java Types Mapped to SQL Types

9.5.3 SQL Types Mapped to Java Object Types

9.5.4 Java Object Types Mapped to SQL Types

9.5.5 Conversions by setObject

9.5.6 SQL Types Retrieved by ResultSet.getXXX Methods

10 JDBC Version 1.21 Release Notes

10.1 Changes for 1.21

10.2 Changes for 1.2

10.2.1 From java.lang.Bignum to java.math.BigDecimal

10.2.2 Notes on This Version of BigDecimal

10.3 What Is JDBC?

10.3.1 Who to Contact?

10.3.2 Downloading JDBC as Part of an Applet

10.3.3 What Environments Are Supported?

10.3.4 Installation

10.4 JDBC Implementation

10.4.1 Classes in java.sql

10.4.2 Interfaces in java.sql

10.5 Debugging

10.6 General Notes

11 JDBC-ODBC Version 1.2001 Release Notes

11.1 Version Notes

11.1.1 Version 1.2001 Notes

11.1.2 Version 1.1001 Notes

11.1.3 Version 1.0105 Notes

11.2 What Is the JDBC-ODBC Bridge?

11.2.1 Who to Contact?

11.2.2 What Version of JDBC Is Supported?

11.2.3 What Version of ODBC Is Supported?

11.2.4 What Operating Systems Are Supported?

11.3 The Bridge Implementation

11.3.1 Installation

11.4 Using the Bridge

11.4.1 Using the Bridge from an Applet

11.4.2 Tested Configurations

11.4.3 ODBC Drivers Known to Work with the Bridge

11.4.4 ODBC Driver Incompatibilities

11.4.5 What Is the JDBC URL Supported by the Bridge?

11.5 Some Details About Versioning

11.6 Debugging

11.7 General Notes