Develop data access applications

Subtopics

• Develop data access applications
  Use data access applications to manipulate data from outside sources for use within the application serving environment.

• Example: Setting client information with the setClientInformation(Properties) API
  We can set WebSphere Application Server client information on connections to pass that information to your database with this API.

• 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.

• Exceptions pertaining to data access
  All enterprise bean container-managed persistence (CMP) beans under the EJB 2.x specification receive a standard EJB exception when an operation fails. JDBC applications receive a standard SQL exception if any JDBC operation fails. The product provides special exceptions for its relational resource adapter (RRA), to indicate that the connection currently held is no longer valid.