Access data from applications
Overview
Note: WebSphere Application Server does not support JDBC 3.0.
Various enterprise information systems (EIS) use different methods for storing data. These backend data stores might be relational databases, procedural transaction programs, or object-oriented databases. IBM WebSphere Application Server provides several options for accessing an information system's backend data store:
- Programming directly to the database through the JDBC 2.0 Optional Package API.
- Programming to the procedural backend transaction through various J2EE Connector Architecture (JCA) 1.0 compliant connectors.
- Programming in the bean-managed persistence (BMP) bean or servlets indirectly accessing the backend store through either the JDBC API or JCA compliant connectors. The prerequisite Web site details which databases and drivers are currently supported.
- Using container-managed persistence (CMP) beans.
- Using embedded Structured Query Language in Java (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.
- Develop data access applicationsDevelop your application to access data using the various ways available through the WebSphere Application Server. 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.Assemble your application by creating and mapping resource references.
- Deploy data access applicationsEnsure 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.
Resource adapter
Connection factory
JDBC providers
Data sources
Data access beans
Connection management architecture
Resource adapter archive file
Data access : Resources for learning