Task overview: Accessing data from applications
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 backend data store:
- 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 Java EE Connector Architecture (JCA) 1.0 or 1.5 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.
- Use container-managed persistence (CMP) beans.
- (dist)(zos) Use embedded Structured Query Language in Java (SQLJ) support with applications that use DB2 as a backend database.
- The IBM data access beans also use the JDBC API, and give you a rich set of features and function that hide much of the complexity associated with accessing relational databases.
For all these options, except for using the JCA 1.0 or 1.5 compliant connectors, the prerequisite website details the databases and drivers that are currently supported.
- Develop data access applications.
- Assemble data access applications using the assembly tool.
- Prepare for deployment by ensuring that the appropriate database objects are available.
- Install the application on the application server.
Subtopics
- Develop data access applications.
- Assemble data access applications using the assembly tool.
- Prepare for deployment by ensuring that the appropriate database objects are available.
- Install the application on the application server.
Related concepts
Relational resource adapters and JCA JDBC providers Data sources Data access beans Connection management architecture Cache instances
Related tasks
Use object cache instances Develop data access applications Assembling data access applications Deploy data access applications Install enterprise application files Administer data access applications
J2C Administered Objects collection J2C Activation Specifications collection
Related information:
WebSphere Application Server prerequisite website