|Oracle8i SQLJ Developer's Guide and Reference
Release 3 (8.1.7)
Part Number A83723-01
This section discusses basic assumptions about your environment and requirements of your system so that you can run Oracle SQLJ.
The following assumptions are made about the system on which you will be running Oracle SQLJ.
java) and your Java compiler (typically
To translate and run Oracle SQLJ applications on a Sun JDK you must use a JDK 1.2.x or 1.1.x version, with an appropriate JDBC driver. There are Oracle JDBC Thin and OCI drivers for either of these JDK versions.
For more information, see "Supported JDK Versions".
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. You can also refer to Chapter 1, "Overview", of that document for information about the Oracle JDBC drivers and how to decide which is appropriate for your situation.
If you are using a non-Oracle JDBC driver, you must do the following:
The following are required to use Oracle SQLJ:
java.sqlJDBC interfaces from Sun Microsystems
Oracle SQLJ works with any JDBC driver that complies with standards.
Translator-related classes are available in the file:
Several SQLJ runtime versions are available -- you must select a runtime version that is compatible with your Java environment and JDBC driver (these are all in
runtime.zip--a generic runtime that works with all Oracle JDBC drivers and with all JDK environments
runtime11.zip--an Oracle 8.1.7-specific runtime that works under JDK 1.1.x
runtime12.zip--an Oracle 8.1.7-specific runtime that works under JDK 1.2 or higher and provides full SQLJ ISO functionality
runtime12ee.zip--an Oracle 8.1.7-specific runtime that works in an environment that complies with J2EE and provides full SQLJ ISO functionality
In SQLJ release 8.1.6 and earlier,
If you are using a Sun Microsystems JDK, note that Oracle SQLJ release 8.1.7 works in both the JDK 1.2.x and JDK 1.1.x environments. You can use
translator.zip in conjunction with
runtime.zip to work in either environment. Or, if you are employing the Oracle JDBC 8.1.7 driver, you can use
translator.zip with one of the
runtime12ee.zip files, depending on whether your Java environment supports JDK 1.1.x, JDK 1.2, or J2EE.
Note the following regarding migration of SQLJ source code:
oracle.jdbc2package. This is how Oracle JDBC supported JDBC 2.0 types under JDK 1.1.x.)
Be sure to use an appropriate version of the JDBC driver. See "PATH and CLASSPATH for Oracle JDBC".
Note that as of release 8.1.7, neither Oracle SQLJ nor Oracle JDBC support JDK 1.0.2. This includes applets running in browsers that use JDK 1.0.2 except where special preparations have been made. (This chapter does not discuss applets. Refer to "Running SQLJ in Applets".)
This guide presumes that system configuration issues are outside the duties of most SQLJ developers. Therefore, configuration of the Oracle8i JServer (formerly known as the Java Option) is not covered here. For information about setting Java-related configuration parameters (such as
JAVA_POOL_SIZE), see the Oracle8i Java Developer's Guide.
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.