Oracle JDBC Drivers

JDBC for Oracle - Herong's Tutorial Examples

∟Oracle JDBC Drivers

This chapter provides tutorial notes on Oracle JDBC drivers. Topics include downloading and installing Oracle JDBC Thin client-side driver; database connection URL; DataSource objects; JDBC driver and database information; creating tables; inserting rows.

Oracle JDBC Drivers Overview

JDBC Thin Client-Side Driver Installation

Loading JDBC Driver Class - ojdbc16.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

Takeaways:

Oracle's JDBC Thin client-side driver is the primary free JDBC driver for Java applications to access Oracle database server.
The connection URL for the Oracle JDBC Thin client-side driver is "jdbc:oracle:thin:[user/password]@//[host][:port]/SID".

Table of Contents

About This Book

JDBC (Java Database Connectivity) Introduction

JDK (Java SE) Installation

Oracle Express Edition Installation on Windows

►Oracle JDBC Drivers

Oracle - Reference Implementation of JdbcRowSet

Oracle - PreparedStatement

Oracle - JBDC CallableStatement

Oracle CLOB (Character Large Object) - TEXT

Oracle BLOB (Binary Large Object) - BLOB

Using Connection Pool with JDBC

Archived Tutorials

References

Full Version in PDF/EPUB