Why and when to perform this task
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.