Create Secure Java Applications Productively, Part 1: Use Rational Application Developer and Data Studio

This is the first in a two-part tutorial series creating secure Java-based Web applications using Rational Application Developer, Data Studio and Rational AppScan. This first tutorial begins by showcasing how Data Studio with pureQuery can increase the efficiency of your database-driven Web development. You will be developing a Java Web application with Rational Application Developer, and then with Java Server Pages (JSP) you will deploy the application on WebSphere Application Server.

May 15, 2008

Level: Introductory

Tyler Anderson (tyleranderson5@yahoo.com), Freelance writer and developer, Backstop Media

14 Apr 2008

This is the first in a two-part tutorial series creating secure Java-based Web applications using Rational® Application Developer, Data Studio and Rational AppScan. This first tutorial begins by showcasing how Data Studio with pureQuery can increase the efficiency of your database-driven Web development. You will be developing a Java™ Web application with Rational Application Developer, and then with Java Server Pages (JSP) you will deploy the application on WebSphere® Application Server.

Objectives

Create a DB2 database connection
Create a pureQuery enabled dynamic Web application
Generate pureQuery code from database tables
Augment pureQuery code with custom queries
Create JSP that uses the pureQuery classes
Deploy and test on WebSphere Application Server

Prerequisites

This tutorial is recommended for Java and database application developers who want to take advantage of using Data Studio for its pureQuery capabilities and Rational Application Developer to facilitate the development of a Java-based Web application. Knowledge of JSP and Web development in general is also useful for this tutorial, but is not required.

System requirements

To complete the steps in this tutorial, you need the following software installed:

Rational Application Developer
Get a trial version of Rational Application Developer 7.0.0.6 from IBM (click Download using the new IBM Installation Manager (recommended) link). You'll use Rational Application Developer as a full featured Eclipse based IDE for developing your Java Web application.
Data Studio
This free plugin contains the pureQuery capabilities you'll use for efficient database driven Web development. This tutorial requires version 1.1.2 (the only version compatible with Rational Application Developer 7.0.0.6).
DB2 Express-C
Data Studio requires a live database connection to generate pureQuery code for. This tutorial uses DB2 Express-C for the database.
Duration
Less than 1 hour
Formats
html, pdf