7 oci8 jdbc driver, Section 1.7, "oci8 jdbc driver, 7 oci8 jdbc driver – Oracle Audio Technologies Application 9i User Manual

Page 27

Advertising
background image

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

Advertising