Facing com.microsoft.sqlserver.jdbc.SQLServerException: Read timed out

Question

Facing com.microsoft.sqlserver.jdbc.SQLServerException: Read timed out

Sagar Mali 1

I have following details - DB server - Windows Server 2016 Datacenter SQL Server version - Microsoft SQL Server 2016 (SP1) (KB3182545) - 13.0.4001.0 (X64)

Olaf Helper 27,296 Reputation points

2021-03-18T15:14:25.483+00:00

A read time out is a command time which is raised by the client component, when the execution of a query takes longer then defined time out period; default is 30 seconds.
But with the less information no one can say more.
Is the application developed by your company? Then consult the developer to get more assistance.
Erland Sommarskog 72,581 Reputation points MVP

2021-03-18T22:49:17.707+00:00

Permit me to point out that you are indeed to upgrade that server. You should be on SQL 2016 SP2 CU16, which is the most recent Cumulative Update. SP1 is seriously out of date.
CarrinWu-MSFT 6,806 Reputation points

2021-03-22T01:22:29.487+00:00

Hi, we have not get a reply from you. Did any answers could help you? If there has an answer helped, do "Accept Answer". If it is not work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Olaf Helper 27,296 Reputation points

2021-03-18T15:14:25.483+00:00

A read time out is a command time which is raised by the client component, when the execution of a query takes longer then defined time out period; default is 30 seconds.
But with the less information no one can say more.
Is the application developed by your company? Then consult the developer to get more assistance.
Erland Sommarskog 72,581 Reputation points MVP

2021-03-18T22:49:17.707+00:00

Permit me to point out that you are indeed to upgrade that server. You should be on SQL 2016 SP2 CU16, which is the most recent Cumulative Update. SP1 is seriously out of date.
CarrinWu-MSFT 6,806 Reputation points

2021-03-22T01:22:29.487+00:00

Hi, we have not get a reply from you. Did any answers could help you? If there has an answer helped, do "Accept Answer". If it is not work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Answer 1

Hi @Sagar Mali ,

Your question is related to Java and I am not familiar with it. But here have some check-list may help you:

Please make sure that you can ping the server that has SQL Server installed.
Make sure that the SQL Server instance is running well.
Make sure that the codes used to establish connection are correct.

And please refer to Connecting to SQL Server with the JDBC driver and Troubleshooting connectivity to get more information.

Best regards,
Carrin

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.

Answer 2

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":

https://learn.microsoft.com/en-us/sql/connect/jdbc/setting-the-connection-properties?view=sql-server-ver15

Answer 3

Sagar Mali 1

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

Facing com.microsoft.sqlserver.jdbc.SQLServerException: Read timed out

3 answers

Activity