Forum Discussion

Schevus's avatar
Schevus
New Contributor III
7 years ago

SQL Server Account Checkout Timeout

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.

2 Replies

  • Schevus's avatar
    Schevus
    New Contributor III
    7 years ago

    Bumping this. Surely someone from SnapLogic knows?

    • robin's avatar
      robin
      Former Employee
      7 years ago

      @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.