1 2 Previous Next 20 Replies Latest reply: May 11, 2012 9:26 AM by Matthew Morris RSS

    SQLD 3.1EA Closed Connection Bug

    793954
      Since upgrading to 3.1EA, each time a table i opened from the table list on the left hand side, when the "Columns" tab opens in the main window, it is blank and a error "An error was encountered performing the requested operation: Closed Connection Vendor code 17008"

      Other tabs other than "Columns" can be access OK, and queries run as normal.

      This appears to be suspiciously similar to a bug reported in 3.0EA.....
        • 1. Re: SQLD 3.1EA Closed Connection Bug
          Barry Mcgillin-Oracle
          Is this happening for all tables?
          Can you post your config?
          • 2. Re: SQLD 3.1EA Closed Connection Bug
            793954
            Appears to happen for all tables 95% of the time. Sometimes I am able to cajole it into loading the columns page by a random selection of clicking other tabs and reloading, but nothing predictable or repeatable.


            About
            -----

            Oracle SQL Developer 3.1.06
            Version 3.1.06
            Build MAIN-06.44
            Copyright © 2005, 2011 Oracle. All Rights Reserved.
            IDE Version: 11.1.1.4.37.59.44
            Product ID: oracle.sqldeveloper
            Product Version: 11.2.0.06.44

            Version
            -------

            Component     Version
            =========     =======
            Java(TM) Platform     1.6.0_25
            Oracle IDE     3.1.06.44
            Versioning Support     3.1.06.44

            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     575153415242
            ide.build     MAIN-06.44
            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     5084
            ide.main.class     oracle.ide.boot.IdeLauncher
            ide.patches.dir     ide/lib/patches
            ide.pref.dir     C:\Users\markha\AppData\Roaming\SQL Developer
            ide.pref.dir.base     C:\Users\markha\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\markha\AppData\Roaming\SQL Developer
            ide.user.dir.var     IDE_USER_DIR
            ide.vcs.noapplications     true
            ide.work.dir     C:\Users\markha\Documents\SQL Developer
            ide.work.dir.base     C:\Users\markha\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     50.0
            java.endorsed.dirs     C:\Program Files\Java\jdk1.6.0_25\jre\lib\endorsed
            java.ext.dirs     C:\Program Files\Java\jdk1.6.0_25\jre\lib\ext;C:\Windows\Sun\Java\lib\ext
            java.home     C:\Program Files\Java\jdk1.6.0_25\jre
            java.io.tmpdir     C:\Users\markha\AppData\Local\Temp\
            java.library.path     C:\Program Files\sqldeveloper;.;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;c:\oracle\product\10.2.0\client_1\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;D:\Downloaded Apps\Ant\apache-ant-1.8.1\bin;C:\Program Files\System Center Operations Manager 2007\;C:\Program Files (x86)\ATI Technologies\ATI.ACE\Core-Static;C:\Program Files (x86)\Quest Software\PuTTY\;C:\Program Files (x86)\CVSNT\;c:\Python26\ArcGIS10.0\;c:\oracle\product\10.2.0\client_1\bin;c:\oracle\product\10.2.0\client_1\network\admin;
            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.6.0_25-b06
            java.specification.name     Java Platform API Specification
            java.specification.vendor     Sun Microsystems Inc.
            java.specification.version     1.6
            java.util.logging.config.file     logging.conf
            java.vendor     Sun Microsystems Inc.
            java.vendor.url     http://java.sun.com/
            java.vendor.url.bug     http://java.sun.com/cgi-bin/bugreport.cgi
            java.version     1.6.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     Sun Microsystems Inc.
            java.vm.specification.version     1.0
            java.vm.vendor     Sun Microsystems Inc.
            java.vm.version     20.0-b11
            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.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.boot.class.path     C:\Program Files\Java\jdk1.6.0_25\jre\lib\resources.jar;C:\Program Files\Java\jdk1.6.0_25\jre\lib\rt.jar;C:\Program Files\Java\jdk1.6.0_25\jre\lib\sunrsasign.jar;C:\Program Files\Java\jdk1.6.0_25\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.6.0_25\jre\lib\jce.jar;C:\Program Files\Java\jdk1.6.0_25\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.6.0_25\jre\lib\modules\jdk.boot.jar;C:\Program Files\Java\jdk1.6.0_25\jre\classes
            sun.boot.library.path     C:\Program Files\Java\jdk1.6.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     
            svnkit.sax.useDefault     true
            user.country     GB
            user.dir     C:\Program Files\sqldeveloper\sqldeveloper\bin
            user.home     C:\Users\markha
            user.language     en
            user.name     markha
            user.timezone     Europe/London
            user.variant     
            windows.shell.font.languages     

            Extensions
            ----------

            Name     Identifier     Version     Status
            ====     ==========     =======     ======
            Check For Updates     oracle.ide.webupdate     11.1.1.4.37.59.44     Loaded
            Code Editor     oracle.ide.ceditor     11.1.1.4.37.59.44     Loaded
            Component Palette     oracle.ide.palette1     11.1.1.4.37.59.44     Loaded
            Data Miner     oracle.dmt.dataminer     11.2.1.1.06.44     Loaded
            Database Connection Support     oracle.jdeveloper.db.connection     11.1.1.4.37.59.44     Loaded
            Database Object Explorers     oracle.ide.db.explorer     11.1.1.4.37.59.44     Loaded
            Database UI     oracle.ide.db     11.1.1.4.37.59.44     Loaded
            Diagram Framework     oracle.diagram     11.1.1.4.37.59.44     Loaded
            Diagram Javadoc Extension     oracle.diagram.javadoc     11.1.1.4.37.59.44     Loaded
            Diagram Thumbnail     oracle.diagram.thumbnail     11.1.1.4.37.59.44     Loaded
            Diff/Merge     oracle.ide.diffmerge     11.1.1.4.37.59.44     Loaded
            Extended IDE Platform     oracle.javacore     11.1.1.4.37.59.44     Loaded
            External Tools     oracle.ide.externaltools     11.1.1.4.37.59.44     Loaded
            File Support     oracle.ide.files     11.1.1.4.37.59.44     Loaded
            Help System     oracle.ide.help     11.1.1.4.37.59.44     Loaded
            History Support     oracle.jdeveloper.history     11.1.1.4.37.59.44     Loaded
            Import/Export Support     oracle.ide.importexport     11.1.1.4.37.59.44     Loaded
            Index Migrator support     oracle.ideimpl.indexing-migrator     11.1.1.4.37.59.44     Loaded
            JDeveloper Runner     oracle.jdeveloper.runner     11.1.1.4.37.59.44     Loaded
            JViews Registration Addin     oracle.diagram.registration     11.1.1.4.37.59.44     Loaded
            Log Window     oracle.ide.log     11.1.1.4.37.59.44     Loaded
            Mac OS X Adapter     oracle.ideimpl.apple     11.1.1.4.37.59.44     Loaded
            Navigator     oracle.ide.navigator     11.1.1.4.37.59.44     Loaded
            Object Gallery     oracle.ide.gallery     11.1.1.4.37.59.44     Loaded
            Oracle IDE     oracle.ide     11.1.1.4.37.59.44     Loaded
            Oracle SQL Developer     oracle.sqldeveloper     11.2.0.06.44     Loaded
            Oracle SQL Developer - 3rd Party Database Browsers     oracle.sqldeveloper.thirdparty.browsers     11.2.0.06.44     Loaded
            Oracle SQL Developer - Change Mangement     oracle.sqldeveloper.em_cm     11.2.0.06.44     Loaded
            Oracle SQL Developer - DBA Navigator     oracle.sqldeveloper.dbanavigator     11.2.0.06.44     Loaded
            Oracle SQL Developer - Database Cart     oracle.sqldeveloper.dbcart     11.2.0.06.44     Loaded
            Oracle SQL Developer - Extras     oracle.sqldeveloper.extras     11.2.0.06.44     Loaded
            Oracle SQL Developer - File Navigator     oracle.sqldeveloper.filenavigator     11.2.0.06.44     Loaded
            Oracle SQL Developer - Migrations Antlr3 Translator     oracle.sqldeveloper.migration.translation.core_antlr3     11.2.0.06.44     Loaded
            Oracle SQL Developer - Migrations Application Migration     oracle.sqldeveloper.migration.application     11.2.0.06.44     Loaded
            Oracle SQL Developer - Migrations Core     oracle.sqldeveloper.migration     11.2.0.06.44     Loaded
            Oracle SQL Developer - Migrations DB2     oracle.sqldeveloper.migration.db2     11.2.0.06.44     Loaded
            Oracle SQL Developer - Migrations DB2 Translator     oracle.sqldeveloper.migration.translation.db2     11.2.0.06.44     Loaded
            Oracle SQL Developer - Migrations Microsoft Access     oracle.sqldeveloper.migration.msaccess     11.2.0.06.44     Loaded
            Oracle SQL Developer - Migrations Microsoft SQL Server     oracle.sqldeveloper.migration.sqlserver     11.2.0.06.44     Loaded
            Oracle SQL Developer - Migrations MySQL     oracle.sqldeveloper.migration.mysql     11.2.0.06.44     Loaded
            Oracle SQL Developer - Migrations Sybase Adaptive Server     oracle.sqldeveloper.migration.sybase     11.2.0.06.44     Loaded
            Oracle SQL Developer - Migrations T-SQL Translator     oracle.sqldeveloper.migration.translation.core     11.2.0.06.44     Loaded
            Oracle SQL Developer - Migrations Teradata     oracle.sqldeveloper.migration.teradata     11.2.0.06.44     Loaded
            Oracle SQL Developer - Migrations Teradata SQL Translator     oracle.sqldeveloper.migration.translation.teradata_translator     11.2.0.06.44     Loaded
            Oracle SQL Developer - Migrations Translation UI     oracle.sqldeveloper.migration.translation.gui     11.2.0.06.44     Loaded
            Oracle SQL Developer - Object Viewer     oracle.sqldeveloper.oviewer     11.2.0.06.44     Loaded
            Oracle SQL Developer - Real Time SQL Monitoring     oracle.sqldeveloper.sqlmonitor     11.2.0.06.44     Loaded
            Oracle SQL Developer - Reports     oracle.sqldeveloper.report     11.2.0.06.44     Loaded
            Oracle SQL Developer - Scheduler     oracle.sqldeveloper.scheduler     11.2.0.06.44     Loaded
            Oracle SQL Developer - Schema Browser     oracle.sqldeveloper.schemabrowser     11.2.0.06.44     Loaded
            Oracle SQL Developer - SearchBar     oracle.sqldeveloper.searchbar     11.2.0.06.44     Loaded
            Oracle SQL Developer - Snippet     oracle.sqldeveloper.snippet     11.2.0.06.44     Loaded
            Oracle SQL Developer - Spatial     oracle.sqldeveloper.spatial     11.2.0.06.44     Loaded
            Oracle SQL Developer - TimesTen     oracle.sqldeveloper.timesten     11.2.0.06.44     Loaded
            Oracle SQL Developer - Tuning     oracle.sqldeveloper.tuning     11.2.0.06.44     Loaded
            Oracle SQL Developer - Unit Test     oracle.sqldeveloper.unit_test     11.2.0.06.44     Loaded
            Oracle SQL Developer - User Extensions Support     oracle.sqldeveloper.userextensions     11.2.0.06.44     Loaded
            Oracle SQL Developer - Worksheet v2     oracle.sqldeveloper.worksheet     11.2.0.06.44     Loaded
            Oracle SQL Developer - XML Schema     oracle.sqldeveloper.xmlschema     11.2.0.06.44     Loaded
            Oracle SQL Developer Data Modeler     oracle.datamodeler     3.1.0.687     Loaded
            Oracle SQL Developer Data Modeler - Reports     oracle.sqldeveloper.datamodeler_reports     11.2.0.06.44     Loaded
            PROBE Debugger     oracle.jdeveloper.db.debug.probe     11.1.1.4.37.59.44     Loaded
            Peek     oracle.ide.peek     11.1.1.4.37.59.44     Loaded
            Persistent Storage     oracle.ide.persistence     11.1.1.4.37.59.44     Loaded
            Property Inspector     oracle.ide.inspector     11.1.1.4.37.59.44     Loaded
            QuickDiff     oracle.ide.quickdiff     11.1.1.4.37.59.44     Loaded
            Replace With     oracle.ide.replace     11.1.1.4.37.59.44     Loaded
            Runner     oracle.ide.runner     11.1.1.4.37.59.44     Loaded
            VHV     oracle.ide.vhv     11.1.1.4.37.59.44     Loaded
            Versioning Support     oracle.jdeveloper.vcs     11.1.1.4.37.59.44     Loaded
            Versioning Support for Subversion     oracle.jdeveloper.subversion     11.1.1.4.37.59.44     Loaded
            Virtual File System     oracle.ide.vfs     11.1.1.4.37.59.44     Loaded
            Web Browser and Proxy     oracle.ide.webbrowser     11.1.1.4.37.59.44     Loaded
            XML Editing Framework IDE Extension     oracle.ide.xmlef     11.1.1.4.37.59.44     Loaded
            audit     oracle.ide.audit     11.1.1.4.37.59.44     Loaded
            classpath: protocol handler extension     oracle.jdeveloper.classpath     11.1.1.0.0     Loaded
            jdukshare     oracle.bm.jdukshare     11.1.1.4.37.59.44     Loaded
            mof-xmi     oracle.mof.xmi     11.1.1.4.37.59.44     Loaded
            oracle.ide.dependency     oracle.ide.dependency     11.1.1.4.37.59.44     Loaded
            oracle.ide.indexing     oracle.ide.indexing     11.1.1.4.37.59.44     Loaded
            palette2     oracle.ide.palette2     11.1.1.4.37.59.44     Loaded
            status     oracle.ide.status     11.1.1.4.37.59.44     Loaded
            • 3. Re: SQLD 3.1EA Closed Connection Bug
              793954
              Updating to J6u30 did not help. The very first time you try and open a table from the tables list, you get "Your database connection has been reset. Any pending transactions or session state has been lost". Every subsequent attempt to look at the columns tab of any table will return the "Closed Connection Vendor code 17008" error.
              • 4. Re: SQLD 3.1EA Closed Connection Bug
                gerton
                Have the same problem with SQLDeveloper 3.0.04.34 and SQLDeveloper 3.1.0.42
                Both installations are 64bit using external JDK (64bit) installation: JDK 1.6.0_24

                Problem of getting a connection reset when selecting a table from the explorer window is only happening when connecting using the connection type "Basic". When using the connection type "TNS" to the same remote database server (9.2.0.5.0, Solaris 64bit) the selected table is opened in a new tab and showing details.
                The used SQL-net client for the TNSNames is a locally installed 11g rel2 database (64bit)

                The problem does not occur when connecting using Basic connection setting to the locally installed 11g rel2 database.

                Summary:

                SQLDeveloper(64bit) -> Basic connection -> Local 11grel2(64bit) database = working
                SQLDeveloper(64bit) -> Basic connection -> remote 9.0.2.5 (64bit) database = not working
                SQLDeveloper(64bit) -> TNS connection (Local 11grel2(64bit) database as client) -> remote 9.0.2.5 (64bit) database = working
                • 5. Re: SQLD 3.1EA Closed Connection Bug
                  Gary Graham-Oracle
                  Hi Gerton,

                  See if John McGinnis' advice for the JDBC driver 'Out of Band Breaks' bug is of help:
                  Re: SQL Developer: Not able to view tables

                  Regards,
                  Gary
                  SQL Developer Team
                  • 6. Re: SQLD 3.1EA Closed Connection Bug
                    Matthew Morris
                    I'm having problems that match Gerton's and the original poster's symptoms right on the nose. I have tried the OOB suggestion without any hint of an improvement.

                    As with Gerton, I have two databases I connect to routinely. One is not what I would call 'local' (i.e. it is not on the same PC as is running SQL*Dev) but it is in a server room on the local network in my building. The server that gives me a problem is hosted in a datacenter a few miles away. I'm using basic connection for both. The 'local' server does not have this problem, but the hosted one does. The two databases are almost identical -- the local one is my QA server and the hosted one my Production server. The local one is running 11.2.0.2 and production 11.2.0.3.

                    I love SQL*Developer but this issue has made the tool practically unusable to me since I moved this server to the hosted center a few weeks ago.

                    I'm perfectly willing to provide whatever information you need to work on a resolution to this.



                    About
                    -----

                    Oracle SQL Developer 3.1.07
                    Version 3.1.07
                    Build MAIN-07.42
                    Copyright © 2005, 2011 Oracle. All Rights Reserved.
                    IDE Version: 11.1.1.4.37.59.48
                    Product ID: oracle.sqldeveloper
                    Product Version: 11.2.0.07.42

                    Version
                    -------

                    Component     Version
                    =========     =======
                    Java(TM) Platform     1.6.0_11
                    Oracle IDE     3.1.07.42
                    Versioning Support     3.1.07.42

                    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.bootstrap.start     23263657940110
                    ide.build     MAIN-07.42
                    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     17680
                    ide.main.class     oracle.ide.boot.IdeLauncher
                    ide.patches.dir     ide/lib/patches
                    ide.pref.dir     C:\Users\mmorris\AppData\Roaming\SQL Developer
                    ide.pref.dir.base     C:\Users\mmorris\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\sqldeveloper.exe
                    ide.startingcwd     C:\Program Files\sqldeveloper
                    ide.user.dir     C:\Users\mmorris\AppData\Roaming\SQL Developer
                    ide.user.dir.var     IDE_USER_DIR
                    ide.vcs.noapplications     true
                    ide.work.dir     C:\Users\mmorris\Documents\SQL Developer
                    ide.work.dir.base     C:\Users\mmorris\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     50.0
                    java.endorsed.dirs     C:\Program Files\sqldeveloper\jdk\jre\lib\endorsed
                    java.ext.dirs     C:\Program Files\sqldeveloper\jdk\jre\lib\ext;C:\Windows\Sun\Java\lib\ext
                    java.home     C:\Program Files\sqldeveloper\jdk\jre
                    java.io.tmpdir     C:\Users\mmorris\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\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\;C:\Program Files\Intel\DMIX;C:\Program Files (x86)\NTRU Cryptosystems\NTRU TCG Software Stack\bin\;C:\Program Files\NTRU Cryptosystems\NTRU TCG Software Stack\bin\;C:\Program Files (x86)\Intel\Services\IPT\;C:\Program Files\Dell\Dell Data Protection\Access\Advanced\Wave\Gemalto\Access Client\v5\;C:\Program Files (x86)\Common Files\Roxio Shared\DLLShared\;C:\Program Files (x86)\Common Files\Roxio Shared\OEM\DLLShared\;C:\Program Files (x86)\Common Files\Roxio Shared\OEM\DLLShared\;C:\Program Files (x86)\Common Files\Roxio Shared\OEM\12.0\DLLShared\;C:\Program Files (x86)\Roxio\OEM\AudioCore\
                    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.6.0_11-b03
                    java.specification.name     Java Platform API Specification
                    java.specification.vendor     Sun Microsystems Inc.
                    java.specification.version     1.6
                    java.vendor     Sun Microsystems Inc.
                    java.vendor.url     http://java.sun.com/
                    java.vendor.url.bug     http://java.sun.com/cgi-bin/bugreport.cgi
                    java.version     1.6.0_11
                    java.vm.info     mixed mode
                    java.vm.name     Java HotSpot(TM) Client VM
                    java.vm.specification.name     Java Virtual Machine Specification
                    java.vm.specification.vendor     Sun Microsystems Inc.
                    java.vm.specification.version     1.0
                    java.vm.vendor     Sun Microsystems Inc.
                    java.vm.version     11.0-b16
                    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.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     x86
                    os.name     Windows Vista
                    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$
                    sun.arch.data.model     32
                    sun.boot.class.path     C:\Program Files\sqldeveloper\jdk\jre\lib\resources.jar;C:\Program Files\sqldeveloper\jdk\jre\lib\rt.jar;C:\Program Files\sqldeveloper\jdk\jre\lib\sunrsasign.jar;C:\Program Files\sqldeveloper\jdk\jre\lib\jsse.jar;C:\Program Files\sqldeveloper\jdk\jre\lib\jce.jar;C:\Program Files\sqldeveloper\jdk\jre\lib\charsets.jar;C:\Program Files\sqldeveloper\jdk\jre\classes
                    sun.boot.library.path     C:\Program Files\sqldeveloper\jdk\jre\bin
                    sun.cpu.endian     little
                    sun.cpu.isalist     pentium_pro+mmx pentium_pro pentium+mmx pentium i486 i386 i86
                    sun.desktop     windows
                    sun.io.unicode.encoding     UnicodeLittle
                    sun.java2d.ddoffscreen     false
                    sun.jnu.encoding     Cp1252
                    sun.management.compiler     HotSpot Client Compiler
                    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\mmorris
                    user.language     en
                    user.name     mmorris
                    user.timezone     America/New_York
                    user.variant     
                    windows.shell.font.languages
                    • 7. Re: SQLD 3.1EA Closed Connection Bug
                      Gary Graham-Oracle
                      Hi Matthew,

                      Here is a recent thread where the OOB suggestion worked for the poster, but switching from SHARED to DEDICATED server was the preferred fix:
                      Re: SQL Developer 3.x Disconnection Problem

                      If you currently use SERVER = SHARED, perhaps switching to DEDICATED will also work in your situation.

                      Regards,
                      Gary
                      • 8. Re: SQLD 3.1EA Closed Connection Bug
                        Matthew Morris
                        I'm not a very sharing person (or so my wife claims).

                        The server is strictly dedicated. Checking just to be 100% sure, V$SESSION shows DEDICATED in the server column.
                        • 9. Re: SQLD 3.1EA Closed Connection Bug
                          Gary Graham-Oracle
                          So it makes sense that if the OOB suggestion did not work, DEDICATED also won't buy you anything. Possibly the same with regard to DBA privileges (also SELECT_CATALOG_ROLE role or SELECT ANY DICTIONARY system privilege) as discussed in the original OOB suggestion thread.

                          The only other thing I can find with regard to DB 11.2.0.3 and SQL Developer 3.1 is a regression when selecting LONG columns:
                          SQL Error: Stream has already been closed using SQLDev 3.1

                          Or maybe there is some network issue between your location and the more distant data center? Hardware issues are always a possibility.

                          Hope this helps,
                          Gary
                          • 10. Re: SQLD 3.1EA Closed Connection Bug
                            Matthew Morris
                            Possibly the same with regard to DBA privileges
                            I'm the DBA and the account has the DBA role.

                            Or maybe there is some network issue between your location and the more distant data center?
                            I have a second laptop that uses SQL*Dev 2.1.1.64.45 (running under XP) and does not see this problem. It's three feet from the laptop running 3.1.

                            I actually tried installing v2.1 on my new laptop with Windows 7 and still wasn't able to get it to work 100%. Was wondering if it was a Windows 7/64-bit issue. I don't know how to get any diagnostic data back from SQL*Dev to troubleshoot what is happening at the time of the hang. That's really what I was hoping for.
                            • 11. Re: SQLD 3.1EA Closed Connection Bug
                              Jim Smith
                              matthew_morris wrote:

                              I actually tried installing v2.1 on my new laptop with Windows 7 and still wasn't able to get it to work 100%. Was wondering if it was a Windows 7/64-bit issue. I don't know how to get any diagnostic data back from SQL*Dev to troubleshoot what is happening at the time of the hang. That's really what I was hoping for.
                              Start SQLDeveloper using <sqldev>\sqldeveloper\bin\sqldeveloper.exe

                              That leaves console open which will display java errors. If you hit control - break in the console when SQL Developer is hung you will get a thread dump which you can post here.
                              • 12. Re: SQLD 3.1EA Closed Connection Bug
                                Gary Graham-Oracle
                                Aside from debugging this as detailed by Jim, I forgot to ask -- Did you ever try the TNS connection type? Gerton said that worked, but not Basic.
                                • 13. Re: SQLD 3.1EA Closed Connection Bug
                                  Matthew Morris
                                  Did you ever try the TNS connection type?
                                  I had not, but have since. No appreciable change.

                                  The following is a dump after SQL*Dev hung when I tried to open a package body. The package spec opened instantly. The package body was hung for about three minutes when I got the dump (on my QA server, it opens in under 5 seconds). Unfortunately, some of the first portion of the dump was lost at the top -- hopefully not the really important part. At any rate, this is all the 'Select All' was able to grab.


                                  at java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:198
                                  )
                                  at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject
                                  .awaitNanos(AbstractQueuedSynchronizer.java:1963)
                                  at java.util.concurrent.DelayQueue.take(DelayQueue.java:164)
                                  at java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.tak
                                  e(ScheduledThreadPoolExecutor.java:583)
                                  at java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.tak
                                  e(ScheduledThreadPoolExecutor.java:576)
                                  at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.ja
                                  va:947)
                                  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
                                  .java:907)
                                  at java.lang.Thread.run(Thread.java:619)

                                  "IconOverlayTracker Timer" prio=6 tid=0x37140c00 nid=0x16cc in Object.wait() [0x
                                  3854f000..0x3854fb14]
                                  java.lang.Thread.State: WAITING (on object monitor)
                                  at java.lang.Object.wait(Native Method)
                                  - waiting on <0x075f1248> (a java.util.TaskQueue)
                                  at java.lang.Object.wait(Object.java:485)
                                  at java.util.TimerThread.mainLoop(Timer.java:483)
                                  - locked <0x075f1248> (a java.util.TaskQueue)
                                  at java.util.TimerThread.run(Timer.java:462)

                                  "WaitCursor-Timer" prio=6 tid=0x34c98400 nid=0x1014 in Object.wait() [0x381cf000
                                  ..0x381cfc94]
                                  java.lang.Thread.State: WAITING (on object monitor)
                                  at java.lang.Object.wait(Native Method)
                                  - waiting on <0x071775b8> (a java.util.TaskQueue)
                                  at java.lang.Object.wait(Object.java:485)
                                  at java.util.TimerThread.mainLoop(Timer.java:483)
                                  - locked <0x071775b8> (a java.util.TaskQueue)
                                  at java.util.TimerThread.run(Timer.java:462)

                                  "BaseTreeExplorer.NodeOpeningExecutor" prio=6 tid=0x34ca4000 nid=0xd50 waiting o
                                  n condition [0x36ccf000..0x36ccfa94]
                                  java.lang.Thread.State: WAITING (parking)
                                  at sun.misc.Unsafe.park(Native Method)
                                  - parking to wait for <0x06c4abd0> (a java.util.concurrent.locks.Abstra
                                  ctQueuedSynchronizer$ConditionObject)
                                  at java.util.concurrent.locks.LockSupport.park(LockSupport.java:158)
                                  at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject
                                  .await(AbstractQueuedSynchronizer.java:1925)
                                  at java.util.concurrent.LinkedBlockingQueue.take(LinkedBlockingQueue.jav
                                  a:358)
                                  at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.ja
                                  va:947)
                                  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
                                  .java:907)
                                  at java.lang.Thread.run(Thread.java:619)

                                  "pool-2-thread-1" prio=6 tid=0x34a49400 nid=0x1528 waiting on condition [0x36bcf
                                  000..0x36bcfb14]
                                  java.lang.Thread.State: WAITING (parking)
                                  at sun.misc.Unsafe.park(Native Method)
                                  - parking to wait for <0x06d1e888> (a java.util.concurrent.SynchronousQ
                                  ueue$TransferStack)
                                  at java.util.concurrent.locks.LockSupport.park(LockSupport.java:158)
                                  at java.util.concurrent.SynchronousQueue$TransferStack.awaitFulfill(Sync
                                  hronousQueue.java:422)
                                  at java.util.concurrent.SynchronousQueue$TransferStack.transfer(Synchron
                                  ousQueue.java:323)
                                  at java.util.concurrent.SynchronousQueue.take(SynchronousQueue.java:857)

                                  at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.ja
                                  va:947)
                                  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
                                  .java:907)
                                  at java.lang.Thread.run(Thread.java:619)

                                  "Scheduler" daemon prio=6 tid=0x34ca8c00 nid=0x1780 in Object.wait() [0x36acf000
                                  ..0x36acfb94]
                                  java.lang.Thread.State: WAITING (on object monitor)
                                  at java.lang.Object.wait(Native Method)
                                  - waiting on <0x06c4ada0> (a oracle.dbtools.raptor.backgroundTask.TaskLi
                                  nkedList)
                                  at java.lang.Object.wait(Object.java:485)
                                  at oracle.dbtools.raptor.backgroundTask.TaskLinkedList.takeNextTask(Task
                                  LinkedList.java:47)
                                  - locked <0x06c4ada0> (a oracle.dbtools.raptor.backgroundTask.TaskLinked
                                  List)
                                  at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$SchedulerThrea
                                  d.run(RaptorTaskManager.java:422)

                                  "TimerQueue" daemon prio=6 tid=0x34ca1400 nid=0x27c in Object.wait() [0x369cf000
                                  ..0x369cfc14]
                                  java.lang.Thread.State: TIMED_WAITING (on object monitor)
                                  at java.lang.Object.wait(Native Method)
                                  - waiting on <0x069cc498> (a javax.swing.TimerQueue)
                                  at javax.swing.TimerQueue.run(TimerQueue.java:236)
                                  - locked <0x069cc498> (a javax.swing.TimerQueue)
                                  at java.lang.Thread.run(Thread.java:619)

                                  "ChangeSetService" prio=2 tid=0x34aeb000 nid=0x98c in Object.wait() [0x367cf000.
                                  .0x367cfd14]
                                  java.lang.Thread.State: WAITING (on object monitor)
                                  at java.lang.Object.wait(Native Method)
                                  - waiting on <0x068ce940> (a oracle.jdevimpl.vcs.changeset.ChangeSetServ
                                  ice)
                                  at java.lang.Object.wait(Object.java:485)
                                  at oracle.jdevimpl.vcs.changeset.ChangeSetService.awaitEvents(ChangeSetS
                                  ervice.java:178)
                                  - locked <0x068ce940> (a oracle.jdevimpl.vcs.changeset.ChangeSetService)

                                  at oracle.jdevimpl.vcs.changeset.ChangeSetService.eventLoop(ChangeSetSer
                                  vice.java:199)
                                  at oracle.jdevimpl.vcs.changeset.ChangeSetService.access$200(ChangeSetSe
                                  rvice.java:56)
                                  at oracle.jdevimpl.vcs.changeset.ChangeSetService$2.run(ChangeSetService
                                  .java:138)
                                  at java.lang.Thread.run(Thread.java:619)

                                  "TimedCache-Timer" daemon prio=6 tid=0x33a9e000 nid=0x17bc in Object.wait() [0x3
                                  468f000..0x3468fa94]
                                  java.lang.Thread.State: WAITING (on object monitor)
                                  at java.lang.Object.wait(Native Method)
                                  - waiting on <0x06335c40> (a java.util.TaskQueue)
                                  at java.lang.Object.wait(Object.java:485)
                                  at java.util.TimerThread.mainLoop(Timer.java:483)
                                  - locked <0x06335c40> (a java.util.TaskQueue)
                                  at java.util.TimerThread.run(Timer.java:462)

                                  "JarIndex Timer" daemon prio=6 tid=0x33a7d400 nid=0xf90 in Object.wait() [0x3418
                                  f000..0x3418fb14]
                                  java.lang.Thread.State: TIMED_WAITING (on object monitor)
                                  at java.lang.Object.wait(Native Method)
                                  - waiting on <0x06270bd8> (a java.util.TaskQueue)
                                  at java.util.TimerThread.mainLoop(Timer.java:509)
                                  - locked <0x06270bd8> (a java.util.TaskQueue)
                                  at java.util.TimerThread.run(Timer.java:462)

                                  "AWT-EventQueue-0" prio=6 tid=0x33a3e800 nid=0x1334 runnable [0x33fae000..0x33fa
                                  fb94]
                                  java.lang.Thread.State: RUNNABLE
                                  at java.net.SocketInputStream.socketRead0(Native Method)
                                  at java.net.SocketInputStream.read(SocketInputStream.java:129)
                                  at oracle.net.ns.Packet.receive(Packet.java:289)
                                  at oracle.net.ns.DataPacket.receive(DataPacket.java:92)
                                  at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:172)
                                  at oracle.net.ns.NetInputStream.read(NetInputStream.java:117)
                                  at oracle.net.ns.NetInputStream.read(NetInputStream.java:92)
                                  at oracle.net.ns.NetInputStream.read(NetInputStream.java:77)
                                  at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1023)
                                  at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:999)
                                  at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:584)
                                  at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.
                                  java:191)
                                  at oracle.jdbc.driver.T4CCallableStatement.fetch(T4CCallableStatement.ja
                                  va:1008)
                                  at oracle.jdbc.driver.OracleResultSetImpl.close_or_fetch_from_next(Oracl
                                  eResultSetImpl.java:314)
                                  - locked <0x07694350> (a oracle.jdbc.driver.T4CConnection)
                                  at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:
                                  228)
                                  - locked <0x07694350> (a oracle.jdbc.driver.T4CConnection)
                                  at oracle.dbtools.raptor.navigator.net.DBURLStreamHandlerFactory.fetchSo
                                  urce(DBURLStreamHandlerFactory.java:214)
                                  at oracle.dbtools.raptor.navigator.net.DBURLFileSystemHelper.createReade
                                  r(DBURLFileSystemHelper.java:158)
                                  at oracle.ide.net.URLFileSystem.createReader(URLFileSystem.java:1630)
                                  at oracle.ide.model.TextNode.createReader(TextNode.java:1680)
                                  at oracle.ide.model.TextNode.loadTextBuffer(TextNode.java:288)
                                  at oracle.ide.model.TextNode.openImpl(TextNode.java:518)
                                  at oracle.dbtools.raptor.navigator.plsql.PlSqlNode.openImpl(PlSqlNode.ja
                                  va:74)
                                  at oracle.ide.model.Node.open(Node.java:974)
                                  at oracle.ide.model.Node.open(Node.java:922)
                                  at oracle.ide.model.Node.ensureOpen(Node.java:2132)
                                  at oracle.ide.model.TextNode.acquireTextBuffer(TextNode.java:732)
                                  at oracle.dbtools.raptor.oviewer.base.NavSelectionListener.open(NavSelec
                                  tionListener.java:284)
                                  at oracle.dbtools.raptor.oviewer.base.NavSelectionListener.whenDatabaseO
                                  bjectSelected(NavSelectionListener.java:217)
                                  at oracle.dbtools.raptor.oviewer.base.NavSelectionListener.mouseClicked(
                                  NavSelectionListener.java:443)
                                  at java.awt.AWTEventMulticaster.mouseClicked(AWTEventMulticaster.java:25
                                  3)
                                  at java.awt.AWTEventMulticaster.mouseClicked(AWTEventMulticaster.java:25
                                  2)
                                  at java.awt.Component.processMouseEvent(Component.java:6137)
                                  at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
                                  at oracle.ideimpl.explorer.CustomTree.processMouseEvent(CustomTree.java:
                                  216)
                                  at java.awt.Component.processEvent(Component.java:5899)
                                  at java.awt.Container.processEvent(Container.java:2023)
                                  at java.awt.Component.dispatchEventImpl(Component.java:4501)
                                  at java.awt.Container.dispatchEventImpl(Container.java:2081)
                                  at java.awt.Component.dispatchEvent(Component.java:4331)
                                  at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4301
                                  )
                                  at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3974)

                                  at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3895)
                                  at java.awt.Container.dispatchEventImpl(Container.java:2067)
                                  at java.awt.Window.dispatchEventImpl(Window.java:2458)
                                  at java.awt.Component.dispatchEvent(Component.java:4331)
                                  at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
                                  at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThre
                                  ad.java:269)
                                  at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.
                                  java:184)
                                  at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre
                                  ad.java:174)
                                  at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)

                                  at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)

                                  at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)

                                  "AWT-Windows" daemon prio=6 tid=0x33a33000 nid=0x64c runnable [0x33daf000..0x33d
                                  afc94]
                                  java.lang.Thread.State: RUNNABLE
                                  at sun.awt.windows.WToolkit.eventLoop(Native Method)
                                  at sun.awt.windows.WToolkit.run(WToolkit.java:291)
                                  at java.lang.Thread.run(Thread.java:619)

                                  "AWT-Shutdown" prio=6 tid=0x33a32000 nid=0xdf0 in Object.wait() [0x33caf000..0x3
                                  3cafd14]
                                  java.lang.Thread.State: WAITING (on object monitor)
                                  at java.lang.Object.wait(Native Method)
                                  - waiting on <0x06270de0> (a java.lang.Object)
                                  at java.lang.Object.wait(Object.java:485)
                                  at sun.awt.AWTAutoShutdown.run(AWTAutoShutdown.java:259)
                                  - locked <0x06270de0> (a java.lang.Object)
                                  at java.lang.Thread.run(Thread.java:619)

                                  "Java2D Disposer" daemon prio=10 tid=0x33a2a800 nid=0xe24 in Object.wait() [0x33
                                  baf000..0x33bafd94]
                                  java.lang.Thread.State: WAITING (on object monitor)
                                  at java.lang.Object.wait(Native Method)
                                  - waiting on <0x06270e70> (a java.lang.ref.ReferenceQueue$Lock)
                                  at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:116)
                                  - locked <0x06270e70> (a java.lang.ref.ReferenceQueue$Lock)
                                  at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:132)
                                  at sun.java2d.Disposer.run(Disposer.java:125)
                                  at java.lang.Thread.run(Thread.java:619)

                                  "Low Memory Detector" daemon prio=6 tid=0x00f55800 nid=0x950 runnable [0x0000000
                                  0..0x00000000]
                                  java.lang.Thread.State: RUNNABLE

                                  "CompilerThread0" daemon prio=10 tid=0x00f4f800 nid=0x3b4 waiting on condition [
                                  0x00000000..0x336af7bc]
                                  java.lang.Thread.State: RUNNABLE

                                  "Attach Listener" daemon prio=10 tid=0x00f4e000 nid=0xf58 runnable [0x00000000..
                                  0x00000000]
                                  java.lang.Thread.State: RUNNABLE

                                  "Signal Dispatcher" daemon prio=10 tid=0x00f4cc00 nid=0xfa8 waiting on condition
                                  [0x00000000..0x00000000]
                                  java.lang.Thread.State: RUNNABLE

                                  "Finalizer" daemon prio=8 tid=0x00f3d000 nid=0x1068 in Object.wait() [0x333af000
                                  ..0x333afc94]
                                  java.lang.Thread.State: WAITING (on object monitor)
                                  at java.lang.Object.wait(Native Method)
                                  - waiting on <0x061e0298> (a java.lang.ref.ReferenceQueue$Lock)
                                  at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:116)
                                  - locked <0x061e0298> (a java.lang.ref.ReferenceQueue$Lock)
                                  at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:132)
                                  at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:159)

                                  "Reference Handler" daemon prio=10 tid=0x00f38400 nid=0x13d4 in Object.wait() [0
                                  x332af000..0x332afd14]
                                  java.lang.Thread.State: WAITING (on object monitor)
                                  at java.lang.Object.wait(Native Method)
                                  - waiting on <0x061e0320> (a java.lang.ref.Reference$Lock)
                                  at java.lang.Object.wait(Object.java:485)
                                  at java.lang.ref.Reference$ReferenceHandler.run(Reference.java:116)
                                  - locked <0x061e0320> (a java.lang.ref.Reference$Lock)

                                  "main" prio=6 tid=0x00937400 nid=0x132c waiting on condition [0x00000000..0x0012
                                  fae8]
                                  java.lang.Thread.State: RUNNABLE

                                  "VM Thread" prio=10 tid=0x00f34c00 nid=0x7dc runnable

                                  "VM Periodic Task Thread" prio=10 tid=0x00f57800 nid=0xb30 waiting on condition


                                  JNI global references: 2121

                                  Heap
                                  def new generation total 9216K, used 3025K [0x030b0000, 0x03aa0000, 0x061e000
                                  0)
                                  eden space 8256K, 25% used [0x030b0000, 0x032b47c0, 0x038c0000)
                                  from space 960K, 100% used [0x039b0000, 0x03aa0000, 0x03aa0000)
                                  to space 960K, 0% used [0x038c0000, 0x038c0000, 0x039b0000)
                                  tenured generation total 121024K, used 25706K [0x061e0000, 0x0d810000, 0x2b0b
                                  0000)
                                  the space 121024K, 21% used [0x061e0000, 0x07afa828, 0x07afaa00, 0x0d810000)

                                  compacting perm gen total 47872K, used 47806K [0x2b0b0000, 0x2df70000, 0x330b0
                                  000)
                                  the space 47872K, 99% used [0x2b0b0000, 0x2df5fa68, 0x2df5fc00, 0x2df70000)
                                  No shared spaces configured.
                                  • 14. Re: SQLD 3.1EA Closed Connection Bug
                                    Gary Graham-Oracle
                                    So now I'm slightly confused ... is this a connection reset that hangs the UI, or some other type of hang?

                                    Perhaps the hang eventually ends since the (partial) thread dump shows no deadlock and no OutOfMemory condition. Comparing your trace immediately after AWT-EventQueue-0 ... java.lang.Thread.State: RUNNABLE with the trace here:
                                    Re: Consistent Hang

                                    we see they are both waiting on results from the database via JDBC. But the database can't be to blame because the WinXP laptop nearby with 2.1 works fine ... but I guess it could still be the network card in the newer machine. It would be nice if you could find another Win7 with SQL Developer 3.1 installed to confirm the problem still occurs. Or install 2.1 on Win7 and see if that still works fine.

                                    This seems to be a tough nut to crack. And maybe I'm not very good at reading thread dumps.

                                    -Gary
                                    1 2 Previous Next