This discussion is archived
5 Replies Latest reply: Jun 11, 2012 6:37 PM by konstantin.gudjev RSS

Can't open sql file in subfolders.

konstantin.gudjev Newbie
Currently Being Moderated
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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points