Oracle SQLJ Release 9.2.0.1.0 Production

Requirements

SQLJ requires an installation of JDK1.1 or JDK1.2 or later 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 9.2.0.1.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 Oracle 9i Release 2 (9.2.0) 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.)

  3. Specifically, in order to use SQLJ you must have ORACLE_HOME/jdbc/lib/classesxxx.jar 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.

  4. Ensure that the directory ORACLE_HOME/bin is included in your environment variable PATH.
  5. You must add the files ORACLE_HOME/sqlj/lib/translator.jar and one of the ORACLE_HOME/sqlj/lib/runtimexxx.jar libraries. to the environment variable CLASSPATH.

  6. If you use JDK 1.1.x and Oracle JDBC 9.0.1 or later, use runtime11.jar. If you use JDK 1.2 or later and Oracle JDBC 9.0.1 or later use runtime12.jar. You can also use runtime12ee.jar if you have a J2EE environment.
    If you use an Oracle JDBC driver version prior to JDBC 9.0.1 use runtime.jar.
    If you do not have an Oracle JDBC driver in your environment use runtime-nonoracle.jar.

    IMPORTANT!

This completes the installation. 

Testing

To verify that your installation is correct, follow the instructions in the "Getting Started" section of theSQLJ 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-OCI  oracle.jdbc.driver.OracleDriver jdbc:oracle:oci:@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


JPublisher


Join the Oracle Technology Network for additional SQLJ and JDBC information, examples, and downloads.
Visit Oracle's Java Homepage for information and updates on JDBC, SQLJ and other Java technologies
This product is serviced through Oracle Support. For more information see http://www.oracle.com/support/.