Oracle Audio Technologies 9i manual OCI8 Jdbc Driver

OCI8 JDBC Driver

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.7OCI8 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

Overview 1-11