The first time you sign into developerWorks, a profile is created for you. Select information in your profile (name, country/region, and company) is displayed to the public and will accompany any content you post. You may update your IBM account at any time.

All information submitted is secure.

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

All information submitted is secure.

My developerWorks:

My notifications:

Sign out

Select a language:

Accessing federated databases with application server components

Cynthia M. Saracco (saracco@us.ibm.com), Senior Software Engineer, EMC

Cynthia M. Saracco works on database management and XML technologies at IBM's Silicon Valley Lab. She has co-authored three books and taught university-level courses on various software technologies.
(An IBM developerWorks Professional Author)

Tim Rieger, Student, University of Rostock, Germany

Tim Rieger is a student of Business Informatics at the University of Rostock, Germany. He recently completed an internship at IBM's Silicon Valley Laboratory, where he researched issues involving entity EJBs and database management systems.

Summary: This article describes how a federated DBMS, such as DB2 Information Integrator, and Web application server technologies can be combined to provide Java developers with new options for integrating data from a variety of sources.

Date: 04 Feb 2003
Level: Introductory

Activity: 1820 views
Comments:

Get the download

This article describes how a federated DBMS, such as DB2® Information Integrator, and Web application server technologies can be combined to provide Java™ developers with new options for integrating data from a variety of sources.

In this article

Introduction to key technologies
Software architecture involving WebSphere and IBM federated technology
Creating a session bean to access federated data
Working with federated data and CMP entity beans
Creating a CMP entity bean for an existing nickname
Creating a CMP entity bean for a new nickname
Creating a CMP entity bean spanning multiple data sources
Using SQLJ code in CMP entity beans
Creating a Web service to access federated data
Tips for successful deployment

Overview

This article describes how Java developers can employ federated database management technology to expand the reach of the server-side components they build. Techniques discussed illustrate how Java developers can transparently work with multiple data sources without installing a variety of client software, establishing direct connections to these data sources, or possessing detailed knowledge about the differences between these data sources. With federated database technology, Java developers can create components that join or union data from multiple sources, including container-managed entity Enterprise JavaBeans (EJBs).

Download

Description	Name	Size	Download method
Article in PDF format	0302saracco.pdf	128KB	HTTP

Information about download methods Get Adobe® Reader®

Resources

Learn

developerWorks Information Management zone: Learn more about DB2. Find technical documentation, how-to articles, education, downloads, product information, and more.
Stay current with developerWorks technical events and webcasts.

Get products and technologies

Build your next development project with IBM trial software, available for download directly from developerWorks.

Discuss

Participate in developerWorks blogs and get involved in the developerWorks community.

Biographies

Cynthia M. Saracco works on database management and XML technologies at IBM's Silicon Valley Lab. She has co-authored three books and taught university-level courses on various software technologies.

Comments