Before you start
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.
This two-part series aims to broaden your Web application development skills through the use of Rational Application Developer, Data Studio and Rational AppScan.
- Part 1 uses the IDE capabilities of Rational Application Developer and the pureQuery features of Data Studio to efficiently create a Java-based wealth management Web application.
- Part 2 takes advantage of the many Rational AppScan features available to harden/make secure the Java application by discovering vulnerabilities and fixing them so that you can be confident about deploying your Web application.
This tutorial shows you how to use Data Studio to develop applications more efficiently by automatically creating reliable database connection classes. The efficiencies provided by Data Studio are shown by creating a Java-based Web application using Rational Application Developer and Data Studio that is deployed to WebSphere Application Server. You will also learn how to create and set up an application using Rational Application Developer and Data Studio, including:
- Creating a DB2 database connection
- Creating a pureQuery enabled dynamic Web application
- Generating pureQuery code from database tables
- Augmenting pureQuery code with custom queries
- Creating JSP that uses the pureQuery classes
- Deploy and test on WebSphere Application Server
You'll learn and implement the above concepts by creating a wealth management Web application that users will be able to log into and view their various holdings. The delayed value of stock and options holdings will be grabbed from Yahoo! Finance API. You'll also create a form to manually add new real estate holdings.
For this tutorial you're only going to need three products:
-
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.
Note that this tutorial should work with future releases of Rational Application Developer and Data Studio that are compatible (for example, Rational Application Developer 7.0.0.7 and Data Studio 1.1.3, if these versions were to exist). Please refer to IBM as to which of these future versions will be compatible with each other. In the mean time, Rational Application Developer 7.0.0.6 and Data Studio 1.1.2 are known to be compatible with each other.


