Add Instructions for Configuring JDBC Driver-Level Timeouts to Prevent Issues Due to Network Failures

[sajith-madhusanka]

Current Limitation

As per the current instruction provided in the CDC inbound endpoint references [1], it doesn't include instructions to configure JDBC driver-level timeouts. These timeouts are essential to avoid issues that could occur due to network failures.

[1] https://mi.docs.wso2.com/en/latest/reference/connectors/cdc-inbound-endpoint/cdc-inbound-endpoint-config/

Suggested Improvement

It would be better if we could add instructions to configure the JDBC driver timeout. These can be defined with the "driver" prefix as shown below in the inbound endpoint configuration:

<parameter name="driver.socketTimeout">45000</parameter>

The above example applies to the MS SQL database driver, while other RDBMS vendors may use different parameters [1][2][3] to define timeouts.

[1] https://learn.microsoft.com/en-us/sql/connect/jdbc/understand-timeouts?view=sql-server-ver16
[2] https://dev.mysql.com/doc/connector-j/en/connector-j-reference-configuration-properties.html?utm_source=chatgpt.com#:~:text=Table%C2%A06.4%C2%A0Networking%20Properties
[3] https://docs.oracle.com/cd/E93514_01/epmstatic/essbase_studio/docs/en/essbase_studio/user/frameset.htm?apbs02s23.html

Version

4.2.0