The various methods of using JDBC starting from the querying and returning of resultsets to executing DML from the Oracle 8i database are described in detail. A case study is presented to illustrate the concepts.
This section gives a brief outline of JDBC and the various JDBC drivers. The details of the case study used to illustrate the various JDBC concepts throughout are presented.
The implementation is by means of the interfaces in the standard package included in the file classes12
On the Oracle side, these interfaces are implemented as appropriate by classes in the and driver packages.
There are four types of drivers defined by JDBC as follows: Oracle 8i provides four types of JDBC drivers, namely, thin drivers, OCI drivers, server-side thin drivers, and server-side internal drivers.
These client-side and server-side drivers provide the same functionality and have the same syntax and APIs and they share the same Oracle extensions.
Learn the the details, from the querying and returning of resultsets to executing DML from the Oracle 8i database.
Oracle JDBC extensions are also discussed, and a case study is presented to illustrate the concepts.
These drivers support protocols such as IPC, named pipes, TCP/IP, and IPX/SPX.The following gives a detailed description of each of these drivers: This driver is a Type 4 (Proprietary Protocol-Net) driver and is written in 100% pure Java making it platform independent. It implements the TCP/IP protocol that emulates Oracle's Net8 and TTC (the wire protocol of OCI) on top of Java sockets. Figure 3.2 A configuration of an Oracle client-side JDBC thin driver.Java applets are good candidates that make use of this driver. This is a native-API Type 2 driver that is suited for client-server Java applications.It is Oracle platform-specific and requires an Oracle client installation.This driver converts JDBC calls into calls to the Oracle Call Interface using native methods.This driver can also be used to access data in the same database as the database connection.An example of using this driver is when accessing an Oracle server from inside of a Java stored procedure.This driver gives the maximum performance for an Oracle client application.This driver has the same functionality as the client-side thin driver except that it runs inside Oracle 8i and accesses a remote database.This chapter explains the use of Java Database Connectivity for database access in Java.It highlights the method to incorporate Java in the Oracle 8i database using JDBC.