Access data from applications
WebSphere Application Server provides several options for accessing Enterprise Information System (EIS) backend databases.
- Program directly using the JDBC 2.0 Optional Package API.
- Programming to a procedural backend transaction through various JCA connectors.
- Program BMP beans or servlets to indirectly access the backend store through either the JDBC API or JCA-compliant connectors.
- Using CMP beans.
- Using embedded SQLJ support with applications that use DB2 as a backend database.
- Using the IBM data access beans, which also use the JDBC API, but give you additional ability to manipulate result sets.
Programming steps include:
- Develop data access applications
Develop your application to access data using the various ways available through the WAS. You 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 Toolkit.
Assemble your application by creating and mapping resource references.
- Deploy data access applications
Ensure that 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.
See AlsoResource adapter
Data access beans
Connection management architecture
Resource adapter archive file
Data access : Resources for learning