5 Replies Latest reply: Jun 11, 2012 8:37 PM by konstantin.gudjev RSS

    Can't open sql file in subfolders.

    konstantin.gudjev
      Hi,

      1. I can’t open any file by Windows Browser, right click, and open with SQL Developer if the file is located in subfolder which is several levels deep from C:\.
      2. I can’t use Files (from SQL Developer) to browse subfolders than 7 or 8 levels deep from C:\.

      In the first case SQL Developer starts (if not running) without to open the file. If the sql file is located in first 3, 4 levels of sub folders – works.
      In the second case it just stopped working. In the panel (Files) Loading … appears and nothing.

      I change Tools/Preferences/Navigation level from 20 to 50 – same!

      Windows 7 Enterprise 8 GB
      SQL Developer Version 3.1.07 Build MAIN-07.42
      JDK 1.6

      Moreover SQL Developer uses 700 MB memory. It was 200 - 300 MB on Windows XP.

      If somebody has similar experience - please help?

      Konstantin
        • 1. Re: Can't open sql file in subfolders.
          Gary Graham-Oracle
          Hi Konstantin,

          Do any of the scenarios discussed in the following thread look familiar?
          3.1EA1 File browser bug?

          The use of Subversion, unusual characters in the file or directory names? And if you can get a thread dump like this...
          1) Open a command prompt window. Be sure its property for screen buffer height is large, at least 500 lines.
          2) Change directory to ...\sqldeveloper\sqldeveloper\bin
          3) Run sqldeveloper.exe
          4) When the File viewer hangs, return to the command prompt window and do a Ctrl-Break
          Does that confirm any OutOfMemory or Subversion problems?

          Hope this helps,
          Gary
          SQL Developer Team
          • 2. Re: Can't open sql file in subfolders.
            konstantin.gudjev
            Hi Gary,

            Gives error of the very beginning.

            I have one sqldeveloper.exe in C:\sqldeveloper folder and one in C:\sqldeveloper\sqldeveloper\bin.
            Both give same error and problem.

            Should I run sqldeveloper as administrator? It is Windows 7. It doesn't mater on Windows XP.

            I will check the tread and send you the error log from dos prompt execution from home.

            If you can help me to solve that problem I will appreciate that. SQLDeveloper is so important to me!

            Konstantin
            • 3. Re: Can't open sql file in subfolders.
              konstantin.gudjev
              Hi Gary,

              I am sending the log without CTRL-Break. The problem is same as the another thread.

              This is the error of the very beginning.

              C:\sqldeveloper\sqldeveloper\bin>sqldeveloper.exe
              _execv() failed, err=2Registered TimesTen

              These are errors before the SQLDeveloper to stop.

              Exception in thread "IconOverlayTracker Timer" java.lang.OutOfMemoryError: Java
              heap space
              at java.util.Arrays.copyOf(Arrays.java:2882)
              at java.lang.AbstractStringBuilder.expandCapacity(AbstractStringBuilder.
              java:100)
              at java.lang.AbstractStringBuilder.append(AbstractStringBuilder.java:390
              )
              at java.lang.StringBuffer.append(StringBuffer.java:224)
              at org.tmatesoft.svn.core.SVNErrorMessage.getFullMessage(SVNErrorMessage
              .java:257)
              at org.tmatesoft.svn.core.internal.wc.SVNErrorManager.error(SVNErrorMana
              ger.java:58)
              at org.tmatesoft.svn.core.internal.wc.admin.SVNAdminAreaFactory.open(SVN
              AdminAreaFactory.java:163)
              at org.tmatesoft.svn.core.internal.wc.admin.SVNWCAccess.doOpen(SVNWCAcce
              ss.java:364)
              at org.tmatesoft.svn.core.internal.wc.admin.SVNWCAccess.open(SVNWCAccess
              .java:272)
              at org.tmatesoft.svn.core.internal.wc.admin.SVNWCAccess.open(SVNWCAccess
              .java:265)
              at org.tmatesoft.svn.core.internal.wc.admin.SVNWCAccess.open(SVNWCAccess
              .java:261)
              at org.tmatesoft.svn.core.wc.SVNStatusClient.doStatus(SVNStatusClient.ja
              va:316)
              at org.tmatesoft.svn.core.javahl.SVNClientImpl.status(SVNClientImpl.java
              :296)
              at org.tmatesoft.svn.core.javahl.SVNClientImpl.status(SVNClientImpl.java
              :278)
              at org.tigris.subversion.svnclientadapter.javahl.AbstractJhlClientAdapte
              r.getStatus(AbstractJhlClientAdapter.java:480)
              at org.tigris.subversion.svnclientadapter.svnkit.SvnKitClientAdapter.get
              Status(SvnKitClientAdapter.java:141)
              at org.tigris.subversion.svnclientadapter.javahl.AbstractJhlClientAdapte
              r.getStatus(AbstractJhlClientAdapter.java:466)
              at oracle.jdevimpl.vcs.svn.SVNURLInfoCacheSimpleStrategy.getURLInfo(SVNU
              RLInfoCacheSimpleStrategy.java:79)
              at oracle.jdevimpl.vcs.svn.SVNURLInfoCache.getPropStatus(SVNURLInfoCache
              .java:59)
              at oracle.jdevimpl.vcs.svn.SVNStatusResolver.getStatus(SVNStatusResolver
              .java:159)
              at oracle.jdevimpl.vcs.svn.SVNStatusResolver.populateStatuses(SVNStatusR
              esolver.java:82)
              at oracle.jdevimpl.vcs.generic.GenericClient$2.getImpl(GenericClient.jav
              a:531)
              at oracle.jdeveloper.vcs.spi.VCSStatusCache.getValuesImpl(VCSStatusCache
              .java:31)
              at oracle.jdeveloper.vcs.spi.VCSURLBasedCache.getValues(VCSURLBasedCache
              .java:107)
              at oracle.jdeveloper.vcs.spi.VCSStatusCache.get(VCSStatusCache.java:63)
              at oracle.jdeveloper.vcs.spi.VCSOverlayItemProducer.getOverlayItems(VCSO
              verlayItemProducer.java:63)
              at oracle.jdeveloper.vcs.spi.VCSNodeOverlayTracker.getOverlays(VCSNodeOv
              erlayTracker.java:288)
              at oracle.ide.explorer.IconOverlayTracker.processPendingNodes(IconOverla
              yTracker.java:574)
              at oracle.ide.explorer.IconOverlayTracker.access$1400(IconOverlayTracker
              .java:69)
              at oracle.ide.explorer.IconOverlayTracker$7.run(IconOverlayTracker.java:
              487)
              at java.util.TimerThread.mainLoop(Timer.java:512)
              at java.util.TimerThread.run(Timer.java:462)

              This is the error log after the "Loading...".

              Exception in thread "AWT-EventQueue-0" java.lang.IllegalStateException: Timer al
              ready cancelled.
              at java.util.Timer.sched(Timer.java:354)
              at java.util.Timer.schedule(Timer.java:170)
              at oracle.ide.explorer.IconOverlayTracker$NodeWatcher.updateVisibleNodes
              (IconOverlayTracker.java:802)
              at oracle.ide.explorer.IconOverlayTracker$NodeWatcher.access$3000(IconOv
              erlayTracker.java:713)
              at oracle.ide.explorer.IconOverlayTracker$NodeWatcher$NodeUserListener.t
              reeExpanded(IconOverlayTracker.java:969)
              at javax.swing.JTree.fireTreeExpanded(JTree.java:2666)
              at javax.swing.JTree.setExpandedState(JTree.java:3427)
              at javax.swing.JTree.expandPath(JTree.java:2163)
              at javax.swing.plaf.basic.BasicTreeUI.toggleExpandState(BasicTreeUI.java
              :2204)
              at javax.swing.plaf.basic.BasicTreeUI.handleExpandControlClick(BasicTree
              UI.java:2191)
              at javax.swing.plaf.basic.BasicTreeUI.checkForClickInExpandControl(Basic
              TreeUI.java:2149)
              at com.jgoodies.looks.plastic.PlasticTreeUI.access$900(PlasticTreeUI.jav
              a:120)
              at com.jgoodies.looks.plastic.PlasticTreeUI$MouseHandler.mousePressed(Pl
              asticTreeUI.java:276)
              at java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:26
              2)
              at java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:26
              2)
              at java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:26
              2)
              at java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:26
              2)
              at java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:26
              2)
              at java.awt.Component.processMouseEvent(Component.java:6287)
              at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
              at oracle.ideimpl.explorer.CustomTree.processMouseEvent(CustomTree.java:
              220)
              at java.awt.Component.processEvent(Component.java:6055)
              at java.awt.Container.processEvent(Container.java:2039)
              at java.awt.Component.dispatchEventImpl(Component.java:4653)
              at java.awt.Container.dispatchEventImpl(Container.java:2097)
              at java.awt.Component.dispatchEvent(Component.java:4481)
              at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4575
              )
              at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4233)

              at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4166)
              at java.awt.Container.dispatchEventImpl(Container.java:2083)
              at java.awt.Window.dispatchEventImpl(Window.java:2482)
              at java.awt.Component.dispatchEvent(Component.java:4481)
              at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:648)
              at java.awt.EventQueue.access$000(EventQueue.java:84)
              at java.awt.EventQueue$1.run(EventQueue.java:607)
              at java.awt.EventQueue$1.run(EventQueue.java:605)
              at java.security.AccessController.doPrivileged(Native Method)
              at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessCo
              ntrolContext.java:87)
              at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessCo
              ntrolContext.java:98)
              at java.awt.EventQueue$2.run(EventQueue.java:621)
              at java.awt.EventQueue$2.run(EventQueue.java:619)
              at java.security.AccessController.doPrivileged(Native Method)
              at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessCo
              ntrolContext.java:87)
              at java.awt.EventQueue.dispatchEvent(EventQueue.java:618)
              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)
              java.lang.IllegalStateException: Timer already cancelled.
              at java.util.Timer.sched(Timer.java:354)
              at java.util.Timer.schedule(Timer.java:170)
              at oracle.ide.explorer.IconOverlayTracker._scheduleUpdateTask(IconOverla
              yTracker.java:498)
              at oracle.ide.explorer.IconOverlayTracker.scheduleUpdateTask(IconOverlay
              Tracker.java:449)
              at oracle.ide.explorer.IconOverlayTracker.repaintConsumerOverlays(IconOv
              erlayTracker.java:432)
              at oracle.ide.explorer.IconOverlayTracker.access$000(IconOverlayTracker.
              java:69)
              at oracle.ide.explorer.IconOverlayTracker$2.stateChanged(IconOverlayTrac
              ker.java:114)
              at oracle.ide.explorer.IconOverlayTracker$NodeWatcher.setVisibleNodes(Ic
              onOverlayTracker.java:843)
              at oracle.ide.explorer.IconOverlayTracker$NodeWatcher.access$2800(IconOv
              erlayTracker.java:713)
              at oracle.ide.explorer.IconOverlayTracker$NodeWatcher$4.run(IconOverlayT
              racker.java:818)
              at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
              at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:646)
              at java.awt.EventQueue.access$000(EventQueue.java:84)
              at java.awt.EventQueue$1.run(EventQueue.java:607)
              at java.awt.EventQueue$1.run(EventQueue.java:605)
              at java.security.AccessController.doPrivileged(Native Method)
              at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessCo
              ntrolContext.java:87)
              at java.awt.EventQueue.dispatchEvent(EventQueue.java:616)
              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)
              • 4. Re: Can't open sql file in subfolders.
                Gary Graham-Oracle
                Hi Konstantin,

                If you read toward the bottom of the thread I referenced above, you will see some comments about how SQL Developer uses JDeveloper's IDE framework and how others have had seen compatibility issues between JDev and TortoiseSVN. Here is a thread about the same on the JDeveloper and ADF forum:
                jDeveloper launch error

                So I recommend reading through that first, then verifying which SVN client (and version) you use outside of SQL Developer. You probably will have to downgrade the SVN client. See, for example, here:
                Jdeveloper Crashed - Previously reported error [IllegalStateException...

                Regards,
                Gary
                • 5. Re: Can't open sql file in subfolders.
                  konstantin.gudjev
                  Hi Gary,

                  1. Unchecked boxes provided solution only for browsing files from tab Files, but not file opening.
                  2. More memory for JVM didn't work.

                  3. Versioning then Configure ... and uncheck Versioning Support for Subversion 11.1.1.4....

                  That solved the problems!
                  If you use SVN Subversion/TortoiseSVN you don't need Subversion support from SQL Developer.

                  Functionality to compare two files is still there.

                  Konstantin

                  Edited by: konstantin.gudjev on Jun 12, 2012 3:37 AM