Kbase 17652: Apptivity: deploying with Oracle JDBC thin client.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
Apptivity: deploying with Oracle JDBC thin client.
This K-base identifies the needed parameters and settings to get a
JDBC connection to the Oracle database through the thin JDBC client
from Oracle.
To develop the application you need an ODBC driver for the Oracle
Database. For this you can use the Oracle73 Ver 2.5 ODBC driver from
Oracle. This requires that SQL*NET2 is installed and working.
The JDBC thin client does not require any Oracle components installed
where it is going to be used.
When creating the Data Connection in Apptivity and choosing the
ODBC connection, you can click on the Native Radio button to give the
parameters for a Native connection.
In the Driver fill-in:
oracle.jdbc.driver.OracleDriver
In the Database URL:
jdbc:oracle:thin:@<hostname>:<Oracle-listener port#>:<Oracle SID >
ex: jdbc:oracle:thin:@hostname:3033:ora73
These parameters need to be correct for a connection and remember that
it is all case-sensitive. It is possible that the notation can be
different between versions of the JDBC but then you'll need to read
the documentation on the driver or checkout the examples that come
with it.
The JDBC class files come in zip format so to get access to them you
need to get the .zip file into your CLASSPATH on your development
and deployment system. When the CLASSPATH includes the .zip file,
the apptivity server is able to make the Oracle connection through
JDBC.
TBO: 02/04/98
Progress Software Technical Support Note # 17652