Hello,
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...
Environment:
SQL Developer: 4.1.2.20 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.