data access resources


How do I?...



Establish data access using enterprise beans

  Develop enterprise beans
  Assemble beans into a data access application
  Map the beans to database tables
  Configure access to a relational database


Configure access to a non-relational database

  Create a resource adapter
  Create a connection factory


Establish data access without using enterprise beans

  Use optional IBM data access beans
  Verify your database vendor requirements (for relational databases)
  Configure access to a relational database


Configure access to a database

Set up JDBC - Cloudscape database
Set up JDBC - DB2 database
Set up JDBC - Oracle database


Establish data access using SDO

  The Service Data Objects framework


Logically name the new resource

  Establish resource references


Deploy your data access application

  Install application files (same as any application type)
  Deploy applications (IBM Education Assistant)
  Administer applications (IBM Education Assistant)


Test and monitor database connections

  Test connections
  Remedy stale connections
  Use the JDBC connection pool counter for relational databases
  Use the J2C connection pool counter for non-relational databases
  Resolve connectivity issues specific to database type


Conceptual overviews

Documentation Introduction: Data access resources
Presentations IBM Education Assistant offers:


See also the IBM Redbook DB2 UDB V8 and WebSphere V5 Performance Tuning and Operations Guide



developerWorks offers:

  • Tutorial 5 - Java Connector Architecture (JCA 1.5)

    This tutorial illustrates the Java Connector Architecture (JCA), which defines the standards that allow J2EE application servers to interact with a back-end. This is called an Enterprise Information System (EIS). With JCA 1.5, it is possible for a back-end system to initiate communications towards the J2EE application server, and to propagate a transactional context too. The EIS will control the transaction boundaries in this scenario, the J2EE container acts as a transactional resource controlled by the EIS. The zip file comes with all sample code required to run this tutorial.



The Samples Gallery offers:

  • WebSphere Bank

    Using the WebSphere Bank online bank, customers can open accounts, get account balances, and transfer funds between accounts. The WebSphere Bank application uses Web services, Java Message Service (JMS) API, container-managed persistence (CMP), container-managed relationships (CMR), stateless session beans, Message Driven Beans (MDB), JCA 1.5 API, JSP pages, and servlets.

  • Album catalog

    Album Catalog illustrates access to relational data in a web application via Service Data Objects (SDO) and JDBC Mediator. It illustrates the use of SDOs and JDBC Mediator to display and manipulate data from a relational database in a disconnected fashion.




WebSphere is a trademark of the IBM Corporation in the United States, other countries, or both.
IBM is a trademark of the IBM Corporation in the United States, other countries, or both.