WebSphere Application Server Network Deployment, Version 6.0.x     Operating Systems: AIX, HP-UX, Linux, Solaris, Windows

Deploying data access applications

Why and when to perform this task

Before installing a data access application into the WebSphere Application Server environment, you must 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.

Steps for this task

  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
      You 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 Version 4.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, you 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.



Sub-topics
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 Version 5.1.60x
DB2 tuning parameters
Connector modules collection

Related concepts
JDBC providers
Data sources
Connection pooling
Resource adapter
Connection factory

Related reference
Vendor-specific data sources minimum required settings

Task topic    

Terms of Use | Feedback

Last updated: Mar 17, 2005 4:28:29 AM CST
http://publib.boulder.ibm.com/infocenter/ws60help/index.jsp?topic=/com.ibm.websphere.nd.doc/info/ae/ae/tdat_dadep.html

© Copyright IBM Corporation 2002, 2005. All Rights Reserved.
This information center is powered by Eclipse technology. (http://www.eclipse.org)