Creating a multi-page SDO application with Faces JSPs

The concept of a multi-page SDO application is so you can have one page in the application to serve as a 'master' page that manages the interaction with the database. All the other pages are 'detail' pages where a user can change information, but the updated information does not get committed to the database until the master page is submitted to the server. The Relational, SAP, Domino®, Siebel and PeopleSoft SDO tooling in the Rational® Development Software Platform helps you to easily create a multi-page SDO application. Plus, new Quick Edit snippets, Find Sub Record, Find Record List, and Create Sub Record, and enhancements to the SDO wizard allow you to create multi-page SDO applications with minimal coding.

The task set below contains all the instructions you need to create a simple multi-page SDO application. You create a page to serve as the master update page that contains the database fields to update, such as department name, manager number, location, and so on. This page also displays a list of information, such as the employees in a department. Then, the second page you create updates details of other database fields, such as information about a new employee in a department. While this might seem pretty standard, note that the second page does not actually access the database; any changes made on this second page are not committed to the database until the master page is submitted. For example, new employees created on the second page are not added to the database until the master 'department' page has accessed the database.

Follow this set of tasks to create a simple, multi-page SDO application:
Note: The DB2® V8.2 SAMPLE database is used for reference in many steps. If you have access to the SAMPLE database, you can follow all the steps and create a set of Web pages that updates and manages a department and its employee information.

Feedback