OCI8 JDBC Driver
Overview 1-11
2.
From the Edit menu, select Preferences, and then Configuration.
3. Enter the Proxy (HTTP) and the Secure Proxy (HTTPS) settings appropriate for
your environment.
4. Click OK.
1.7 OCI8 JDBC Driver
The default configuration of Wireless Edition uses the Oracle THIN JDBC driver.
For a production environment, the Oracle OCI8 JDBC driver is required, as it
provides improved performance, concurrency, scalability, and multi-byte support.
Additionally, this driver is required if the Oracle Parallel Server option is used.
To configure Wireless Edition to use the Oracle OCI8 driver:
1. Verify that ORACLE_HOME is the directory under which Wireless Edition has
been installed.
a. On Windows: Modify the jserv.properties file to include the PATH of the
directory where the OCI library (ocijdbc8.dll) is installed. The default is
ORACLE_HOME\bin.
wrapper.path=<ORACLE_HOME>\bin
b.
On UNIX: Verify that the LD_LIBRARY_PATH environment variable
includes the directory where the OCI libraries (libocijdbc8.so and
libocijdbc8_g.so) are installed. The default is ORACLE_HOME/lib.
2. Modify the System.properties file to change the driver and the connect string
settings.
db.connect.string=%WE_REPOSITORY_USERNAME%/%WE_REPOSITORY_USER_
PW%@(description=(address=(host=%WE_REPOSITORY_
HOST%)(protocol=tcp)(port=%WE_REPOSITORY_PORT%))(connect_data=(sid=%WE_
REPOSITORY_SID%)))
db.driver=V8