Deploy data access applications

 

Overview

Before installing a data access application into the WebSphere Application Server environment, first ensure that the appropriate database objects are available. This action includes creating and configuring any databases or tables required, setting necessary configuration parameters to handle expected load, and configuring any necessary JDBC providers and data source objects for servlets, enterprise beans, and client applications to use.

 

Procedure

1. If your database configuration does not already exist:

   1. Create a database to hold the data.

   2. Create tables required by your application.

      If your application uses entity enterprise beans to access the data

      We can create the tables using the data definition language (DDL) generated from the enterprise bean configuration. For more information, see Recreating database tables from the exported table data definition language.

      If your application does not use entity beans

      You must use your database server interfaces to create the tables.

   3. See Minimum required properties for vendor-specific data sources for certain vendors' database requirements.

2. Migrate V4.0 data access applications

3. If your enterprise application contains a Web application or an EJB application that uses connection pooling to access a relational database, see Creating and configuring a JDBC provider and data source .

4. If your application requires access to a non-relational database, we need to configure a resource adapter and a connection factory rather than a JDBC provider and a data source.

5. If your enterprise application contains an application client that accesses a relational database, see Configuring data access for application clients.

6. Consider the security of lookups with component managed authentication. See Security of lookups with component managed authentication for more information.

 

See also

Relationship of assembly and administrative console data access settings
Installing J2EE Connector resource adapters
Pretesting pooled connections to ensure validity
Creating and configuring a JDBC provider and data source
Configuring J2EE Connector connection factories in the administrative console
Security of lookups with component managed authentication
Configuring data access for application clients using the assembly tool and ACRCT
Configuring Cloudscape V5.1.60x
DB2 tuning parameters
Connector modules collection

 

See Also

JDBC providers
Data sources
Connection pooling
Resource adapter
Connection factory

 

See Also

Vendor-specific data sources minimum required settings

 

---