SQL Server Account Checkout Timeout

[Schevus]

The documentation for the Checkout Timeout property of the SQL Server Account configuration mentions: “An exception will be thrown after the wait time has expired.”

Does anyone know what exception will be thrown? Dealing with seemingly random “com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset” exceptions, and wondering if we can narrow it down to an interaction with this configuration.

[Schevus]

Bumping this. Surely someone from SnapLogic knows?

[robin]

@Schevus underneath you would see a java.sql.SQLException and an error message mentioning a timeout being “encountered waiting for connection”. “Connection reset” is more likely to be configuration- or network-condition related.