Tutorial: SQL - Deploying an Enterprise JavaBean Containing JVM COBOL to a JBoss Application Server

As an extension to Deploying an Enterprise JavaBean Containing JVM COBOL to a JBoss Application Server, this tutorial shows you how to do the same thing with a SQL Server COBOL application using the Red Hat JBoss 7.1.1 application server.

The code logic in this tutorial differs from the Deploying an Enterprise JavaBean Containing JVM COBOL to a JBoss Application Server tutorial in that it uses a SQL Server SELECT statement in a COBOL file that does not use a FROM clause. This SELECT statement replaces a COMPUTE statement using an expression for the conversion calculation.

Restrictions

For a list of restrictions that apply to JVM COBOL and application server support, see the Application Servers section of the JVM COBOL Support topic under Known Issues and Restrictions > JVM Code.

Prerequisites

This tutorial begins where Tutorial: Deploying an Enterprise JavaBean Containing JVM COBOL to a JBoss Application Server left off, using the JBoss 7.1.1 application server, and the same TemperatureConverter, TemperatureConverterEJB, and TemperatureConverterPrj projects. Therefore, you must complete that tutorial in its entirety, using the JBoss 7.1.1 application server, before starting this tutorial. See Tutorial: Deploying an Enterprise JavaBean Containing JVM COBOL to a JBoss Application Server 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 the following topics:

  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 JBoss application server.
  2. Create and Load a SQL Server Database
    Create a SQL Server database and define a database connection.
  3. Modify COBOL Source
    Modify the COBOL source code in the TemperatureConverter project with new code to access your SQL Server database.
  4. Deploy the COBOL JVM Runtime
    Deploy the COBOL JVM runtime with the SQL runtime required to run the application.
  5. Run the JSP Application
    Run the TemperatureConverterJsp application on JBoss 7.1.1.
Parent topic: Managed COBOL Tutorials
Related concepts
Tutorial: Deploying an Enterprise JavaBean Containing JVM COBOL to a JBoss Application Server