Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sathiq.forum
Starting Member
2 Posts |
 Posted - 2010-07-21 : 19:29:34
|
| We have Java Client application which creates one database connection to MS SQL server 2005. If the client is idle overnight (Without doing any database operation, meaning that SQL connection is idle overnight), then somehow connection is closed by SQL server 2005 (I guess, SQL server 2005 closes if connection is idle for long time). If my guess is right, 1. How do i stop SQL server closing connection? Or 2. How do i extend the time interval for SQL server closing connection?If my guess is wrong,1. Who (Firewall or network) closes the idle SQL connection?I am confused, please help me |
|
|
sathiq.forum
Starting Member
2 Posts |
Posted - 2010-07-24 : 10:37:19
|
| To Add one point on the above question, When i tried running overnight on the next day, Idle connection did not get closed. This behavior adds more confusion to debug why it is happening? Does anyone have any idea why? |
 |
|
|
|
|
|
Connection closed when connection is idle for long