Customizing the Adapter's List of Fatal Error Codes
You can add a specific error code to the list of fatal error codes. This allows Adapter for JDBC to automatically refresh its connections when a specific error occurs. Be sure that there is no other use for this error code before you add it to the list.
To customize the 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 either of the following watt parameters:
watt.adapter.JDBC.database driver.fatalErrors=+ErrorCode_1, ErrorCode_2,ErrorCode_nThis watt property is database driver specific. Note that there is no space after the , (comma).
Example: To allow Adapter for JDBC to refresh connections when encountering Oracle error codes 17002 and 17003 using an Oracle JDBC driver, type:
watt.adapter.JDBC.Oracle.fatalErrors=+17002,17003
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 add the error code, 01401, then type the watt parameter as follows: watt.adapter.JDBC.Oracle.fatalErrors=+1401
The following is a list of other supported driver settings (for watt.adapter.JDBC.database driver.fatalErrors):
Driver | Setting |
Microsoft SQL Server | watt.adapter.JDBC.MsMssql.fatalErrors |
Oracle JDBC | watt.adapter.JDBC.Oracle.fatalErrors |
JTOpen | watt.adapter.JDBC.DB2JTOPEN.fatalErrors |
DataDirect Connect for JDBC driver for DB2 | watt.adapter.JDBC.CJDBCDB2.fatalErrors |
Teradata Type 4 | watt.adapter.JDBC.TeraData.fatalErrors |
JDBC 2.21 type 4 for Informix | watt.adapter.JDBC.INFORMIX.fatalErrors |
jCONNECT 5.5 and 6.05 type 4 for Sybase | watt.adapter.JDBC.SYBASE.fatalErrors |
DB2 Universal type 2 and type 4 | watt.adapter.JDBC.DB2UNIVERSAL.fatalErrors |
Other driver types | watt.adapter.JDBC.Generic.fatalErrors |
watt.adapter.JDBC.database.fatalErrors=+ErrorCode_1,ErrorCode_2, ErrorCode_n This watt property is not database driver specific, instead applies to all drivers. Note that there is no space after the , (comma).
Example: To allow Adapter for JDBC to refresh connections when encountering error codes 12535, type:
watt.adapter.JDBC.database.fatalErrors=+12535
It is recommended that you use this watt property to add error codes to the adapter's list of error codes, instead of watt.adapter.JDBC.database driver.fatalErrors.
4. Click Save Changes.
5. Restart Integration Server.