IBM WebSphere and VisualAge for Java Database Integration with DB2, Oracle, and SQL Server (IBM Redbook)

With the move of Java applications to a servlet runtime environment on a Web server, the access of relational databases on the Web server becomes one of the most important topics. IBM WebSphere is a set of software products that help customers develop and manage high-performance Web sites to ease the transition from simple Web publishing to advanced e-business applications.

VisualAge for Java Enterprise is the premier Java integrated development environment that helps customers connect their Java applications to their enterprise data. VisualAge for Java provides an integrated WebSphere Test Environment that makes development and deployment of servlets to WebSphere fast and easy.

In this redbook we describe many ways of how relational database systems can be integrated with the VisualAge for Java development environment and the WebSphere execution environment.

First, we describe the installation of the underlying base products IBM WebSphere and VisualAge for Java. Next, we describe the installation and setup of the database systems and JDBC drivers for the three relational database management systems DB2 Universal Database, Oracle, and Microsoft SQL Server. Finally, we provide small programming examples for JDBC, data access beans, the Persistence Builder, Enterprise JavaBeans, WebSphere Studio, User Profiles, Security and Directory Services, and SQLJ.

This redbook is especially suited for Java application designers that are implementing servlets with relational database access.