Configuring Oracle

Oracle JDBC drivers must be configured properly to be compliant with J2EE 1.4. Use the following configuration for Type 2 and Type 4 drivers:

To configure Oracle

1. Use the JDBC driver from 9.2.0.3 or later.

2. The Oracle database needs to have compatible=9.0.0.0.0 or higher in its parameter (init.ora) file.

3. Use the ojdbc14.jar file.

4. Configure the Application Server to define the following JVM property:

   -Doracle.jdbc.J2EE13Compliant=true

   In addition, for Type-2 drivers, both the ORACLE_HOME and LD_LIBRARY_PATH variables (which must include $ORACLE_HOME/lib) need to be defined in the environment in which the Application Server is started. For example, add them to the asenv.conf file and ensure they are exported.