2 Replies Latest reply on May 4, 2011 9:47 AM by 859471

    Connection lost problem?

    Sammi
      Dear all,


      I just tried the version 3.0 EA and found the following problem. After I made a connection and click on a table, the table information will be displayed as normal for the first time. When I click on another table, the following error occurs. One click will get one line of error in the Logging Page - Log sheet.

      SEVERE     41     995     oracle.dbtools.raptor.controls.grid.TPDBResultSetModel     Connection to null not available
      SEVERE     40     1204     oracle.dbtools.raptor.controls.grid.TPDBResultSetModel     Connection to null not available
      SEVERE     39     1204     oracle.dbtools.raptor.controls.grid.TPDBResultSetModel     Connection to null not available
      SEVERE     38     1734     oracle.dbtools.raptor.controls.grid.TPDBResultSetModel     Connection to null not available
      SEVERE     37     3044     oracle.dbtools.raptor.controls.grid.TPDBResultSetModel     Connection to null not available
      SEVERE     36     0     oracle.dbtools.raptor.controls.grid.TPDBResultSetModel     Connection to null not available

      Sometimes will be
      SEVERE     45     5     oracle.dbtools.db.DBUtil     Warning, unhandled exception: ORA-00942: table or view does not exist
      SEVERE     44     20     oracle.dbtools.db.DBUtil     Warning, unhandled exception: ORA-00942: table or view does not exist
      SEVERE     43     4     oracle.dbtools.db.DBUtil     Warning, unhandled exception: ORA-00942: table or view does not exist
      SEVERE     42     479111     oracle.dbtools.db.DBUtil     Warning, unhandled exception: ORA-00942: table or view does not exist
      SEVERE     41     995     oracle.dbtools.raptor.controls.grid.TPDBResultSetModel     Connection to null not available



      I have encounter this problem while using the 2.x version, but after I tried different versions of SQLDeveloper (32bit/64bit) and Java JDK, I found a combination that most of the problem is fixed. Now I tried the version 3.0 EA with the same JDK that is using by the 2.x version, this error appears again.

      I am using Win7 64 bit. I tried the 64bit, 32bit, and 32bit with JDK of 3.0 EA and the problem is still here. Can anyone help me?


      Thanks a lot
        • 1. Re: Connection lost problem?
          Sammi
          any suggestion?
          • 2. Re: Connection lost problem?
            859471
            Sadly I can confirm this problem also in the well configured migration wizard, when trying an online migration from sybayse 12 to oracleXE 10g:


            SEVERE     67     0     oracle.dbtools.raptor.controls.grid.TPDBResultSetModel     Verbindung mit null nicht verfügbar [german translation from "Connection to null not available"]
            SEVERE     66     222031     oracle.dbtools.raptor.controls.grid.TPDBResultSetModel     Verbindung mit null nicht verfügbar
            SEVERE     64     0     oracle.dbtools.raptor.controls.grid.TPDBResultSetModel     Verbindung mit null nicht verfügbar


            In the following all detail information copied from the about dialog. This version of SQL Developer was downloaded and installed at May-03-2011
            -----------------------------------------

            Info
            ----

            Oracle SQL Developer 3.0.04
            Version 3.0.04
            Build MAIN-04.34
            Copyright © 2005, 2011 Oracle. All Rights Reserved. Alle Rechte vorbehalten.
            IDE Version: 11.1.1.4.37.59.31
            Product ID: oracle.sqldeveloper
            Product Version: 11.1.2.04.34

            Version
            -------

            Komponente     Version
            ==========     =======
            Java(TM)-Plattform     1.6.0_11
            Oracle-IDE     3.0.04.34
            Versionierungsunterstützung     3.0.04.34

            Eigenschaften
            -------------

            Name     Wert
            ====     ====
            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     17476182009724
            ide.build     MAIN-04.34
            ide.conf     C:\!Install\Oracle\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf
            ide.config_pathname     C:\!Install\Oracle\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     2808
            ide.main.class     oracle.ide.boot.IdeLauncher
            ide.patches.dir     ide/lib/patches
            ide.pref.dir     C:\Documents and Settings\dmadmin\Application Data\SQL Developer
            ide.pref.dir.base     C:\Documents and Settings\dmadmin\Application Data
            ide.product     oracle.sqldeveloper
            ide.shell.enableFileTypeAssociation     C:\!Install\Oracle\sqldeveloper\sqldeveloper.exe
            ide.splash.screen     splash.gif
            ide.startingArg0     C:\!Install\Oracle\sqldeveloper\sqldeveloper.exe
            ide.startingcwd     C:\!Install\Oracle\sqldeveloper
            ide.user.dir     C:\Documents and Settings\dmadmin\Application Data\SQL Developer
            ide.user.dir.var     IDE_USER_DIR
            ide.vcs.noapplications     true
            ide.work.dir     C:\Documents and Settings\dmadmin\My Documents\SQL Developer
            ide.work.dir.base     C:\Documents and Settings\dmadmin\My 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:\!Install\Oracle\sqldeveloper\jdk\jre\lib\endorsed
            java.ext.dirs     C:\!Install\Oracle\sqldeveloper\jdk\jre\lib\ext;C:\WINDOWS\Sun\Java\lib\ext
            java.home     C:\!Install\Oracle\sqldeveloper\jdk\jre
            java.io.tmpdir     C:\DOCUME~1\dmadmin\LOCALS~1\Temp\
            java.library.path     C:\!Install\Oracle\sqldeveloper;.;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\oraclexe\app\oracle\product\10.2.0\server\bin;C:\sybase\DataAccess\ADONET\dll;C:\sybase\DataAccess\OLEDB\dll;C:\sybase\DataAccess\ODBC\dll;C:\sybase\RPL-15_0\bin;C:\sybase\Shared\Sybase Central 4.3;C:\sybase\UAF-2_0\bin;C:\sybase\OCS-15_0\lib3p;C:\sybase\OCS-15_0\dll;C:\sybase\OCS-15_0\bin;C:\sybase\ASE-15_0\dll;C:\sybase\ASE-15_0\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Microsoft SQL Server\80\Tools\Binn\;C:\Program Files\Microsoft SQL Server\90\DTS\Binn\;C:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\;C:\PROGRA~1\IBM\SQLLIB\BIN;C:\PROGRA~1\IBM\SQLLIB\FUNCTION;C:\PROGRA~1\IBM\SQLLIB\SAMPLES\REPL;C:\sybase\DBISQL\bin
            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.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_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:/!Install/Oracle/sqldeveloper/jdbc/lib/ojdbc6.jar
            line.separator     \r\n
            log.file.name     C:\!Install\Oracle\sqldeveloper\sqldeveloper\extensions\oracle.datamodeler\log\datamodeler.log
            oracle.home     C:\!Install\Oracle\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:/!Install/Oracle/sqldeveloper/jlib/orai18n.jar
            os.arch     x86
            os.name     Windows 2003
            os.version     5.2
            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     32
            sun.boot.class.path     C:\!Install\Oracle\sqldeveloper\jdk\jre\lib\resources.jar;C:\!Install\Oracle\sqldeveloper\jdk\jre\lib\rt.jar;C:\!Install\Oracle\sqldeveloper\jdk\jre\lib\sunrsasign.jar;C:\!Install\Oracle\sqldeveloper\jdk\jre\lib\jsse.jar;C:\!Install\Oracle\sqldeveloper\jdk\jre\lib\jce.jar;C:\!Install\Oracle\sqldeveloper\jdk\jre\lib\charsets.jar;C:\!Install\Oracle\sqldeveloper\jdk\jre\classes
            sun.boot.library.path     C:\!Install\Oracle\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     DE
            user.dir     C:\!Install\Oracle\sqldeveloper\sqldeveloper\bin
            user.home     C:\Documents and Settings\dmadmin
            user.language     de
            user.name     dmadmin
            user.timezone     Europe/Berlin
            user.variant     
            windows.shell.font.languages     

            Erweiterungen
            -------------

            Name     Identifier     Version     Status
            ====     ==========     =======     ======
            Add-In JViews-Registrierung     oracle.diagram.registration     11.1.1.4.37.59.31     Geladen
            Audit     oracle.ide.audit     11.1.1.4.37.59.31     Geladen
            Check For Updates     oracle.ide.webupdate     11.1.1.4.37.59.31     Geladen
            Classpath: Protokoll-Handler-Erweiterung     oracle.jdeveloper.classpath     11.1.1.0.0     Geladen
            Code Editor     oracle.ide.ceditor     11.1.1.4.37.59.31     Geladen
            Component Palette     oracle.ide.palette1     11.1.1.4.37.59.31     Geladen
            Data Miner     oracle.dmt.dataminer     11.2.0.1.10.109     Geladen
            Datenbank-UI     oracle.ide.db     11.1.1.4.37.59.31     Geladen
            Datenbankobjekt-Explorer     oracle.ide.db.explorer     11.1.1.4.37.59.31     Geladen
            Diagram Framework     oracle.diagram     11.1.1.4.37.59.31     Geladen
            Diagram Javadoc Extension     oracle.diagram.javadoc     11.1.1.4.37.59.31     Geladen
            Diagramm-Thumbnail     oracle.diagram.thumbnail     11.1.1.4.37.59.31     Geladen
            Diff/Merge     oracle.ide.diffmerge     11.1.1.4.37.59.31     Geladen
            Extended IDE Platform     oracle.javacore     11.1.1.4.37.59.31     Geladen
            Externe Tools     oracle.ide.externaltools     11.1.1.4.37.59.31     Geladen
            File Support     oracle.ide.files     11.1.1.4.37.59.31     Geladen
            Help System     oracle.ide.help     11.1.1.4.37.59.31     Geladen
            Import/Export Support     oracle.ide.importexport     11.1.1.4.37.59.31     Geladen
            Index Migrator support     oracle.ideimpl.indexing-migrator     11.1.1.4.37.59.31     Geladen
            JDeveloper Runner     oracle.jdeveloper.runner     11.1.1.4.37.59.31     Geladen
            Log Window     oracle.ide.log     11.1.1.4.37.59.31     Geladen
            Mac OS X Adapter     oracle.ideimpl.apple     11.1.1.4.37.59.31     Geladen
            Navigator     oracle.ide.navigator     11.1.1.4.37.59.31     Geladen
            Objektgalerie     oracle.ide.gallery     11.1.1.4.37.59.31     Geladen
            Oracle IDE     oracle.ide     11.1.1.4.37.59.31     Geladen
            Oracle SQL Developer     oracle.sqldeveloper     11.1.2.04.34     Geladen
            Oracle SQL Developer - 3rd Party Database Browsers     oracle.sqldeveloper.thirdparty.browsers     11.1.1.04.34     Geladen
            Oracle SQL Developer - DBA Navigator     oracle.sqldeveloper.dbanavigator     11.1.1.04.34     Geladen
            Oracle SQL Developer - Extras     oracle.sqldeveloper.extras     1.1.1.04.34     Geladen
            Oracle SQL Developer - File Navigator     oracle.sqldeveloper.filenavigator     11.1.1.04.34     Geladen
            Oracle SQL Developer - Migrations Antlr3 Translator     oracle.sqldeveloper.migration.translation.core_antlr3     11.1.1.04.34     Geladen
            Oracle SQL Developer - Migrations Application Migration     oracle.sqldeveloper.migration.application     11.1.1.04.34     Geladen
            Oracle SQL Developer - Migrations Core     oracle.sqldeveloper.migration     11.1.1.04.34     Geladen
            Oracle SQL Developer - Migrations DB2     oracle.sqldeveloper.migration.db2     11.1.1.04.34     Geladen
            Oracle SQL Developer - Migrations DB2 Translator     oracle.sqldeveloper.migration.translation.db2     11.1.1.04.34     Geladen
            Oracle SQL Developer - Migrations Microsoft Access     oracle.sqldeveloper.migration.msaccess     11.1.1.04.34     Geladen
            Oracle SQL Developer - Migrations Microsoft SQL Server     oracle.sqldeveloper.migration.sqlserver     11.1.1.04.34     Geladen
            Oracle SQL Developer - Migrations MySQL     oracle.sqldeveloper.migration.mysql     11.1.1.04.34     Geladen
            Oracle SQL Developer - Migrations Sybase Adaptive Server     oracle.sqldeveloper.migration.sybase     11.1.1.04.34     Geladen
            Oracle SQL Developer - Migrations T-SQL Translator     oracle.sqldeveloper.migration.translation.core     11.1.1.04.34     Geladen
            Oracle SQL Developer - Migrations Teradata     oracle.sqldeveloper.migration.teradata     11.1.1.04.34     Geladen
            Oracle SQL Developer - Migrations Translation UI     oracle.sqldeveloper.migration.translation.gui     11.1.1.04.34     Geladen
            Oracle SQL Developer - Object Viewer     oracle.sqldeveloper.oviewer     11.1.1.04.34     Geladen
            Oracle SQL Developer - Real Time SQL Monitoring     oracle.sqldeveloper.sqlmonitor     11.1.1.04.34     Geladen
            Oracle SQL Developer - Reports     oracle.sqldeveloper.report     11.1.1.04.34     Geladen
            Oracle SQL Developer - Scheduler     oracle.sqldeveloper.scheduler     11.1.1.04.34     Geladen
            Oracle SQL Developer - Schema Browser     oracle.sqldeveloper.schemabrowser     11.1.1.04.34     Geladen
            Oracle SQL Developer - SearchBar     oracle.sqldeveloper.searchbar     11.1.1.04.34     Geladen
            Oracle SQL Developer - Snippet     oracle.sqldeveloper.snippet     11.1.1.04.34     Geladen
            Oracle SQL Developer - Spatial     oracle.sqldeveloper.spatial     11.1.1.04.34     Geladen
            Oracle SQL Developer - TimesTen     oracle.sqldeveloper.timesten     2.0.0.04.34     Geladen
            Oracle SQL Developer - Tuning     oracle.sqldeveloper.tuning     11.1.1.04.34     Geladen
            Oracle SQL Developer - Unit Test     oracle.sqldeveloper.unit_test     11.1.1.04.34     Geladen
            Oracle SQL Developer - User Extensions Support     oracle.sqldeveloper.userextensions     11.1.1.04.34     Geladen
            Oracle SQL Developer - Worksheet v2     oracle.sqldeveloper.worksheet     11.1.1.04.34     Geladen
            Oracle SQL Developer - XML Schema     oracle.sqldeveloper.xmlschema     11.1.1.04.34     Geladen
            Oracle SQL Developer Data Modeler     oracle.datamodeler     3.0.0.665.2     Geladen
            Oracle SQL Developer Data Modeler - Reports     oracle.sqldeveloper.datamodeler_reports     11.1.1.04.34     Geladen
            PROBE Debugger     oracle.jdeveloper.db.debug.probe     11.1.1.4.37.59.31     Geladen
            Palette2     oracle.ide.palette2     11.1.1.4.37.59.31     Geladen
            Peek     oracle.ide.peek     11.1.1.4.37.59.31     Geladen
            Persistent Storage     oracle.ide.persistence     11.1.1.4.37.59.31     Geladen
            Property Inspector     oracle.ide.inspector     11.1.1.4.37.59.31     Geladen
            QuickDiff     oracle.ide.quickdiff     11.1.1.4.37.59.31     Geladen
            Replace With     oracle.ide.replace     11.1.1.4.37.59.31     Geladen
            Runner     oracle.ide.runner     11.1.1.4.37.59.31     Geladen
            Status     oracle.ide.status     11.1.1.4.37.59.31     Geladen
            Unterstützung von Datenbankverbindungen     oracle.jdeveloper.db.connection     11.1.1.4.37.59.31     Geladen
            Unterstützung von Historie     oracle.jdeveloper.history     11.1.1.4.37.59.31     Geladen
            VHV     oracle.ide.vhv     11.1.1.4.37.59.31     Geladen
            Versionierungsunterstützung     oracle.jdeveloper.vcs     11.1.1.4.37.59.31     Geladen
            Versionierungsunterstützung für Subversion     oracle.jdeveloper.subversion     11.1.1.4.37.59.31     Geladen
            Virtual File System     oracle.ide.vfs     11.1.1.4.37.59.31     Geladen
            Web Browser and Proxy     oracle.ide.webbrowser     11.1.1.4.37.59.31     Geladen
            XML Editing Framework IDE Extension     oracle.ide.xmlef     11.1.1.4.37.59.31     Geladen
            jdukshare     oracle.bm.jdukshare     11.1.1.4.37.59.31     Geladen
            mof-xmi     oracle.mof.xmi     11.1.1.4.37.59.31     Geladen
            oracle.ide.dependency     oracle.ide.dependency     11.1.1.4.37.59.31     Geladen
            oracle.ide.indexing     oracle.ide.indexing     11.1.1.4.37.59.31     Geladen