4 Replies Latest reply: Aug 29, 2013 8:27 AM by Jeff Smith Sqldev Pm-Oracle RSS

    Version 3.2.20.09: Expanding Tables still hangs.

    d0cf4579-df80-4eba-8c9c-fd58a83c4598

      This is similar to: https://forums.oracle.com/thread/2204388

       

      I just downloaded a new version of SQL Developer for my new computer.

      I was able to set up my connections, but when I go to expand the tables tree node, SQL Developer just hangs.

       

      I've tried adding the line: AddVMOption -Doracle.net.disableOob=true

      to the .conf file as specified in the post.  However, this does not help.

       

      Just a note, I am on Windows 7 and over VPN...both contributing factors to the problem according to the post.

       

      If anyone has any ideas, it would be appreciated.

        • 3. Re: Version 3.2.20.09: Expanding Tables still hangs.
          d0cf4579-df80-4eba-8c9c-fd58a83c4598

          Here is a full dump of the About section in SQL Developer.

          I have redacted my username, as it is not important to the conversation.  I have replaced it with **REDACTED**:

           

          About

          -----

           

           

          Oracle SQL Developer 3.2.20.09

          Version 3.2.20.09

          Build MAIN-09.87

          Copyright ©  2005, 2012 Oracle.  All Rights Reserved.

          IDE Version: 11.1.1.4.37.59.48

          Product ID: oracle.sqldeveloper

          Product Version: 11.2.0.09.87

           

           

          Version

          -------

           

           

          Component Version

          ========= =======

          Java(TM) Platform 1.7.0_25

          Oracle IDE 3.2.20.09.87

          Versioning Support 3.2.20.09.87

           

           

          Properties

          ----------

           

           

          Name Value

          ==== =====

          awt.toolkit sun.awt.windows.WToolkit

          class.load.environment oracle.ide.boot.IdeClassLoadEnvironment

          class.load.log.level CONFIG

          class.transfer delegate

          file.encoding Cp1252

          file.encoding.pkg sun.io

          file.separator \

          ice.browser.forcegc false

          ice.pilots.html4.ignoreNonGenericFonts true

          ice.pilots.html4.tileOptThreshold 0

          ide.AssertTracingDisabled true

          ide.bootstrap.start 1850305877367

          ide.build MAIN-09.87

          ide.conf C:\Program Files\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf

          ide.config_pathname C:\Program Files\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf

          ide.debugbuild false

          ide.devbuild false

          ide.extension.search.path sqldeveloper/extensions:jdev/extensions:ide/extensions

          ide.firstrun true

          ide.java.minversion 1.6.0_04

          ide.launcherProcessId 7468

          ide.main.class oracle.ide.boot.IdeLauncher

          ide.patches.dir ide/lib/patches

          ide.pref.dir C:\Users\**REDACTED**\AppData\Roaming\SQL Developer

          ide.pref.dir.base C:\Users\**REDACTED**\AppData\Roaming

          ide.product oracle.sqldeveloper

          ide.shell.enableFileTypeAssociation C:\Program Files\sqldeveloper\sqldeveloper.exe

          ide.splash.screen splash.gif

          ide.startingArg0 "C:\Program Files\sqldeveloper\sqldeveloper64.exe"

          ide.startingcwd C:\Program Files\sqldeveloper

          ide.user.dir C:\Users\**REDACTED**\AppData\Roaming\SQL Developer

          ide.user.dir.var IDE_USER_DIR

          ide.vcs.noapplications true

          ide.work.dir C:\Users\**REDACTED**\Documents\SQL Developer

          ide.work.dir.base C:\Users\**REDACTED**\Documents

          ilog.propagatesPropertyEditors false

          java.awt.graphicsenv sun.awt.Win32GraphicsEnvironment

          java.awt.printerjob sun.awt.windows.WPrinterJob

          java.class.path ..\..\ide\lib\ide-boot.jar

          java.class.version 51.0

          java.endorsed.dirs C:\Program Files\Java\jdk1.7.0_25\jre\lib\endorsed

          java.ext.dirs C:\Program Files\Java\jdk1.7.0_25\jre\lib\ext;C:\windows\Sun\Java\lib\ext

          java.home C:\Program Files\Java\jdk1.7.0_25\jre

          java.io.tmpdir C:\Users\**REDACTED**\AppData\Local\Temp\

          java.library.path C:\Program Files\sqldeveloper;C:\windows\Sun\Java\bin;C:\windows\system32;C:\windows;C:\windows\system32;C:\windows;C:\windows\System32\Wbem;C:\windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Java\jdk1.7.0_25;.

          java.naming.factory.initial oracle.javatools.jndi.LocalInitialContextFactory

          java.protocol.handler.pkgs oracle.jdevimpl.handler

          java.runtime.name Java(TM) SE Runtime Environment

          java.runtime.version 1.7.0_25-b17

          java.specification.name Java Platform API Specification

          java.specification.vendor Oracle Corporation

          java.specification.version 1.7

          java.util.logging.config.file logging.conf

          java.vendor Oracle Corporation

          java.vendor.url http://java.oracle.com/

          java.vendor.url.bug http://bugreport.sun.com/bugreport/

          java.version 1.7.0_25

          java.vm.info mixed mode

          java.vm.name Java HotSpot(TM) 64-Bit Server VM

          java.vm.specification.name Java Virtual Machine Specification

          java.vm.specification.vendor Oracle Corporation

          java.vm.specification.version 1.7

          java.vm.vendor Oracle Corporation

          java.vm.version 23.25-b01

          jdbc.library /C:/Program Files/sqldeveloper/jdbc/lib/ojdbc6.jar

          line.separator \r\n

          log.file.name C:\Program Files\sqldeveloper\sqldeveloper\extensions\oracle.datamodeler\log\datamodeler.log

          oracle.home C:\Program Files\sqldeveloper

          oracle.ide.util.AddinPolicyUtils.OVERRIDE_FLAG true

          oracle.jdbc.mapDateToTimestamp false

          oracle.net.disableOob true

          oracle.translated.locales de,es,fr,it,ja,ko,pt_BR,zh_CN,zh_TW

          oracle.xdkjava.compatibility.version 9.0.4

          orai18n.library /C:/Program Files/sqldeveloper/jlib/orai18n.jar

          os.arch amd64

          os.name Windows 7

          os.version 6.1

          path.separator ;

          reserved_filenames con,aux,prn,lpt1,lpt2,lpt3,lpt4,lpt5,lpt6,lpt7,lpt8,lpt9,com1,com2,com3,com4,com5,com6,com7,com8,com9,conin$,conout,conout$

          sqldev.debug false

          sun.arch.data.model 64

          sun.awt.enableExtraMouseButtons true

          sun.boot.class.path C:\Program Files\Java\jdk1.7.0_25\jre\lib\resources.jar;C:\Program Files\Java\jdk1.7.0_25\jre\lib\rt.jar;C:\Program Files\Java\jdk1.7.0_25\jre\lib\sunrsasign.jar;C:\Program Files\Java\jdk1.7.0_25\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.7.0_25\jre\lib\jce.jar;C:\Program Files\Java\jdk1.7.0_25\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.7.0_25\jre\lib\jfr.jar;C:\Program Files\Java\jdk1.7.0_25\jre\classes

          sun.boot.library.path C:\Program Files\Java\jdk1.7.0_25\jre\bin

          sun.cpu.endian little

          sun.cpu.isalist amd64

          sun.desktop windows

          sun.io.unicode.encoding UnicodeLittle

          sun.java2d.ddoffscreen false

          sun.jnu.encoding Cp1252

          sun.management.compiler HotSpot 64-Bit Tiered Compilers

          sun.os.patch.level Service Pack 1

          svnkit.sax.useDefault true

          user.country US

          user.dir C:\Program Files\sqldeveloper\sqldeveloper\bin

          user.home C:\Users\**REDACTED**

          user.language en

          user.name **REDACTED**

          user.script

          user.timezone America/New_York

          user.variant

          windows.shell.font.languages

           

           

          Extensions

          ----------

           

           

          Name Identifier Version Status

          ==== ========== ======= ======

          Check For Updates oracle.ide.webupdate 11.1.1.4.37.59.48 Loaded

          Code Editor oracle.ide.ceditor 11.1.1.4.37.59.48 Loaded

          Component Palette oracle.ide.palette1 11.1.1.4.37.59.48 Loaded

          Data Miner oracle.dmt.dataminer 11.2.1.1.09.87 Loaded

          Database Connection Support oracle.jdeveloper.db.connection 11.1.1.4.37.59.48 Loaded

          Database Object Explorers oracle.ide.db.explorer 11.1.1.4.37.59.48 Loaded

          Database UI oracle.ide.db 11.1.1.4.37.59.48 Loaded

          Diagram Framework oracle.diagram 11.1.1.4.37.59.48 Loaded

          Diagram Javadoc Extension oracle.diagram.javadoc 11.1.1.4.37.59.48 Loaded

          Diagram Thumbnail oracle.diagram.thumbnail 11.1.1.4.37.59.48 Loaded

          Diff/Merge oracle.ide.diffmerge 11.1.1.4.37.59.48 Loaded

          Extended IDE Platform oracle.javacore 11.1.1.4.37.59.48 Loaded

          External Tools oracle.ide.externaltools 11.1.1.4.37.59.48 Loaded

          File Support oracle.ide.files 11.1.1.4.37.59.48 Loaded

          Help System oracle.ide.help 11.1.1.4.37.59.48 Loaded

          History Support oracle.jdeveloper.history 11.1.1.4.37.59.48 Loaded

          Import/Export Support oracle.ide.importexport 11.1.1.4.37.59.48 Loaded

          Index Migrator support oracle.ideimpl.indexing-migrator 11.1.1.4.37.59.48 Loaded

          JDeveloper Runner oracle.jdeveloper.runner 11.1.1.4.37.59.48 Loaded

          JViews Registration Addin oracle.diagram.registration 11.1.1.4.37.59.48 Loaded

          Log Window oracle.ide.log 11.1.1.4.37.59.48 Loaded

          Mac OS X Adapter oracle.ideimpl.apple 11.1.1.4.37.59.48 Loaded

          Navigator oracle.ide.navigator 11.1.1.4.37.59.48 Loaded

          Object Gallery oracle.ide.gallery 11.1.1.4.37.59.48 Loaded

          Oracle IDE oracle.ide 11.1.1.4.37.59.48 Loaded

          Oracle SQL Developer oracle.sqldeveloper 11.2.0.09.87 Loaded

          Oracle SQL Developer - 3rd Party Database Browsers oracle.sqldeveloper.thirdparty.browsers 11.2.0.09.87 Loaded

          Oracle SQL Developer - APEX Listener Administration oracle.sqldeveloper.listener 11.2.0.09.87 Loaded

          Oracle SQL Developer - Change Mangement oracle.sqldeveloper.em_cm 11.2.0.09.87 Loaded

          Oracle SQL Developer - DBA Navigator oracle.sqldeveloper.dbanavigator 11.2.0.09.87 Loaded

          Oracle SQL Developer - Database Cart oracle.sqldeveloper.dbcart 11.2.0.09.87 Loaded

          Oracle SQL Developer - Extras oracle.sqldeveloper.extras 11.2.0.09.87 Loaded

          Oracle SQL Developer - File Navigator oracle.sqldeveloper.filenavigator 11.2.0.09.87 Loaded

          Oracle SQL Developer - Migrations Antlr3 Translator oracle.sqldeveloper.migration.translation.core_antlr3 11.2.0.09.87 Loaded

          Oracle SQL Developer - Migrations Application Migration oracle.sqldeveloper.migration.application 11.2.0.09.87 Loaded

          Oracle SQL Developer - Migrations Core oracle.sqldeveloper.migration 11.2.0.09.87 Loaded

          Oracle SQL Developer - Migrations DB2 oracle.sqldeveloper.migration.db2 11.2.0.09.87 Loaded

          Oracle SQL Developer - Migrations DB2 Translator oracle.sqldeveloper.migration.translation.db2 11.2.0.09.87 Loaded

          Oracle SQL Developer - Migrations Microsoft Access oracle.sqldeveloper.migration.msaccess 11.2.0.09.87 Loaded

          Oracle SQL Developer - Migrations Microsoft SQL Server oracle.sqldeveloper.migration.sqlserver 11.2.0.09.87 Loaded

          Oracle SQL Developer - Migrations MySQL oracle.sqldeveloper.migration.mysql 11.2.0.09.87 Loaded

          Oracle SQL Developer - Migrations Sybase Adaptive Server oracle.sqldeveloper.migration.sybase 11.2.0.09.87 Loaded

          Oracle SQL Developer - Migrations T-SQL Translator oracle.sqldeveloper.migration.translation.core 11.2.0.09.87 Loaded

          Oracle SQL Developer - Migrations Teradata oracle.sqldeveloper.migration.teradata 11.2.0.09.87 Loaded

          Oracle SQL Developer - Migrations Teradata SQL Translator oracle.sqldeveloper.migration.translation.teradata_translator 11.2.0.09.87 Loaded

          Oracle SQL Developer - Migrations Translation UI oracle.sqldeveloper.migration.translation.gui 11.2.0.09.87 Loaded

          Oracle SQL Developer - Object Viewer oracle.sqldeveloper.oviewer 11.2.0.09.87 Loaded

          Oracle SQL Developer - Real Time SQL Monitoring oracle.sqldeveloper.sqlmonitor 11.2.0.09.87 Loaded

          Oracle SQL Developer - Reports oracle.sqldeveloper.report 11.2.0.09.87 Loaded

          Oracle SQL Developer - Scheduler oracle.sqldeveloper.scheduler 11.2.0.09.87 Loaded

          Oracle SQL Developer - Schema Browser oracle.sqldeveloper.schemabrowser 11.2.0.09.87 Loaded

          Oracle SQL Developer - SearchBar oracle.sqldeveloper.searchbar 11.2.0.09.87 Loaded

          Oracle SQL Developer - Security oracle.sqldeveloper.security 11.2.0.09.87 Loaded

          Oracle SQL Developer - Snippet oracle.sqldeveloper.snippet 11.2.0.09.87 Loaded

          Oracle SQL Developer - Spatial oracle.sqldeveloper.spatial 11.2.0.09.87 Loaded

          Oracle SQL Developer - TimesTen oracle.sqldeveloper.timesten 11.2.0.09.87 Loaded

          Oracle SQL Developer - Tuning oracle.sqldeveloper.tuning 11.2.0.09.87 Loaded

          Oracle SQL Developer - Unit Test oracle.sqldeveloper.unit_test 11.2.0.09.87 Loaded

          Oracle SQL Developer - User Extensions Support oracle.sqldeveloper.userextensions 11.2.0.09.87 Loaded

          Oracle SQL Developer - Worksheet v2 oracle.sqldeveloper.worksheet 11.2.0.09.87 Loaded

          Oracle SQL Developer - XML Schema oracle.sqldeveloper.xmlschema 11.2.0.09.87 Loaded

          Oracle SQL Developer Data Modeler oracle.datamodeler 3.1.4.710 Loaded

          Oracle SQL Developer Data Modeler - Reports oracle.sqldeveloper.datamodeler_reports 11.2.0.09.87 Loaded

          PROBE Debugger oracle.jdeveloper.db.debug.probe 11.1.1.4.37.59.48 Loaded

          Peek oracle.ide.peek 11.1.1.4.37.59.48 Loaded

          Persistent Storage oracle.ide.persistence 11.1.1.4.37.59.48 Loaded

          Property Inspector oracle.ide.inspector 11.1.1.4.37.59.48 Loaded

          QuickDiff oracle.ide.quickdiff 11.1.1.4.37.59.48 Loaded

          Replace With oracle.ide.replace 11.1.1.4.37.59.48 Loaded

          Runner oracle.ide.runner 11.1.1.4.37.59.48 Loaded

          VHV oracle.ide.vhv 11.1.1.4.37.59.48 Loaded

          Versioning Support oracle.jdeveloper.vcs 11.1.1.4.37.59.48 Loaded

          Versioning Support for Subversion oracle.jdeveloper.subversion 11.1.1.4.37.59.48 Loaded

          Virtual File System oracle.ide.vfs 11.1.1.4.37.59.48 Loaded

          Web Browser and Proxy oracle.ide.webbrowser 11.1.1.4.37.59.48 Loaded

          XML Editing Framework IDE Extension oracle.ide.xmlef 11.1.1.4.37.59.48 Loaded

          audit oracle.ide.audit 11.1.1.4.37.59.48 Loaded

          classpath: protocol handler extension oracle.jdeveloper.classpath 11.1.1.0.0 Loaded

          jdukshare oracle.bm.jdukshare 11.1.1.4.37.59.48 Loaded

          mof-xmi oracle.mof.xmi 11.1.1.4.37.59.48 Loaded

          oracle.ide.dependency oracle.ide.dependency 11.1.1.4.37.59.48 Loaded

          oracle.ide.indexing oracle.ide.indexing 11.1.1.4.37.59.48 Loaded

          palette2 oracle.ide.palette2 11.1.1.4.37.59.48 Loaded

          status oracle.ide.status 11.1.1.4.37.59.48 Loaded

          • 4. Re: Version 3.2.20.09: Expanding Tables still hangs.
            Jeff Smith Sqldev Pm-Oracle

            So that's the latest JDK. You could try version 4.0 which is an EA, but I doubt that will solve your problem. You can also open an SR with MOS if you have database support available...