WAS v8.5 > End-to-end paths > Data access resourcesTasks: Access data from applications
Overview
Enterprise information systems (EIS) use different methods for storing data in backend data stores, including relational databases, procedural transaction programs, or object-oriented databases.
IBM WebSphere Application Server options...
- Programming directly to the database through the JDBC 4.0 API, JDBC 3.0 API, or JDBC 2.0 optional package API.
- Programming to the procedural backend transaction through various JCA 1.0 or 1.5 compliant connectors.
- Bean-managed persistence (BMP) bean or servlets indirectly accessing the backend store through either the JDBC API or JCA-compliant connectors.
- Container-managed persistence (CMP) beans.
- Embedded SQLJ support with applications that use DB2 as a backend database.
- IBM data access beans
Procedure
- Develop data access applications.
Develop the application to access data using the various ways available through the application server. We can access data through APIs, container-managed persistence beans, bean-managed persistence beans, session beans, or web components.
- Assemble data access applications using the assembly tool
Assemble the application by creating and mapping resource references.
- Prepare for deployment by ensuring the appropriate database objects are available
Create or configure any databases or tables required, set necessary configuration parameters to handle expected load, and configure any necessary JDBC providers and data source objects for servlets, enterprise beans, and client applications to use.
- Install the application on the application server
Related
- Relational resource adapters and JCA
- JDBC providers
- Data sources
- Data access beans
- Connection management architecture
- Cache instances
- Use object cache instances
- Develop data access applications
- Assemble data access applications
- Deploy data access applications
- Administer data access applications
- Develop data access applications.
- Assemble data access applications using the assembly tool.
- Prepare for deployment by ensuring the appropriate database objects are available.
- Install the application on the application server.
- Install enterprise application files
- J2C Administered Objects page
- J2C Activation Specifications page
- WebSphere Application Server prerequisite website