i migrated to Linux from Windows and now i am experiencing issues that SQL Developer hangs when a DB session is not used for a while.
The connection to the DB is issued over an VPN connection, and of course it happens that the connection gets lost after a while.
On Windows this was not a big deal, as SQL Developer recognized that the connection was lost, and i could reconnect relatively soon and continue with the work.
But on Linux i need to kill SQL Developer and start over again, SQL Developer seems not to be able to detect a lost connection and recover gracefully from this scenario.
EDIT: not even a logout is possible and hangs...
SQL Developer: 184.108.40.206 Build MAIN-20.64
Java: 1.8.0_66 amd64
Linux lm 3.16.0-4-amd64 #1 SMP Debian 3.16.7-ckt7-1 (2015-03-01) x86_64 GNU/Linux
Is there any possibility to configure some kind of "keepalive" over the JDBC driver? I use keepalives on the ssh sessions, and the ssh session basically never vanishes and is available for many days.
Interesting -- the VPN complaints I've seen to-date have involved Windows. Still looking into improvements for this area.
There is no built-in "keepalive" feature, but doing a web search on "keepalive for sql developer 4" yields https://github.com/scristalli/SQL-Developer-4-keepalive as a third party extension you might try.