Search Crosser Knowledge Base

Increase Command Timeout for Database modules

When running queries or commands towards a database, there is a default timeout that defines how long the client waits to receive a response until the request times out. As default, this timeout is usually set to 30 seconds.

While this is sufficient for the vast majority of use cases, you might find yourself in a situation where the execution takes longer due to various reasons.

In such cases you can increase the command timeout as part of the connection string.

Example below for MsSQL connection string where we set the timeout to 60 seconds:

Server=tcp:192.168.0.5;Database=crosser;User
ID=demo;Password=crosser123;Encrypt=false;Command Timeout=60

Note: This is just an example, depending on your database, you might find other useful settings that you can add as part of your connection string.

About the author

David Nienhaus | Senior Solution Engineer

David is a Senior Solution Engineer at Crosser. He has over 15 years experience working with software integration and digitization projects for critical infrastructure.
His engineering background gives him the understanding and focus needed to solve customer use cases in the most efficient and successful way.