Page History

When a connection monitor is enabled, each new Query Window opened for the server will start an application thread to monitor the status of the connection associated with the Query Window. The connection monitor can perform these operations based on an idle counter for each operation.  

• Ping Operation
• Execute Query Operation
• Auto-Commit Operation

...

The connection monitor for each Query Window starts only when at least one setting has been enabled in the Connection Monitor tab. A list of all running connections can be viewed from the Connections Monitor dialog. You can launch this dialog from Aqua Data Studio Tools menu.

Ping Operation

Users working in large Enterprises frequently run into network firewalls that disconnect idle network connections, or they do not have permission to request a change in behavior for the network firewall. In such scenarios, the firewall might terminate their connection frequently. Setting a Ping operation with a connection monitor will allow activity on the connection to prevent the connection from being terminated. The Ping operation is performed by calling the JDBC drivers Connection.isValid() API which "shall submit a query on the connection or use some other mechanism that positively verifies the connection is still valid when this method is called."

...

The following table lists the actions that reset the threshold period for the monitored connections.

Action from the Toolbar	Ping	Execute	Auto-Commit
Image Modified	✔	✔	✘
Image Modified	✔	✔	✘
Image Modified	✔	✘	✘
Image Modified	✔	✘	✘
Image Modified	✔	✘	✘
Image Modified	✘	✘	✔
Image Modified	✘	✘	✔
Image Modified	✘	✘	✔
Image Modified	✘	✔	✔
Image Modified	✘	✔	✔
Image Modified	✔	✔	✔
Change Database	✔	✔	✔
Change Schema (Only applies to databases with changeable schema)	✔	✔	✘