Establishing high availability for Data access resources
This page provides a starting point for finding information about data access. 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.
The flexible IBM WebSphere Application Server provides several options for accessing an information system's 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 J2EE 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.
- Use the IBM data access beans, which also use the JDBC API, but give you a rich set of features and function that hide much of the complexity associated with accessing relational databases.
Service Data Objects (SDO) simplify the programmer experience with a universal abstraction for messages and data, whether the programmer thinks of data in terms of XML documents or Java objects. For programmers, SDOs eliminate the complexity of the underlying data access technology (JDBC, RMI/IIOP, JAX-RPC, JMS, and so on) and message transport technology (java.io.Serializable, DOM Ojbects, SOAP, JMS, and so on).
Subtopics
- Change the error detection model to use the Exception Checking Model
The error detection model has been expanded and the data source has a configuration option that we can use to select the exception mapping model or the exception checking model for error detection. This configuration option allows the Error Detection Model to comply with JDBC 4.0.
- Configure resource adapters
We can view a list of installed and configured resource adapters in the console. Also, we can use the console to install new resource adapters, create additional configurations of installed resource adapters, or delete resource adapter configurations.
- Configure Oracle Real Application Cluster (RAC) with the application server
Oracle Real Application Cluster (RAC) is a "share-everything" database architecture in which two or more Oracle RAC nodes are clustered together and share the same storage. The RAC nodes are connected together with a high-speed interconnect that enables fast communication between the Oracle nodes. The nodes can exchange various categories of data block ownership information during startup, lock information, exchange transaction information and data, and so on.
- Configure client reroute for applications that use DB2 databases
The client reroute feature enables you to configure your client applications for a DB2 universal database to recover from a communication loss, and the applications can continue to work with minimal interruption. Rerouting is central to the support of continuous operations, but rerouting is only possible when there is an alternate location that is identified to the client connection.
- Configure connection validation timeout
We can configure a timeout for connection validation by the JDBC driver through a data source custom property in the data source configuration panels.
Related information:
End-to-end paths for Data access resources
Administer Data access resources
Scripting for data access resources
Troubleshooting Data access resources