Aqua Data Studio gets disconnected after a certain period of time.

by Nov 4, 2011

Aqua Data Studio gets disconnected after a certain period of time.

Response

Tariq Rahiman over 11 years ago
Timeouts: ADS periodically gets disconnected from the server
Aqua Data Studio does not timeout user connections. However, many DBAs configure the database servers to timeout inactive database connections, and sometimes firewalls are set to timeout socket connections. Check with your DBA, as he will probably be able to assist you. If you are working as a database administrator yourself, note that some databases have default settings for timeout connections. For example, by default MySQL will timeout idle connections, but this behavior can be modified by changing the database Settings.

Niels Gron over 11 years ago
When firewalls are configured to timeout connections, to problem is bigger then having a database server configured to timeout an idle connection. The problem with this is that when the firewall “cuts” the connection, all it does is prevent the communication to continue, but it does not notify the client or the server that the connection has been “cut” or closed. In the design of a packet network, the packets sent on the network are guaranteed to be delivered. So, the functionality of the firewall essentially breaks the original design of the socket protocol, and this is why the connection in ADS hangs. The way around this is to set a timeout on the socket connection. One problem with this is that ADS does not have control of the Socket connection. It only has a handle to the database connection provided by the database driver which is provided by the database vendor. So, the timeout can only be set if the driver provides a mechanism to do this. A second problem is that this will affect long running queries. So, if you have a timeout of 30 seconds, this means that if you execute a query that will take longer then 30 seconds, the connection will timeout. The best thing to do is to have your network team remove the network timeout for idle connections in your firewall.