Overriding the Adapter's List of Fatal Error Codes
You can override the existing list of fatal error codes of Adapter for JDBC with a new list of error codes.
To override the existing fatal error list with a new fatal error list
1. Start Integration Server Administrator if it is not already running.
2. Under Settings in the left panel, select Extended.
3. Select Edit Extended Settings. In the edit box, type:
watt.adapter.JDBC.database driver.fatalErrors=ErrorCode_1, ErrorCode_2,ErrorCode_n
For example, to override the list of fatal error codes for Adapter for JDBC with a list of error codes 17002, 17003, and 16702 for Oracle driver, type the following:
watt.adapter.JDBC.Oracle.fatalErrors=17002,17003,16702
Note that there is no space after the , (comma). For a list of other supported driver settings, see
Customizing the Adapter's List of Fatal Error Codes.
Note:
If the error code of a database starts with a zero, then remove the zero from the error code and append the remaining code to the list. For example, for Oracle database, if you want to override the error code, 01401, then type the watt parameter as follows: watt.adapter.JDBC.Oracle.fatalErrors=1401
By default, Adapter for JDBC's fatal error codes are 17001, 17002, 17416, 1092, 28, 1012, 17410, 12571, 3114, 1089, 1033, 08S01, 40003, -30081, -99999, HY000, -601, JZ0C0, -79716. This list is a combination of common fatal error codes from different databases.
4. Click Save Changes.
5. Restart Integration Server.