12 Replies Latest reply on Jul 28, 2010 3:23 PM by 787436

    sqldeveloper - java.lang.NullPointerException & Preferences/Database issues

    770963
      <h1>Oracle SQL Developer
      Version 2.1.0.63
      Build MAIN-63.73

      Java(TM) Platform 1.6.0_11
      Oracle IDE 2.1.0.63.73
      Versioning Support 2.1.0.63.73

      Windows XP x32</h1>


      problem 1:

      my sqldeveloper has been working fine for months, then for no apparent reason to me, when i opened it 2 weeks ago, it's missing the SQL Worksheet (the main page) & i cannot open it. i've read lots of other forums where many other have had this same issue, and i attempted ALL their suggested fixes. nothing worked. no one else on my team has had any similar issues, so i'm completely lost.

      when i try to force the SQL Worksheet to open under Tools, i get this Error:

      java.lang.NullPointerException
           at oracle.dbtools.raptor.controls.ConnectionPanelUI.listConnections(ConnectionPanelUI.java:435)
           at oracle.dbtools.raptor.controls.ConnectionPanelUI.resetConnections(ConnectionPanelUI.java:448)
           at oracle.dbtools.raptor.controls.ConnectionPanelUI.<init>(ConnectionPanelUI.java:123)
           at oracle.dbtools.raptor.controls.ConnectionPanelUI.<init>(ConnectionPanelUI.java:101)
           at oracle.dbtools.raptor.controls.ConnectionSelectorUI.<init>(ConnectionSelectorUI.java:29)
           at oracle.dbtools.raptor.controls.ConnectionSelectorUI.getConnection(ConnectionSelectorUI.java:60)
           at oracle.dbtools.raptor.controls.ConnectionSelectorUI.getConnection(ConnectionSelectorUI.java:37)
           at oracle.dbtools.worksheet.editor.OpenWorksheetWizard.invoke(OpenWorksheetWizard.java:279)
           at oracle.ide.wizard.WizardManager.invokeWizard(WizardManager.java:372)
           at oracle.dbtools.worksheet.editor.WorksheetOpenController$1.run(WorksheetOpenController.java:67)
           at oracle.dbtools.worksheet.editor.WorksheetOpenController.openWorksheetWizard(WorksheetOpenController.java:73)
           at oracle.dbtools.worksheet.editor.WorksheetOpenController.handleEvent(WorksheetOpenController.java:34)
           at oracle.ideimpl.controller.IdeActionHook$MetaClassController.handleEvent(IdeActionHook.java:414)
           at oracle.ide.controller.IdeAction.performAction(IdeAction.java:531)
           at oracle.ide.controller.IdeAction.actionPerformedImpl(IdeAction.java:886)
           at oracle.ide.controller.IdeAction.actionPerformed(IdeAction.java:503)
           at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
           at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
           at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
           at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
           at javax.swing.AbstractButton.doClick(AbstractButton.java:357)
           at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1225)
           at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1266)
           at java.awt.Component.processMouseEvent(Component.java:6134)
           at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
           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:3965)
           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(EventDispatchThread.java:269)
           at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
           at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.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)


      the Log bar (from View) alternates between 0 & 3 Error msgs, upon running the sqldeveloper.exe: (currently i see these, but it's random what i'll see next time i open it)
      SEVERE          0          Failed to create addin oracle.dbtools.raptor.timesten.TTAddin
      SEVERE          0          Failed to create addin oracle.dbtools.raptor.report.addin.ReportAddin


      when running from within C:\sqldeveloper\sqldeveloper\bin, here is what the console spits out:

      *************************************************************************
      Exception initializing 'oracle.dbtools.raptor.RaptorDBAddin' in extension 'Oracle SQL Developer': oracle.classloader.util.AnnotatedNoClassDefFoundError:

      Missing class: oracle.i18n.util.OraLocaleInfo

      Dependent class: oracle.dbtools.raptor.config.DBConfig
      Loader: ide-global:11.1.1.0.0
      Code-Source: /C:/sqldeveloper/sqldeveloper/extensions/oracle.sqldeveloper.jar
      Configuration: extension jar in C:\sqldeveloper\sqldeveloper\extensions

      The missing class is not available from any code-source or loader in the system.

      at oracle.classloader.PolicyClassLoader.handleClassNotFound (PolicyClassLoader.java:2180) [C:/sqldeveloper/modules/oracle.classloader_11.1.1.jar (from system property java.class.path), by sun.misc.Launcher$AppClassLoader@32124414]
      at oracle.classloader.PolicyClassLoader.internalLoadClass (PolicyClassLoader.java:1733) [C:/sqldeveloper/modules/oracle.classloader_11.1.1.jar (from system property java.class.path), by sun.misc.Launcher$AppClassLoader@32124414]
      at oracle.classloader.PolicyClassLoader.access$000 (PolicyClassLoader.java:143) [C:/sqldeveloper/modules/oracle.classloader_11.1.1.jar (from system property java.class.path), by sun.misc.Launcher$AppClassLoader@32124414]
      at oracle.classloader.PolicyClassLoader$LoadClassAction.run (PolicyClassLoader.java:331) [C:/sqldeveloper/modules/oracle.classloader_11.1.1.jar (from system property java.class.path), by sun.misc.Launcher$AppClassLoader@32124414]
      at java.security.AccessController.doPrivileged (Native method) [unknown, by unknown]
      at oracle.classloader.PolicyClassLoader.loadClass (PolicyClassLoader.java:1692) [C:/sqldeveloper/modules/oracle.classloader_11.1.1.jar (from system property java.class.path), by sun.misc.Launcher$AppClassLoader@32124414]
      at oracle.classloader.PolicyClassLoader.loadClass (PolicyClassLoader.java:1674) [C:/sqldeveloper/modules/oracle.classloader_11.1.1.jar (from system property java.class.path), by sun.misc.Launcher$AppClassLoader@32124414]
      at java.lang.ClassLoader.loadClassInternal (ClassLoader.java:320) [jre bootstrap, by jre.bootstrap:1.6.0_11]
      at oracle.dbtools.raptor.config.DBConfig.<clinit> (DBConfig.java:322) [C:/sqldeveloper/sqldeveloper/extensions/oracle.sqldeveloper.jar (from extensionjar in C:\sqldeveloper\sqldeveloper\extensions), by ide-global:11.1.1.0.0]
      at oracle.dbtools.raptor.RaptorDBAddin.initialize (RaptorDBAddin.java:126) [C:/sqldeveloper/sqldeveloper/extensions/oracle.sqldeveloper.jar (from extension jar in C:\sqldeveloper\sqldeveloper\extensions), by ide-global:11.1.1.0.0]
      at oracle.ideimpl.extension.AddinManagerImpl.initializeAddin (AddinManagerImpl.java:407) [C:/sqldeveloper/ide/lib/ideimpl.jar (from boot classpath entry in oracle.ide.boot.PCLMain.BOOT_ENTRIES), by ide-global:11.1.1.0.0]
      at oracle.ideimpl.extension.AddinManagerImpl.initializeAddins (AddinManagerImpl.java:214) [C:/sqldeveloper/ide/lib/ideimpl.jar (from boot classpath entry in oracle.ide.boot.PCLMain.BOOT_ENTRIES), by ide-global:11.1.1.0.0]
      at oracle.ideimpl.extension.AddinManagerImpl.initProductAndUserAddins (AddinManagerImpl.java:128) [C:/sqldeveloper/ide/lib/ideimpl.jar (from boot class path entry in oracle.ide.boot.PCLMain.BOOT_ENTRIES), by ide-global:11.1.1.0.0]
      at oracle.ide.IdeCore.initProductAndUserAddins (IdeCore.java:1949) [C:/sqldeveloper/ide/extensions/oracle.ide.jar (from boot classpath entry in oracle.ide.boot.PCLMain.BOOT_ENTRIES), by ide-global:11.1.1.0.0]
      at oracle.ide.IdeCore.startupImpl (IdeCore.java:1573) [C:/sqldeveloper/ide/extensions/oracle.ide.jar (from boot classpath entry in oracle.ide.boot.PCLMain.BOOT_ENTRIES), by ide-global:11.1.1.0.0]
      at oracle.ide.Ide.startup (Ide.java:703) [C:/sqldeveloper/ide/extensions/oracle.ide.jar (from boot classpath entry in oracle.ide.boot.PCLMain.BOOT_ENTRIES), by ide-global:11.1.1.0.0]
      at oracle.ideimpl.DefaultIdeStarter.startIde (DefaultIdeStarter.java:35) [C:/sqldeveloper/ide/lib/ideimpl.jar (from boot classpath entry in oracle.ide.boot.PCLMain.BOOT_ENTRIES), by ide-global:11.1.1.0.0]
      at oracle.ideimpl.Main.start (Main.java:184) [C:/sqldeveloper/ide/lib/ideimpl.jar (from boot classpath entry in oracle.ide.boot.PCLMain.BOOT_ENTRIES), by ide-global:11.1.1.0.0]
      at oracle.ideimpl.Main.main (Main.java:146) [C:/sqldeveloper/ide/lib/ideimpl.jar (from boot classpath entry in oracle.ide.boot.PCLMain.BOOT_ENTRIES), by ide-global:11.1.1.0.0]
      at sun.reflect.NativeMethodAccessorImpl.invoke0 (Native method) [unknown, by unknown]
      at sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:39) [unknown, by unknown]
      at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25) [unknown, by unknown]
      at java.lang.reflect.Method.invoke (Method.java:597) [unknown, by unknown]
      at oracle.ide.boot.PCLMain.callMain (PCLMain.java:62) [C:/sqldeveloper/ide/lib/ide-boot.jar (from <classpath> in /file:/C:/sqldeveloper/ide/extensions/oracle.ide.jar!/META-INF/extension.xml), by sun.misc.Launcher$AppClassLoader@32124414]
      at oracle.ide.boot.PCLMain.main (PCLMain.java:54) [C:/sqldeveloper/ide/lib/ide-boot.jar (from <classpath> in /file:/C:/sqldeveloper/ide/extensions/oracle.ide.jar!/META-INF/extension.xml), by sun.misc.Launcher$AppClassLoader@32124414]
      at sun.reflect.NativeMethodAccessorImpl.invoke0 (Native method) [unknown, by unknown]
      at sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:39) [unknown, by unknown]
      at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25) [unknown, by unknown]
      at java.lang.reflect.Method.invoke (Method.java:597) [unknown, by unknown]
      at oracle.classloader.util.MainClass.invoke (MainClass.java:128) [C:/sqldeveloper/modules/oracle.classloader_11.1.1.jar (from system property java.class.path), by sun.misc.Launcher$AppClassLoader@32124414]
      at oracle.ide.boot.IdeLauncher.bootClassLoadersAndMain (IdeLauncher.java:189) [C:/sqldeveloper/ide/lib/ide-boot.jar (from <classpath> in /file:/C:/sqldeveloper/ide/extensions/oracle.ide.jar!/META-INF/extension.xml), by sun.misc.Launcher$AppClassLoader@32124414]
      at oracle.ide.boot.IdeLauncher.launchImpl (IdeLauncher.java:89) [C:/sqldeveloper/ide/lib/ide-boot.jar (from <classpath> in /file:/C:/sqldeveloper/ide/extensions/oracle.ide.jar!/META-INF/extension.xml), by sun.misc.Launcher$AppClassLoader@32124414]
      at oracle.ide.boot.IdeLauncher.launch (IdeLauncher.java:65) [C:/sqldeveloper/ide/lib/ide-boot.jar (from <classpath> in /file:/C:/sqldeveloper/ide/extensions/oracle.ide.jar!/META-INF/extension.xml), by sun.misc.Launcher$AppClassLoader@32124414]
      at oracle.ide.boot.IdeLauncher.main (IdeLauncher.java:54) [C:/sqldeveloper/ide/lib/ide-boot.jar (from <classpath> in /file:/C:/sqldeveloper/ide/extensions/oracle.ide.jar!/META-INF/extension.xml), by sun.misc.Launcher$AppClassLoader@32124414]
      at sun.reflect.NativeMethodAccessorImpl.invoke0 (Native method) [unknown, by unknown]
      at sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:39) [unknown, by unknown]
      at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25) [unknown, by unknown]
      at java.lang.reflect.Method.invoke (Method.java:597) [unknown, by unknown]
      at oracle.ide.boot.Launcher.invokeMain (Launcher.java:713) [C:/sqldeveloper/ide/lib/ide-boot.jar (from <classpath> in /file:/C:/sqldeveloper/ide/extensions/oracle.ide.jar!/META-INF/extension.xml), by sun.misc.Launcher$AppClassLoader@32124414]
      at oracle.ide.boot.Launcher.launchImpl (Launcher.java:115) [C:/sqldeveloper/ide/lib/ide-boot.jar (from <classpath> in /file:/C:/sqldeveloper/ide/extensions/oracle.ide.jar!/META-INF/extension.xml), by sun.misc.Launcher$AppClassLoader@32124414]
      at oracle.ide.boot.Launcher.launch (Launcher.java:68) [C:/sqldeveloper/ide/lib/ide-boot.jar (from <classpath> in /file:/C:/sqldeveloper/ide/extensions/oracle.ide.jar!/META-INF/extension.xml), by sun.misc.Launcher$AppClassLoader@32124414]
      at oracle.ide.boot.Launcher.main (Launcher.java:57) [C:/sqldeveloper/ide/lib/ide-boot.jar (from <classpath> in /file:/C:/sqldeveloper/ide/extensions/oracle.ide.jar!/META-INF/extension.xml), by sun.misc.Launcher$AppClassLoader@32124414]

      Exception initializing 'oracle.dbtools.raptor.standalone.RaptorStandaloneAddin' in extension 'Oracle SQL Developer Extras': java.lang.NoClassDefFoundError: Could not initialize class oracle.dbtools.raptor.config.DBConfig
      at oracle.dbtools.raptor.utils.URLChooserShortcuts.<clinit>(URLChooserShortcuts.java:35)
      at oracle.dbtools.raptor.standalone.RaptorStandaloneAddin.initialize(RaptorStandaloneAddin.java:178)
      at oracle.ideimpl.extension.AddinManagerImpl.initializeAddin(AddinManagerImpl.java:407)
      at oracle.ideimpl.extension.AddinManagerImpl.initializeAddins(AddinManagerImpl.java:214)
      at oracle.ideimpl.extension.AddinManagerImpl.initProductAndUserAddins(AddinManagerImpl.java:128)
      at oracle.ide.IdeCore.initProductAndUserAddins(IdeCore.java:1949)
      at oracle.ide.IdeCore.startupImpl(IdeCore.java:1573)
      at oracle.ide.Ide.startup(Ide.java:703)
      at oracle.ideimpl.DefaultIdeStarter.startIde(DefaultIdeStarter.java:35)
      at oracle.ideimpl.Main.start(Main.java:184)
      at oracle.ideimpl.Main.main(Main.java:146)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at oracle.ide.boot.PCLMain.callMain(PCLMain.java:62)
      at oracle.ide.boot.PCLMain.main(PCLMain.java:54)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at oracle.classloader.util.MainClass.invoke(MainClass.java:128)
      at oracle.ide.boot.IdeLauncher.bootClassLoadersAndMain(IdeLauncher.java:189)
      at oracle.ide.boot.IdeLauncher.launchImpl(IdeLauncher.java:89)
      at oracle.ide.boot.IdeLauncher.launch(IdeLauncher.java:65)
      at oracle.ide.boot.IdeLauncher.main(IdeLauncher.java:54)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at oracle.ide.boot.Launcher.invokeMain(Launcher.java:713)
      at oracle.ide.boot.Launcher.launchImpl(Launcher.java:115)
      at oracle.ide.boot.Launcher.launch(Launcher.java:68)
      at oracle.ide.boot.Launcher.main(Launcher.java:57)
      Exception in thread "EditorLoader" java.lang.NoClassDefFoundError: Could not initialize class oracle.dbtools.raptor.config.DBConfig
      at oracle.dbtools.raptor.oviewer.base.ViewerAddin.loadXMLEditors(ViewerAddin.java:221)
      at oracle.dbtools.raptor.oviewer.base.ViewerAddin$1$1.run(ViewerAddin.java:130)
      at java.lang.Thread.run(Thread.java:619)
      *************************************************************************************


      i have added the following to my sqldeveloper.conf file:
      AddVMOption -Duser.language=en
      AddVMOption -Duser.region=US

      i've unistalled, reinstalled (in different locations) & updated everything for SQL Developer.
      i've installed & updated my JDK & JRE.
      i've considered installing more of the Oracle GDK, but i was unsure where to install/save it all, so i didn't.

      one thing that seems wrong, but i cannot change, are some paths or values from Help->About->Properties.
      it does seem to be pointing to places that don't exist or have moved, but i don't see where we can edit these paths/values for Properties. nor do i see how this is relevant or not.


      problem 2:

      i cannot access anything under the Database menu tree from Tools->Preferences. the entire window freezes only when trying to access any Database preferences. ( i was trying to get to Database->NLS to change some settings suggested in another forum)



      i've run out of ideas & have wasted too much work time trying to fix it myself.
      help plz!

      thx in advance!

      -M.E.
        • 1. Re: sqldeveloper - java.lang.NullPointerException & Preferences/Database issues
          -K-
          Looking at what the problem seems to be and your attempts, I still see a couple of possibilities.
          If your settings are corrupt as I guess, upgrading to 2.1.1 would automatically take care of that and give you all the recent fixes too.

          Hope that helps,
          K.
          • 2. Re: sqldeveloper - java.lang.NullPointerException & Preferences/Database issues
            770963
            well, i thought when i downloaded a new version of SQL Developer from Oracle.com last week that it was the latest. obviously there's an even newer one, so i got it today. i now have 3 versions, & all 3 show the exact same problems. again no one else on my team who uses the same versions as i've tried are having any of the same issues. i even had a co-worker send me his entire package for me to download & execute, but same thing.

            version 1.5.1
            version 2.1.0.63.73
            version 2.1.1.64.45


            would my latest automatic Java update have anything to do w/ these issues?
            also, as i mentioned in my first thread, some of the paths or Values from Help->About->Properties next to the java related Property Names are incorrect b/c they are either missing or have moved. again, not sure how relevant that is (especially since i can't change/update any of them).

            so still need help!

            thx,
            M.E.
            • 3. Re: sqldeveloper - java.lang.NullPointerException & Preferences/Database issues
              -K-
              If you've downloaded the versions with JDK included, that's the one used, but else make sure you're pointing to a 1.6 JDK in \sqldeveloper\bin\sqldeveloper.conf:
              SetJavaHome C:\Archivos de programa\Java\jdk1.6.0_16
              If you still see wrong or missing values, please elaborate...

              K.
              • 4. Re: sqldeveloper - java.lang.NullPointerException & Preferences/Database issues
                770963
                here is a full copy & paste from my sqldeveloper.conf in v2.1.1:
                -----------------------------------------------------
                IncludeConfFile ../../ide/bin/ide.conf

                SetJavaHome ../../jdk

                AddVMOption -Doracle.ide.util.AddinPolicyUtils.OVERRIDE_FLAG=true

                AddVMOption -Dsun.java2d.ddoffscreen=false

                AddVMOption -Dwindows.shell.font.languages=

                AddVMOption -XX:MaxPermSize=128M


                IncludeConfFile sqldeveloper-nondebug.conf

                AddVMOption -Duser.language=en [this i added]
                AddVMOption -Duser.region=US [this i added]
                -------------------------------------------------------

                since mine doesn't show the same path name as yours, i did some further digging.
                looking at the path for jdk folder (and it's the same for all 3 versions that i've got), i have 2 subfolders: jre & lib.

                under lib i only have 1 file tools.jar, which when opened in a text reader/editor, the 4th line down reads:
                Created-By: 1.6.0_11 (Sun Microsystems Inc.)

                under jre i have 15 files & 2 more subfolders. opening the README.txt, i see:
                Java(TM) Platform, Standard Edition Runtime Environment Version 6



                moving onto the second part of your reply, here are some examples of what i mean as missing or moved values/paths from Help->About->Properties:
                Name: java.version     Value: *1.6.0_11* [i saw this under Properties too, & thought it was relavent to the previous question]

                i started copying other paths/values that i had been metioning as incorrect, but a co-worker stopped by with a printout of his, & they seem to match up on most.
                even if they were incorrect, they are at least consistent. the only one that didn't match up between ours is jdbc.library:
                jdbc.library -     /C:/app/menfinger/product/11.1.0/client_2/jdbc/lib/ojdbc5.jar
                his reads: jdbc.library -     /C:/sqldeveloper/jdbc/lib/ojdbc5.jar

                so it doesn't seem to play that big of an imporatance if mine are similar to everyone else's & they have no problems there.

                -M.E.
                • 5. Re: sqldeveloper - java.lang.NullPointerException & Preferences/Database issues
                  -K-
                  So it's using the JDBC driver from your 11g client instead of it's own.
                  In case there's something wrong with that, you can try to bypass problematic environment settings by changing your ORACLE_HOME within a batch file (inside sqldev's folder):
                  set ORACLE_HOME=%CD%
                  start sqldeveloper.exe
                  Hope that helps,
                  K.
                  1 person found this helpful
                  • 6. Re: sqldeveloper - java.lang.NullPointerException & Preferences/Database issues
                    770963
                    well that seemed to work. i was able to start a new connection w/o error, until my TNS names didn't show up. i don't see how i can use Oracle from within sqldeveloper, b/c i have no way of connecting to my proper TNS names? i'm going to attempt to uninstall all my oracle 10g & 11g & reinstall 11g from scratch. (i've been putting this off because i've not had any problems connecting to any databases with any other software or tool, so it is working.)

                    we're almost there, i think.

                    thx,
                    ME
                    • 7. Re: sqldeveloper - java.lang.NullPointerException & Preferences/Database issues
                      rsrini
                      You can specify the tnsnames directory by going to tools-->preferences, expand Database and click on Advanced option. You would see a form field for TNSNAMES directory. Click on the browse button and select your tnsnames directory.
                      When you select a new connection, select tns from the drop down box and click on Network alias. It will list all the tnsnames found.


                      --rsrini                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
                      • 8. Re: sqldeveloper - java.lang.NullPointerException & Preferences/Database issues
                        770963
                        i cannot access anything under the Database menu tree from Tools->Preferences. the entire window freezes only when trying to access any Database preferences. ( i was trying to get to Database->NLS to change some settings suggested in another forum)

                        so as u can see, i can't change my tnsnames from there.

                        thx,
                        ME
                        • 9. Re: sqldeveloper - java.lang.NullPointerException & Preferences/Database issues
                          770963
                          so i did uninstall EVERYTHING Oracle & reinstalled. and now it works, not sure what happened, but thanks for all your efforts!

                          ME
                          • 10. Re: sqldeveloper - java.lang.NullPointerException & Preferences/Database issues
                            787436
                            Hello

                            I am getting the same errors now, SQLDev used to work correctly but as far as I remember after I installed workflow client it stopped working and the connection window does not come up, if I click on SQL Worksheet it gives following error.

                            java.lang.NullPointerException
                                 at oracle.dbtools.raptor.controls.ConnectionPanelUI.listConnections(ConnectionPanelUI.java:435)
                                 at oracle.dbtools.raptor.controls.ConnectionPanelUI.resetConnections(ConnectionPanelUI.java:448)
                                 at oracle.dbtools.raptor.controls.ConnectionPanelUI.<init>(ConnectionPanelUI.java:123)
                                 at oracle.dbtools.raptor.controls.ConnectionPanelUI.<init>(ConnectionPanelUI.java:101)
                                 at oracle.dbtools.raptor.controls.ConnectionSelectorUI.<init>(ConnectionSelectorUI.java:29)
                                 at oracle.dbtools.raptor.controls.ConnectionSelectorUI.getConnection(ConnectionSelectorUI.java:60)
                                 at oracle.dbtools.raptor.controls.ConnectionSelectorUI.getConnection(ConnectionSelectorUI.java:37)
                                 at oracle.dbtools.worksheet.editor.OpenWorksheetWizard.invoke(OpenWorksheetWizard.java:279)
                                 at oracle.ide.wizard.WizardManager.invokeWizard(WizardManager.java:372)
                                 at oracle.dbtools.worksheet.editor.WorksheetOpenController$1.run(WorksheetOpenController.java:67)
                                 at oracle.dbtools.worksheet.editor.WorksheetOpenController.openWorksheetWizard(WorksheetOpenController.java:73)
                                 at oracle.dbtools.worksheet.editor.WorksheetOpenController.handleEvent(WorksheetOpenController.java:34)
                                 at oracle.ideimpl.controller.IdeActionHook$MetaClassController.handleEvent(IdeActionHook.java:414)
                                 at oracle.ide.controller.IdeAction.performAction(IdeAction.java:531)
                                 at oracle.ide.controller.IdeAction.actionPerformedImpl(IdeAction.java:886)
                                 at oracle.ide.controller.IdeAction.actionPerformed(IdeAction.java:503)
                                 at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
                                 at oracle.ide.controls.ActionMenuToolButton.access$400(ActionMenuToolButton.java:82)
                                 at oracle.ide.controls.ActionMenuToolButton$FilterActionEvents.actionPerformed(ActionMenuToolButton.java:394)
                                 at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
                                 at javax.swing.JToggleButton$ToggleButtonModel.setPressed(JToggleButton.java:291)
                                 at oracle.ide.controls.ActionMenuToolButton$2.setPressed(ActionMenuToolButton.java:223)
                                 at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
                                 at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:273)
                                 at java.awt.Component.processMouseEvent(Component.java:6134)
                                 at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
                                 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:3965)
                                 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(EventDispatchThread.java:269)
                                 at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
                                 at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.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)


                            I removed all Oracle tools including the registry and tried it does not work. Also tried setting path to none on command prompt and starting the SQLDev from there. That also does not work.
                            Tried setting the path for java in the conf file but without success.

                            Downloaded the latest version and tried.

                            Please help to resolve this..

                            Thanks
                            Sanjeev
                            • 12. Re: sqldeveloper - java.lang.NullPointerException & Preferences/Database issues
                              787436
                              Just now tried to use batch file.

                              It still gives the same error. I checked the oracle home on the same command prompt. is shows the d:\sqldeveloper. so the batch file has worked.

                              One update however earlier I had removed all the other oracle programs, but i had to install them to keep the work continuing.

                              Now using the trial TOAD version and SQL Tools. but I want to go back to SQL Developer once it is fixed on my machine.


                              -Sanjeev