JDBC Tutorials - Herong's Tutorial Notes
Dr. Herong Yang, Version 2.11

JDBC Thin Client-Side Driver Installation

This section describes how to download and install Oracle JDBC thin client-side driver.

Among 4 different Oracle JDBC drivers offered by Oracle, JDBC Thin client-side driver is the simplest one to install and to use. Here is what I did to download and install it on my Windows system:

  • Go to JDBC, SQLJ, and Oracle JPublisher page.
  • Click on the link "Oracle Database 10g Release 2 (10.2.0.3), (10.2.0.2), (10.2.0.1.0) drivers", because my version of Oracle server is "Oracle Database 10g Express Edition 10.2.0.1.0".
  • Check the radio button next to "Accept License Agreement".
  • Click on the link "ojdbc14.jar (1,545,954 bytes)" next to "classes for use with JDK 1.4 and 1.5." I picked up this version because I want use JDK 1.5. The other versions support tracing information or DMS (Dynamic Monitoring Service). I do not need any of them now.
  • The download process requires you to register and get a login name. Just do it by following the instructions.
  • Save the download file, ojdbc14.jar, to \local\lib directory.

Installation is done now.

Table of Contents

 About This Book

 JDBC (Java Database Connectivity) Introduction

 Downloading and Installing JDK - Java SE

 Installing and Running Java DB - Derby

 Derby (Java DB) JDBC Driver

 Derby (Java DB) JDBC DataSource Objects

 Java DB (Derby) - DML Statements

 Java DB (Derby) - ResultSet Objects of Queries

 Java DB (Derby) - PreparedStatement

 MySQL Installation on Windows

 MySQL JDBC Driver (MySQL Connector/J)

 MySQL - PreparedStatement

 MySQL - Reference Implementation of JdbcRowSet

 MySQL - JBDC CallableStatement

 MySQL CLOB (Character Large Object) - TEXT

 MySQL BLOB (Binary Large Object) - BLOB

 Oracle Express Edition Installation on Windows

Oracle JDBC Drivers

 Oracle JDBC Drivers Overview

JDBC Thin Client-Side Driver Installation

 Loading JDBC Driver Class - ojdbc14.jar

 JDBC Driver Connection URL

 Creating Connections with DataSource Class

 DataSource Error - makeURL() Failed

 Getting Driver and Server Information

 "CREATE TABLE" - Creating New Tables

 "INSERT INTO" - Inserting New Data Rows

 Oracle - Reference Implementation of JdbcRowSet

 Oracle - PreparedStatement

 Oracle - JBDC CallableStatement

 Oracle CLOB (Character Large Object) - TEXT

 Oracle BLOB (Binary Large Object) - BLOB

 Microsoft SQL Server 2005 Express Edition

 Microsoft JDBC Driver for SQL Server - sqljdbc.jar

 Microsoft JDBC Driver - Query Statements and Result Sets

 Microsoft JDBC Driver - DatabaseMetaData Object

 Microsoft JDBC Driver - DDL Statements

 Microsoft JDBC Driver - DML Statements

 SQL Server - PreparedStatement

 SQL Server CLOB (Character Large Object) - TEXT

 SQL Server BLOB (Binary Large Object) - BLOB

 JDBC-ODBC Bridge Driver - sun.jdbc.odbc.JdbcOdbcDriver

 JDBC-ODBC Bridge Driver - Flat Text Files

 JDBC-ODBC Bridge Driver - MS Access

 JDBC-ODBC Bridge Driver - MS SQL Server

 Summary of JDBC Drivers and Database Servers

 Additional Tutorial Notes to Be Added

 References

 PDF Printing Version

Dr. Herong Yang, updated in 2007
JDBC Thin Client-Side Driver Installation