Scenario 4: Oracle and Java

General Scenario Information contains useful information about the scenarios.

 

This scenario shows a JAVA standalone application on Windows using the Oracle JDBC Client connecting to Oracle on Solaris and accessing VSAM under VSE (CICS) via Oracle Heterogeneous Services.

 

Oracle_and_Java_example.bmp

 

This Oracle Heterogeneous Services example in this scenario is analogous to the SQL Server linked servers example outlined in a previous scenario.

 

The Java desktop application uses the Oracle JDBC driver to connect to an Oracle database and access both Oracle and VSAM data.

 

In this scenario, a legacy data source is accessed as if it were just another relational table. The user can create stored procedures and other routines as if the disparate data sets all belonged to the same database. CONNX provides the seamless connectivity and access to the legacy data source.

 

Store the CDD where the CONNX Core Client technology can access it; in our scenario, the CONNX client and CDD both reside on the Solaris machine.