在使用dbvisualizer的时候,如果一段时间不使用连接的数据库将自动断开连接,每次都要重新连接,非常浪费时间。其实,dbvisualizer已经提供了相应的配置。
一次点击Tools->Tools Properties->Database Connection->SSH Setting->SSH Keep-Alive Interval,将SSH Keep-Alive Interval后面的数值设置较低即可,即设置的数值低于自动断开连接的超时时间。 下图为配置详情:
以下引自DbVisualizer文档:
SSH Keep-Alive Interval With some SSH configurations, the tunnel is dropped after a certain period of inactivity. DbVisualizer sends keep-alive messages through the tunnel to prevent this. Here you can set how often these messages should be sent, or set the interval to 0 to disable this feature.