I have following details - DB server - Windows Server 2016 Datacenter SQL Server version - Microsoft SQL Server 2016 (SP1) (KB3182545) - 13.0.4001.0 (X64)
@OlafHelper-2800 Thanks for replying . Yes application developed by my company. Can you tell if i can override this default timeout ?
Also, db server & client in cloud as ec2 instances, in logs i can see it starts inserting rows expected but throws error after some time.
Also it use connection pool.
This is really a JDBC question, not a SQL Server question. SQL Server does not have a timeout.
The default timeout is -1 (infinite) in the JDBC driver. So you must already be setting it to something.
Please see "queryTimeout":
Your question is related to Java and I am not familiar with it. But here have some check-list may help you:
1. Please make sure that you can ping the server that has SQL Server installed.
2. Make sure that the SQL Server instance is running well.
3. Make sure that the codes used to establish connection are correct.
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
12 people are following this question.