3 Replies Latest reply on Oct 17, 2013 6:58 AM by Gary Graham-Oracle

    SQL Dev 3.2.2 is dropping connections

    Brendan

      Hi

       

      I have SQL Dev 3.2.2 (32-bit) with the supplied JDK running on window.  It seems to be dropping connections to the database.  The database is not reporting any errors

       

      I get windows popping up that say

      'Your Database Connection has been reset. Any pending transactions or session state has been lost.

       

      We are also getting the following messages in a cmd window

       

      09:29_48 Count not canonicalize 'D:\Program Files\use-3.0.:' (The file

      name, directory, name or volume label syntax is incorrect>, From the system property

      jave.library.path.

      Closed Connection

      parseIdentifierAtIffset: parent == null output=[0,41]   pseudo rootm_id=[30,31)

       

      Exception in thread "InsightThread" java.lang.ArrayIndexOutOfBoundsException: 15

         

           at oracle.dbtools.parser.Earley.complete(Earley.java:389)

           at oracle.dbtools.parser.Earley.parse(Earley.java:88)

           at oracle.dbtools.raptor.insight.CompletionInsight.complete(CompletionIn

      signt.java:580

           at oracle.dbtools.raptor.insight.CompletionInsight$InsightThread.run(Com

      pletionInsight.java:510)

      Exception in thread "InsightThread" java.lang/NullPointerException

           at oracle.dbtools.parser.plsql.SqlEarley.lookaheadOK(SqlEarley.java:274)

       

           at oracle.dbtools.parser.Earley.complete(Earley.java:461)

           at oracle.dbtools.parser.Earley.parse(Earley.java:88)

           at oracle.dbtools.raptor.insight.CompletionInsight.complete(CompletionIn

      sight.java:586)

           at oracle.dbtools.raptor.insight.CompletionInsight$InsightThread.run(Com

      pletionInsight.java.510)

      Exception in thread "InsightThread" java.lang.NullPointerException

       

      Any ideas what might be causing this?

       

      There is a much earlier post for ver 3.0 of SQL Dev that points to the possibility that the following command should be added to the conf file

       

      AddVMOption -Doracle.net.disableOob=true


      Is this needed in 3.2.2?


      Thanks

      Brendan

        • 1. Re: SQL Dev 3.2.2 is dropping connections
          Gary Graham-Oracle

          Hi Brendan,

           

          Any ideas what might be causing this?

          There is a much earlier post for ver 3.0 of SQL Dev that points to the possibility that the following command should be added to the conf file

          AddVMOption -Doracle.net.disableOob=true


          Is this needed in 3.2.2?

          It certainly couldn't hurt to try, especially if your client OS is Windows, your database is configured as shared_server rather than dedicated, and so on as you can read about in older threads on this forum.


          It also probably depends on the version of your JDBC driver.  Prior to SQL Developer 4.0, the product will use the JDBC driver in your Oracle home, if any.  Otherwise it uses the JDBC driver it ships with (11.2.0.3, I believe),  or perhaps the one you may have replaced it with in your installation's sqldeveloper\jdbc\lib directory.  The 4.0 EA's ship with the same version and are hard-wired to use only that directory location.


          Supposedly 4.0 production will contain a JDBC driver selector UI.

           

          Hope this helps,

          Gary

          SQL Developer Team

          • 2. Re: SQL Dev 3.2.2 is dropping connections
            Brendan

            Thanks Gary

             

            Is there a way to force/point ver 3.2.2 to use the jdbc driver that it comes with?   Maybe 3.2.2 is picking up another jdbc driver on the client PC.

             

            There was no changes made to the SQL Dev setup. It was downloaded from OTN, unzipped and then used. So we didn't change the jdbc driver.

            • 3. Re: SQL Dev 3.2.2 is dropping connections
              Gary Graham-Oracle

              Is there a way to force/point ver 3.2.2 to use the jdbc driver that it comes with?

              Read K's response in the following thread: How do I change the ORACLE_HOME that SQL Developer uses?