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.

  1. Install and Configure a JDBC Driver
    Download and install a SQL Server JDBC driver to use in this tutorial; then make the driver available to the Apache Tomcat application server.
  2. Create a SQL Server Database and Connection
    Create a SQL Server database, define a database connection to the database, and load the database using a provided SQL script.
  3. Modify COBOL Source
    Modify the COBOL source code in the CobolBook project, or replace the existing COBOL source with new code to access your SQL Server database.
  4. Modify Java Source
    Modify the Java source code in the JSPBookDemo project to access the SQL Server database.
  5. Add and Modify XML
    Create a new context.xml file, and modify the existing web.xml file.
  6. Run the JSP Application
    Run the JSPBookDemo application on Tomcat 7.
  7. Modifications for DB2 LUW
    Modifications to the tutorial for using a DB2 LUW database instead of a SQL Server database.
  8. Modifications for Oracle
    Modifications to the tutorial for using an Oracle database instead of a SQL Server database.
Parent topic: Web Services Tutorials
Related concepts
Tutorial: Reusing Existing COBOL Programs in a Java Web Services Environment