Kbase 18026: Configuring Oracle 8 JDBC drivers with Apptivity OCI & Thin
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
14/12/1998 |
|
Configuring Oracle 8 JDBC drivers with Apptivity OCI & Thin
Configuring Oracle 8 Jdbc drivers with Apptivity, OCI and thin drivers
Oracle now has version 8 jdbc drivers that can be used to connect to
a version 8 Oracle database. These can be downloaded for free
from the Oracle web site (www.oracle.com).
The JDBC thin driver may be used against an NT 8.0.3 server but it
requires a patch. For more information about the patch please see
the Oracle web site. The JDBC OCI driver requires "Required
Support Files (RSF) version 8.0.4.x.x.". This needs to be installed
before using the JDBC OCI driver.
These instructions assume that you are using an NT 8.0.4. Oracle
server and that you are installing the JDBC drivers on NT 4.0 or
Win95.
Install the drivers by following the instructions provided when
downloading. Ensure that [ORACLE_HOME]\jdbc\lin\classes111.zip
is added to your CLASSPATH. This needs to be added to both the
system CLASSPATH and to the Apptivity project properties
CLASSPATH for testing the configuration within Apptivity developer
using a browser or java VM. It does not need be set in set in the
project CLASSPATH for testing in applet viewer.
You may get the following error if the CLASSPATH is not set up
correctly:
Connection to dcOracle failed:Connection failed(2):
oracle.jdbc.driver.OracleDriver
where dcOracle is the name of the data connection defined within
Apptivity.
To verify that the CLASSPATH is set correctly you can type "set" at a
DOS prompt. If the CLASSPATH does not include the oracle
classes111.zip then it has not been set correctly.
In the data connection property sheet select Native for the JDBC
driver:
Driver: oracle.jdbc.driver.OracleDriver
For the JDBC thin driver
Database URL: jdbc :oracle:thin:@hostname:port:sid
e.g. jdbc:oracle:thin:@pclab1:1521:orcl
For the JDBC OCI driver
Database URL: jdbc :oracle:oci8:@database_name
e.g. jdbc:oracle:oci8:@Oracle8Test.world
The database_name corresponds to an entry in tnsnames.ora or a
SQL*net name-value pair.
When using the JDBC OCI drivers, make sure that the location of the
oci804jdbc.dll is included in the PATH variable.
You can test the JDBC connection outside of Apptivity using the sample
java programs that are provided with the jdbc drivers. These should
be located in [ORACLE_HOME]\jdbc\samples.
PES 06/16/98