Use the JDBC driver from 9.2.0.3 or later.
The Oracle database needs to have compatible=9.0.0.0.0 or higher in its parameter (init.ora) file.
Use the ojdbc14.jar file.
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.