# Oracle SQLJ Release 8.1.7.0.0
June 30 2000

## Requirements

SQLJ requires an installation of JDK1.1 or JDK1.2 from Sun Microsystems. It must be installed and the Java interpreter must be available in your path. In the rest of this page we assume that both the Java compiler (javac) and the Java interpreter (java) are installed correctly in your path.

Since SQLJ runs on top of the JDBC API, a driver compliant with the database to be used must be installed in your system. The current version of SQLJ has been tested with the 8.1.7.0 release of Oracle's JDBC driver.

## Installation

Configure your environment as follows:

1. We assume that SQLJ has been installed with the Oracle installer. Let ORACLE_HOME be the location into which your Oracle products have been installed.
2. Verify your JDBC installation before using SQLJ. Refer to the section "Getting Started" in the book SQLJ Developer's Guide and Reference Release 3 (8.1.7) for information on testing your SQLJ and JDBC installations. (Note: You must be signed up for the Oracle Technology Network at http://technet.oracle.com in order to access the online documentation.)

   Specifically, in order to use SQLJ you must have ORACLE_HOME/jdbc/lib/classesxxx.zip in your CLASSPATH environment variable (where xxx is either 111 or 12, depending on the version of your Java compiler). Additionally -depending on the nature of your JDBC driver- dynamic link libraries may have to be installed.

3. Ensure that the directory ORACLE_HOME/bin is included in your environment variable PATH.
4. You must add the files ORACLE_HOME/sqlj/lib/translator.zip and and ORACLE_HOME/sqlj/lib/runtime.zip to the environment variable CLASSPATH.
   If you use JDK 1.1.x and Oracle JDBC 8.1.7, you can replace runtime.zip with runtime11.zip.
   If you use JDK 1.2 or later and Oracle JDBC 8.1.7, you can replace runtime.zip with runtime12.zip.

   IMPORTANT!

   - Previous SQLJ releases only required that you place translator.zip in the CLASSPATH in order to translate and/or run SQLJ programs.
   - SQLJ 8.1.7 and later requires additionally one of the runtime zip files (runtime.zip, runtime11.zip, or runtime12.zip) in your CLASSPATH in order to translate SQLJ programs.

This completes the installation.

## Testing

To verify that your installation is correct, follow the instructions in the "Getting Started" section of the SQLJ Developer's Guide and Reference.

The following table provides information about the Oracle JDBC drivers.

JDBC Driver | JDBC Driver Class Name | JDBC URL
--- | --- | ---
Oracle JDBC-OCI7 | oracle.jdbc.driver.OracleDriver | jdbc:oracle:oci7:@oracle_sid
Oracle JDBC-OCI8 | oracle.jdbc.driver.OracleDriver | jdbc:oracle:oci8:@oracle_sid
Oracle JDBC-Thin | oracle.jdbc.driver.OracleDriver | jdbc:oracle:thin:@host:port:oracle_sid
Oracle server-side JDBC | oracle.jdbc.driver.OracleDriver | jdbc:oracle:kprb:

In the table, host corresponds to the machine name of the database server, for example, `localhost`. The port corresponds to the tcp/ip port # of the listener, for example `1521`. The oracle_sid corresponds to the TNS_alias defined in your local tnsnames.ora file.

Since SQLJ relies on JDBC for acquiring the connections to be used, your application can use any of the JDBC mechanisms recommended by your vendor for loading the JDBC driver and specifying the database URL.

# Documentation

- README (also in plain text)
- SQLJ Developer's Guide and Reference - provides complete and comprehensive documentation on Oracle SQLJ
- SQLJ Demos: [Oracle Home]`/sqlj/demo/`
- SQLJ Frequently Asked Questions. Or check the latest OTN Online version of the FAQ.
- SQLJ Runtime API
- Technical Paper "An Overview of SQLJ: Embedded SQL in Java"
- Tutorial Paper "SQLJ: Tricks, Traps, and Gems"
- Technical Paper "Using Oracle Objects in SQLJ"
- Business Paper "SQLJ: Embedded SQL in Java"
- JDBC User's Guide and Reference describes Oracle's JDBC drivers.
- JPublisher User's Guide and Reference describes the JPublisher tool for generating Java classes for SQL object and collection types.
- The SQLJ ANSI Standard `ANSI X3.135.10-1998` is available from http://www.ansi.org

# JPublisher

- Installation: follow the SQLJ installation steps. Specifically, you must have an Oracle JDBC driver (classesxxx.zip), translator.zip and runtime.zip in your CLASSPATH.

  IMPORTANT!
  While in previous releases, JPublisher only required translator.zip in the CLASSPATH, you now also have to supply runtime.zip (or, if you use JDK 1.1 and Oracle JDBC 8.1.7 you can specify runtime11.zip and under JDK 1.2 or later and JDBC 8.1.7 you can specify runtime12.zip).

- READMEJPub
- Documentation: JPublisher User's Guide and Reference
- JPublisher Demos: [Oracle Home]`/sqlj/demo/jpub/`