1 Reply Latest reply on Nov 19, 2015 7:27 PM by Gary Graham-Oracle

    SQL developer hangs when connection to DB over VPN drops

    3124046

      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.