Java Programming with Oracle SQLJ

1.3. Requirements for Using SQLJ

Before you can write and execute a SQLJ 8i (or higher)program, you need to have the following software installed:

• Oracle SQLJ translator

• Oracle JDBC drivers

• A version of the Sun Microsystems Java Development Kit (JDK)

• An Oracle database, Version 8i or higher, running the JServer option (JServer is also known as the Oracle JVM)

• Oracle Net8 or higher

The SQLJ translator, the JDBC drivers, and the JDK need to be installed on the machine you are using for development. The Oracle8i database and Net8 can reside anywhere on your network as long as you have access to them. You can download trial versions of all the Oracle software from Oracle's Technology Network web site at http://technet.oracle.com, and you can download the JDK from Sun's Java web site at http://java.sun.com. If you are installing the Oracle database onto your development machine, you can also choose to install the SQLJ translator and JDBC drivers at the same time; you don't have to install them separately.

The specific version numbers for the components listed here are important. A given release of SQLJ will work only with specific versions of the JDK and the other Oracle software components. Thus, you not only need to have the right components, but also the right combination of versions. SQLJ Versions 8.1.6 and 8.1.7 are compatible with JDK Versions 1.1.x and 1.2.x. SQLJ 9i is also compatible with versions of the JDK higher than 1.2.x. In this book, I used JDK Version 1.2.2 ...