Assembling data access applications

When you assemble enterprise bean code into files that can be deployed onto an application server, you configure properties that define how the application accesses an enterprise information system (EIS), such as a database. This topic assumes that you have created an enterprise application containing an EJB module that must transact with a database.

Overview

An application component uses a connection factory to access a connection instance, which the component then uses to connect to the underlying enterprise information system (EIS). Examples of connections include database connections, Java Message Service connections, and SAP R/3 connections.

During application assembly you perform activities that enable the application to use these resources. The process typically requires an assembly tool.

Procedure

1. Identify the logical names that are used by the EJB module to reference application resources. These logical names are called resource references.

   For further explanation, consult The benefits of using resource references topic.

2. Start an assembly tool.

3. If you have not done so already, configure the assembly tool for work on J2EE modules. Ensure that J2EE capability is enabled.

4. Define mapping and security properties for the resource references. This process includes the following activities:

   1. Bind the resource references to the application resources that provide database connectivity.

      See the Data source lookups for enterprise beans and Web modules topic for more information on the concept of binding. At deployment time you can alter your bindings if necessary.

   2. For each resource define an authentication type, which is the security configuration through which database connections are granted. There are two authentication types:

      Component-managed

      The enterprise bean code performs EIS signon for data source or connection factory connections.

      Container-managed

      WebSphere Application Server performs EIS signon.

      Consult the J2EE connector security topic for detailed reference on resource authentication.

5. Configure access intent assembly settings for your enterprise beans.

   1. Right-click your EJB module in a Project Explorer view and click Open With > Deployment Descriptor Editor.

   2. In an EJB Deployment Descriptor editor, select the Access tab.

   3. Under Isolation Level, click Add.

   4. Select the isolation level, enterprise beans, and method elements. For information on isolation levels, press F1.

   5. Click Finish.

6. Map enterprise beans to database tables. For an overview of the mapping options in the Application Server Toolkit, consult Approaches for mapping enterprise beans to database tables.

Results

What to do next

Related concepts

Related Reference

Related information