Getting Started

Assumptions and Requirements

This section discusses basic assumptions about your environment and requirements of your system so that you can run Oracle SQLJ.

Assumptions About Your Environment

The following assumptions are made about the system on which you will be running Oracle SQLJ.

You have a standard Java environment that is operational on your system. This would typically be using the Sun Microsystems JDK, but other kinds of Java are permissible.

To translate and run Oracle SQLJ applications on a Sun JDK you must use a JDK 1.1.x version. SQLJ does not support JDK 1.0.2, including applets running in browsers that use that JDK, unless special preparations have been made. (Applets are not discussed here. Refer to "Running SQLJ in Applets".)

Make sure you can run Java (typically java) and your Java compiler (typically javac).

You can already run JDBC applications in your environment.

If you are using an Oracle database and Oracle JDBC driver, then you should complete the steps in Chapter 2, "Getting Started", of the Oracle8i JDBC Developer's Guide and Reference. This chapter also includes introductory information about the Oracle JDBC drivers and how to decide which driver is appropriate for your situation.

Notes:

Oracle JDBC drivers do not yet support JDK 1.2; however, Oracle SQLJ supports JDK 1.2 in case you are using a non-Oracle JDBC driver that supports it as well.

If you are using a non-Oracle JDBC driver, then you must modify connect.properties, as discussed in "Set Up the Runtime Connection", and the sample applications, as discussed in "Driver Selection and Registration for Runtime", so that your driver is registered before the call to the Oracle.connect() method.

Requirements for Using Oracle SQLJ

The following are required in order to use Oracle SQLJ:

JDBC driver implementing the standard java.sql JDBC interfaces from Sun Microsystems

Oracle SQLJ works with any standards-compliant JDBC driver.
database system that is accessible using your JDBC driver
class files for the SQLJ translator, SQLJ profile customizer, and SQLJ runtime

These class files are all available in the file:
```
[Oracle Home]/sqlj/lib/translator.zip
```

Note:
If you have a system where you will only be running SQLJ applications that have already been translated, compiled, and customized, you will need only the runtime classes, not the translator or profile customizer classes. The runtime classes are in the file:
[Oracle Home]/sqlj/lib/runtime.zip
This is a subset of the translator.zip file.

JServer Configuration

This document presumes that system configuration issues are outside the duties of most SQLJ developers. Therefore, configuration of the Oracle8i JServer (formerly referred to as the Java Option) is not covered here. For information about setting Java-related configuration parameters (such as JAVA_POOL_SIZE), see the JServer README file.

If you need information about configuring the multi-threaded server, dispatcher, or listener (which may be particularly relevant if you are coding Enterprise JavaBeans or CORBA objects), see the Net8 Administrator's Guide.