1 Oracle Database Companion CD Installation Overview

This chapter provides an overview of the products available on the Oracle Database Companion CD installation media and describes issues that you must consider before installing them. It includes the following sections:

Overview of Oracle Database Companion CD Installation
Products Available in the Oracle Database 10g Products Installation Type

1.1 Overview of Oracle Database Companion CD Installation

The installation process consists of the following steps:

Read the release notes: Read Oracle Database Release Notes for Apple Mac OS X (Intel) before you begin the installation. The release notes are available with the platform-specific documentation. The latest version of the release notes is available on Oracle Technology Network at

http://www.oracle.com/technology/documentation/index.html
Plan the installation: This chapter describes the products that you can install and provides information that you must know before installing the software.

See Also:
The "Frequently Asked Questions About Installation" appendix of Oracle Database Installation Guide for Apple Mac OS X (Intel) for information about the best way to install Oracle products depending on the requirements of your site
Verify system requirements: Chapter 2 describes the minimum system requirements for installing Companion CD products.
Installing the software: The following chapter and appendixes provide information about installing Companion CD products:
Completing postinstallation tasks: Chapter 4 describes required and recommended postinstallation tasks.
Getting started on using the Companion CD products: Chapter 5 provides information about using the Companion CD products.

1.2 Products Available in the Oracle Database 10g Products Installation Type

The following sections describe the products that are installed by the Oracle Database 10g Products installation type. You must install these products in an existing Oracle Database 10g release 2 (10.2) Oracle home:

Oracle JDBC Development Drivers
Oracle SQLJ
JPublisher

Note:

The Summary screen of Oracle Universal Installer provides a detailed list of the products available in the Oracle Database 10g Products installation type.

1.2.1 Oracle JDBC Development Drivers

Oracle provides a set of JDBC drivers that you can use for debugging your code and other deployment scenarios. These drivers can access Oracle Database release 8.1.7 or later.

1.2.2 Oracle SQLJ

Oracle SQLJ enables application programmers to embed SQL operations in Java code in a way that is compatible with the Java design philosophy. A SQLJ program is a Java program containing embedded SQL statements. Oracle SQLJ offers extensions to support dynamic SQL operations, which are operations that can change in real time. It is also possible to use dynamic SQL operations through JDBC code or PL/SQL code within a SQLJ application. Typical applications contain much more static SQL than dynamic SQL. SQLJ consists of both a translator and a run-time component and is smoothly integrated into your development environment.

1.2.3 JPublisher

JPublisher is a Java utility that generates Java classes to represent the following user-defined database entities in a Java program:

SQL object types
Object reference types (REF types)
SQL collection types (VARRAY types or nested table types)
PL/SQL packages
Server-side Java classes
SQL queries and DML statements

You can use JPublisher to specify and customize the mapping of SQL object types, object reference types, and collection types (VARRAYs or nested tables) to Java classes in a strongly typed paradigm.

JPublisher can also generate classes for PL/SQL packages. These classes have wrapper methods to invoke the stored procedures in the PL/SQL packages.

In addition, JPublisher simplifies access to PL/SQL-only types from Java. You can employ predefined or user-defined mappings between PL/SQL and SQL types. You can also use PL/SQL conversion functions between such types. With such type correspondences in place, JPublisher can automatically generate the required Java and PL/SQL code.

Just like SQL and PL/SQL entities publish to Java, you can also publish server-side Java classes to client-side Java classes. Doing this enables applications to make direct calls to Java classes in the database.

JPublisher lets you expose generated Java classes as Web services, for example. You can publish either SQL or PL/SQL entities, or server-side Java entities.

JPublisher uses SQLJ code in most Java classes that it generates, so it includes Oracle SQLJ Translator and Oracle SQLJ Runtime. Oracle SQLJ is a standard way to embed SQL statements in Java programs.

Oracle SQLJ Translator

Because JPublisher uses SQLJ code in its generated classes, it automatically calls the Oracle SQLJ translator during the code generation process, as required. The translator converts embedded SQL statements into JDBC calls.

Oracle SQLJ Runtime

Oracle SQLJ Runtime is used during program run time to run most classes that were generated by JPublisher. SQLJ Runtime is a thin layer of pure Java code that runs above the JDBC driver. It acts as an intermediary that reads information about SQL operations and passes instructions to the JDBC driver.