Contents | Prev | Next


JDBCTM Guide: Getting Started

March 6, 1997


Contents


1 Introduction
1.1 What Is JDBCTM?
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


Contents | Prev | Next
jdbc@wombat.eng.sun.com or jdbc-odbc@wombat.eng.sun.com
Copyright © 1996, 1997 Sun Microsystems, Inc. All rights reserved.