Changing 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 you 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 Java™ Database Connectivity (JDBC) 4.0.

About this task

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. If you want to use this configuration, no changes are needed. If you want to use the exception checking model, you need to configure the error detection model in the application server. If you previously changed the Error Detection Model, you can also use these steps to change the configuration back to using to the exception mapping model.

1. Open the administrative console.
2. Go to the WebSphere Application Server 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 WebSphere Application Server Exception Checking Model.