Web to Oracle Using Net Express and oo cobol

Web to Oracle Using Net Express and OO Cobol

• Alden C. Lorents

• College of Business

• Northern Arizona University

• Flagstaff, AZ

• [e-mail]

Introduction

• Next Wave After Y2K

• Web Development
• E-Commerce
• Linkage to Existing Systems
• Web, Java and Cobol

• Project to teach Web/Existing System Integration using Net Express

Project Components

• Web Component

• Forms and CGI Development
• Java Script

• Data Base Component

• Database Interface to Oracle
• OO Cobol
• Oracle Database Running on an NT Server

• Building, Packaging and Testing

Figure 1 Project Components

Building the Web Component

• Net Express IDE

• Building the Input and Output Forms with Form Designer
• Copy file generation from Designer
• Generating the CGI
• Adding Business Logic
• Adding Java Script

Input Form and IDE

Output Form and IDE

Form Designer Generated CPY

Form Designer Generated CPV

Form Designer Generated CPF

Generating the CGI

Partial List from Generated CGI

Adding CGI Data Division Entries

Adding CGI Business Logic

Generated Input HTML

Java Script Added to Input HTML

Generated Output HTML

Database Interface Component

• The PCO Source File

• Embedded SQL
• OO Structure and Methods

• The Oracle Precompile Process

• Error Correction

• The Cobol Compile Process

Partial DBI Source (PCO)

DBI Oracle Logon Method

DBI Read-Reservation Method

Oracle Precompile Process

Precompiled Read-Reservation

Compiling the DBI

Building and Testing

• Building the Executable

• Testing using Solo

• Animating
• CGI Animation
• DBI Animation - SQL Calls
• Testing the Java Script

• Migration to the Web Server

• Oracle Client
• Micro Focus OO Support

Net Express Build Set UP

Net Express Build Process

Testing Data Validation

Testing Good Data

Output From a Successful Test

Future Development

• Multiple Web Form Interaction

• More Robust System of Queries

• Database Updating

• Moving the System to a Web Server

• Oracle Client
• Micro Focus OO Support