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

    Version 3.2.20.09: Expanding Tables still hangs.

    1036553

      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.

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

          What version of the JDK are you using?

          • 3. Re: Version 3.2.20.09: Expanding Tables still hangs.
            1036553

            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...