Welcome
Getting started
Do and Learn
Access a database with EGL Rich UI
In this tutorial, you create a Rich UI application so that the user can access rows in an SQL database.
Lesson 10: Install Apache Tomcat
You can use Apache Tomcat to display the web page and to run the EGL-generated service.

Overview
Getting started
- Tutorials
- Do and Learn
  - Introducing EGL
    In this tutorial, you will learn how to build a simple dynamic web site using EGL. This site has two pages: one to display a list of records in a database and another to allow users to change the data from one of those records.
  - Create a hello world program with EGL
    In this tutorial, you will learn how to write and run your first EGL program. Although the program you create will not be powerful or complex, it will demonstrate how an EGL program works.
  - Create a hello world service with EGL
    In this tutorial, you will learn how to build a simple web service with EGL. Then, you will create a client that uses this service.
  - Create a mortgage application with EGL Rich UI
    Create a Rich UI application so that the user can do the following tasks: calculate monthly mortgage payments, given a loan amount and interest rate; display a pie chart that tells the interest and principal for the life of the mortgage; retrieve any of the payment calculations that were provided earlier to the same user; and display a map of the mortgage lenders who have offices in one or another U.S. zip code.
  - Access a database with EGL Rich UI
    In this tutorial, you create a Rich UI application so that the user can access rows in an SQL database.
    - Introduction
    - Lesson 1: Plan the application
      Design your application on paper before you begin coding.
    - Lesson 2: Connect to a new Derby database
      Use the Derby open source database manager to handle the data store for the application.
    - Lesson 3: Set up the projects and use the EGL SQL retrieve feature
      Before you write your logic, create two EGL projects, as well as a Record part that is based on the database table.
    - Lesson 4: Create the Rich UI handler
      Start to build the handler by using EGL wizards and then the Rich UI editor.
    - Lesson 5: Create the service
      Create a dedicated service to access the database.
    - Lesson 6: Add code for the service functions
      In EGL, I/O statements such as add and get access data that resides in different kinds of persistent data storage, from file systems to queues to databases. The coding is similar for the different cases.
    - Lesson 7: Create a library of reusable functions
      Create a library to format money values and to associate category numbers with descriptions.
    - Lesson 8: Add variables and functions to the Rich UI handler
      Add source code that supports the user interface.
    - Lesson 9: Complete the code that supports the user interface
      Next, you will complete the single-row layout, as well as the code that supports the Clear and Save buttons.
    - Lesson 10: Install Apache Tomcat
      You can use Apache Tomcat to display the web page and to run the EGL-generated service.
    - Lesson 11: Deploy and test the payment application
      During the deployment process, EGL creates HTML files and server-specific code to match your target environment.
    - Summary
      You completed the Access a database with EGL Rich UI tutorial.
    - Resources
      A variety of resources are available.
Installing
Upgrading and migrating
EGL Code Accelerator for IBD
Developing
Samples
Troubleshooting and support
EGL runtime error messages
Reference
Glossary
Using the help
Notices for IBM Business Developer documentation

Lesson 10: Install Apache Tomcat

You can use Apache Tomcat to display the web page and to run the EGL-generated service.

Download and access the server

About this task

If you have IBM® WebSphere® Application Server installed, you can skip to the next lesson. In any case, you can download Apache Tomcat, if necessary, and make it available in the workbench.

Procedure

To gain access to server:

Locate the Servers view, which is by default at the lower right of the workbench. EGL created an AJAX Test Server by default. Right-click the empty space and click New > Server.
In the Define a New Server window, expand Apache and click Tomcat v6.0 Server with EGL debugging support. Accept the default values for the other fields. Click Next.
In the Tomcat Server window, access the open-source software either by using the Browse to find an existing installation directory (for example, apache-tomcat-6.0.26) on your machine; or click Download and Install. If you found an existing installation directory, click Finish and continue the lesson at step 5.

Accept the terms of the license agreement. Browse to a directory for the application files, such as C:\Program Files\Apache. While the workbench completes the installation, the Define a New Server window is displayed with the installation directory specified. Progress is shown at the lower right of the workbench.
When the installation is completed, click Finish.
Start the server by highlighting the server name and clicking the green Start icon at the top of the Server view.

Lesson checkpoint

About this task

In this lesson, you completed the following tasks:

Downloaded Apache Tomcat, if necessary
Started the server.

In the next lesson, you deploy the application to a server and run it there.