Tutorial: Reusing Existing SQL Programs in a Java Environment

As an extension to Tutorial: Reusing Existing COBOL Programs in a Java Web Services Environment, this tutorial shows you how to do the same thing with an SQL COBOL application using SQL Server and the Tomcat 7 application server. Additional information regarding DB2 LUW and Oracle applications is also provided.

Prerequisites

This tutorial begins where Tutorial: Reusing Existing COBOL Programs in a Java Web Services Environment left off, using the Apache Tomcat application server, and the same CobolBook and JSPBookDemo projects. Therefore, you must complete that tutorial in its entirety, using the Tomcat 7 application server, before starting this tutorial. See Tutorial: Reusing Existing COBOL Programs in a Java Web Services Environment for complete instructions.

You must also install Microsoft SQL Server 2008 or later, configured for SQL Server authentication.

Outline

After completing the prerequisite tutorial, complete this tutorial by following the instructions in topics 1 through 6 in the order listed. These topics walk you through the demonstration using a SQL Server database. If you want to use a DB2 database, start with Modifications for DB2 LUW. To use an Oracle database, start with Modifications for Oracle.