Skip to Main Content
Oracle and Open Source
book

Oracle and Open Source

by Andy Duncan, Sean Hull
April 2001
Intermediate to advanced content levelIntermediate to advanced
432 pages
13h 2m
English
O'Reilly Media, Inc.
Content preview from Oracle and Open Source

JDBC: Java DataBase Connectivity

At this point, we’ve installed the JDK, and we have a little experience using HTML, applets, standalone Java programs, .jar files, and the standard environment variables. Let’s get on with the real business of doing useful work with Oracle. First, we need to acquire the drivers needed to connect Oracle and Java via JDBC (Java DataBase Connectivity). JDBC, which we described briefly in Chapter 2, is Java’s answer to ODBC (Open DataBase Connectivity).

java.sql Drivers for JDBC and Oracle

The first thing we need to do is to get hold of the appropriate Oracle connectivity drivers. Because the download pages for these drivers tend to be quite fluid, the best way to get the code is to first access the Oracle Technology Network (OTN). (You may need to register there beforehand as a developer, if you haven’t done so already, as described in the preface.) Visit the following site, and search for “Java” and/or “JDBC”. The download pages for the relevant Oracle JDBC drivers should reveal themselves in any search results:

http://technet.oracle.com

Types of drivers

There are four types of drivers for generic JDBC database use, two Fat and two Thin. Fat drivers for any database type require access to native code libraries, such as OCI, at the client end. Thin drivers are entirely encapsulated and do not require anything outside of themselves to connect Java to a target database (these differing characteristics are displayed in Figure 7-5). This makes them especially ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Procure-to-Pay Guide

Oracle Procure-to-Pay Guide

Melanie Cameron
Expert Oracle Exadata

Expert Oracle Exadata

Kerry Osborne, Randy Johnson, Tanel Pöder
Expert PL/SQL Practices for Oracle Developers and DBAs

Expert PL/SQL Practices for Oracle Developers and DBAs

John Beresniewicz, Adrian Billington, Martin Büchi, Melanie Caffrey, Ron Crisco, Lewis Cunningham, Dominic Delmolino, Sue Harper, Torben Holm, Connor McDonald, Arup Nanda, Stephan Petit, Michael Rosenblum, Robyn Sands, Riyaj Shamsudeen
Achieving Extreme Performance with Oracle Exadata

Achieving Extreme Performance with Oracle Exadata

Rick Greenwald, Robert Stackowiak, Maqsood Alam, Mans Bhuller

Publisher Resources

ISBN: 0596000189Catalog PageErrata