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:

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

 Archived Tutorials

 References

 Full Version in PDF/EPUB