JDBC data source import fails if the initial request is timed out blocking the thread


Description

JDBC data source import fails if the initial request is timed out which is blocking the thread, so the subsequent request is timing out after 5 min without any error message or information in MID logs.

Steps to Reproduce

1) Create the Data source with type JDBC and connect to SQL DB.
2) Query a large amount of data from that SQL DB which should take more than 5 min.

The subsequent requests will fail with the above warning on the MID server thread dump.

Workaround

1. Stop the mid server

2. Delete all ECC queue records that are in processing state (which should be in error state)

3. Restart the mid server


Related Problem: PRB1421414