Keep-alive db connection via heartbeat

[mrkeuz]

Hello,

First of all, I would to thanks for all DBeaver developers and contributors. It's really excellent product!
I have some proposal.

Problem

At now DBeaver losing connection after idle time. So you need reconnect every time. I found this thread about keep-alive problem. And It said:

Unfortunately this behavior depends on JDBC driver and can't be configured in some generic way.

Proposal

Make connection keep alive via heartbeat queries. A lot of db connection pool's took connection active via empty query like select 1, select * from dual etc. In some tool you can change this query. I.e. for generic driver.

As an option this can be done via input form in connection window with keep-alive query and heartbeat interval.

Thanks!

[infectormp]

DBeaver already have keep-alive settings #6

[mrkeuz]

@infectormp Thanks! I found. RTFM me :).
So you can close issue.

[wangeugene]

Where is the settings in Dbeaver 7.1 Database -> settings ?

[jkondratowicz]

@sail456852 Connection settings -> Initialization