2 Replies Latest reply: May 2, 2012 5:35 AM by 934495 RSS

    3.1 Prod : Reconnect does not work on tree item navigator

    Buntoro
      Hi,

      I am using SQL Dev 3.1 Prod.
      I noticed about the Reconnect option given the connection tree context menu.
      The reconnect does work for the worksheet, however it does not do any good to the tree list.

      Step to reproduce :
      1. Open a connection
      2. Let it idle say 1 hour (or until the DB disconnect it), in my case company firewall closes the connection after one hour idle.
      3. Right click on the connection tree - Reconnect
      4. The query on worksheet does work
      5. However, opening tree items (tables, views, packages, or anything) simple return nothing.

      Is this intended behavior?
      I'd say this should be marked as bug.

      Regards,

      Buntoro
        • 1. Re: 3.1 Prod : Reconnect does not work on tree item navigator
          B.Delmée
          Same here. IMO, the current "reconnect" option is more confusing than helpful. Hopefully future releases will offer something better.
          Meanwhile you can use the "Keep Alive" extension. It is not perfect (eg I find it annoying to have to activate it every time I open a connection that needs it, it will not "stick"). Something similar, optional and integrated with the connection definition would be ideal.
          I suspect part of the problem is the difficulty for devs of testing this if they do not encounter the problem themselves. Please somebody at Oracle, put a nasty firewall between then and their test db, so they feel the urge to scratch that itch!-)
          • 2. Re: 3.1 Prod : Reconnect does not work on tree item navigator
            934495
            I have noticed the same problem, very annoying if you work using VPNs.

            My about

            Informazioni su
            ---------------

            Oracle SQL Developer 3.1.07
            versione 3.1.07
            Build MAIN-07.42
            Copyright © 2005-2011, Oracle e/o relative consociate. Tutti i diritti riservati.
            IDE Version: 11.1.1.4.37.59.48
            Product ID: oracle.sqldeveloper
            Product Version: 11.2.0.07.42

            Versione
            --------

            Componente     Versione
            ==========     ========
            Oracle IDE     3.1.07.42
            Piattaforma Java(TM)     1.6.0_24
            Versioning Support     3.1.07.42