This section describes the steps required to set the
environment to run the sample on Windows platform.
1. set <JAVA_HOME> environment variable
to point your JDK(version 1.3 or above) installation directory.
set JAVA_HOME = <JAVA_HOME>
for example, D:\> set JAVA_HOME = d:\jdk1.3
2. Add <JAVA_HOME>\bin to system PATH.
set PATH=<JAVA_HOME>\bin;%PATH%
for example, D:\> set PATH = %JAVA_HOME%\bin;%PATH%
3. Set <JDBC_LIB> environment variable to point to
the directory where the Oracle JDBC driver files(classes12.jar/zip
and nls_charset12.jar/zip) exist.
set JDBC_LIB=<JDBC_LIB>
for example, D:\> set JDBC_LIB = d:\oracle\jdbc\lib
4. Set <SQLJ_LIB> environment variable to point
to the directory where the Oracle SQLJ translator and runtime files(translator.jar
and runtime12ee.jar) exist.
set SQLJ_LIB=<SQLJ_LIB>
for example, D:\> set SQLJ_LIB = d:\oracle\sqlj\lib
5. Set <SQLJ_EXE_HOME> environment variable to point
to the directory where the SQLJ executable exists.
set SQLJ_EXE_HOME=<SQLJ_EXE_HOME>
for example, D:\> set SQLJ_EXE_HOME = d:\oracle\bin
6. Set <CLASSPATH> to include Oracle9i
JDBC Driver and SQLJ translator and runtime files: classes12.jar/zip,nls_charset12.jar/zip,
translator.jar and runtime12ee.jar
set CLASSPATH=%CLASSPATH%;<full path of jars>
for example, D:\> CLASSPATH = %CLASSPATH%;d:\oracle\jdbc\lib\classes12.jar;
d:\oracle\jdbc\lib\nls_charset12.jar; d:\oracle\sqlj\lib\translator.jar;
d:\oracle\sqlj\lib\runtime12ee.jar
This section describes the steps required to set the environment
to run the sample on Linux platform [Bourne shell].
1. set <JAVA_HOME> environment variable
to point your JDK(version 1.3 or above) installation directory.
export JAVA_HOME = <JAVA_HOME>
for example, $ export JAVA_HOME=/home/usr/jdk1.3
2. Add <JAVA_HOME>\bin to system PATH.
export PATH=<JAVA_HOME>/bin:$PATH
for example, $ export PATH=$JAVA_HOME/bin:$PATH
3. Set <JDBC_LIB> environment variable to point to
the directory where the Oracle JDBC driver file(classes12.jar/zip
and nls_charset12.jar/zip) exist.
export JDBC_LIB=<JDBC_LIB>
for example, $ export JDBC_LIB = /home/orahome/jdbc/lib
4. Set <SQLJ_HOME> environment variable to point
to the directory where the Oracle SQLJ translator and runtime files(translator.jar
and runtime12ee.jar) exist.
export SQLJ_LIB=<SQLJ_LIB>
for example, $ export SQLJ_LIB = /home/orahome/sqlj/lib
5. Set <SQLJ_EXE_HOME> environment variable to point
to the directory where the SQLJ executable exists.
export SQLJ_EXE_HOME=<SQLJ_EXE_HOME>
for example, $ export SQLJ_EXE_HOME = /home/orahome/bin
6. Set <CLASSPATH> to include Oracle9i
JDBC Driver and SQLJ translator and runtime files: classes12.jar/zip,nls_charset12.jar/zip,
translator.jar and runtime12ee.jar
export CLASSPATH=$CLASSPATH:<full path of jars>
for example, $ export CLASSPATH = $CLASSPATH%: /home/orahome/jdbc/lib/classes12.jar:
/home/orahome/jdbc/lib/nls_charset12.jar: /home/orahome/sqlj/lib/translator.jar:
/home/orahome/sqlj/lib/runtime12ee.jar