Accessing federated databases with application server components

Level: Introductory

Cynthia M. Saracco (saracco@us.ibm.com ), Senior Software Engineer, IBM
Tim Rieger , Student, University of Rostock, Germany

04 Feb 2003

	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

	Information about download methods			Get Adobe® Reader®

Resources

• 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.
  
  

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

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

About the authors

		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.

		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.

Rate this content

Please take a moment to complete this form to help us better serve you. Did the information help you to achieve your goal? Yes No Don't know   Please provide us with comments to help improve this page:   How useful is the information? 1 2 3 4 5 Not useful Extremely useful

Back to top