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.

By default, the exception mapping Error Detection Model configuration is selected. The exception mapping Error Detection Model replaces some exceptions raised by the JDBC driver. Exception checking does not do this. To use this configuration, no changes are needed. To use the exception checking model, we need to configure the error detection model in the application server. If we previously changed the Error Detection Model, we can also use these steps to change the configuration back to using to the exception mapping model.

1. Open the console.

2. Go to the WAS Data Source properties panel for the data source.

   1. Select Resources > JDBC > Data Sources > data_source

   2. Select WebSphere Application Server Data Source properties.

3. In the Error Detection Model section, click Use the WAS Exception Checking Model.

Related tasks

Configure resource adapters