0 Replies Latest reply on Sep 17, 2013 4:03 PM by Raj Jamadagni

    4EA2: Error when saving file while closing connection

    Raj Jamadagni

      After opening a connection, I wrote some SQL, run it and then click disconnect, SQLDEV asks if it should save file, when I click Yes, I get following error. Any idea on how to resolve it? Remember it is trying to save the file, also another thing I noticed that the file it wanted to save (file name automatically generated) was C:\Users\rjamadag\AppData\Local\Temp\worksheet215601548428791866.sql.sql.

      For the curious, the directory C:\Users\rjamadag\AppData\Local\Temp does exist and has boatloads of other  files.

       

      java.io.FileNotFoundException: C:\Users\rjamadag\AppData\Local\Temp\worksheet215601548428791866.sql (The system cannot find the file specified)
        at java.io.FileInputStream.open(Native Method)
        at java.io.FileInputStream.<init>(FileInputStream.java:146)
        at oracle.ide.net.FileURLFileSystemHelper.openInputStream(FileURLFileSystemHelper.java:764)
        at oracle.ide.net.URLFileSystemHelperDecorator.openInputStream(URLFileSystemHelperDecorator.java:291)
        at oracle.ideimpl.net.LazyURLFileSystemHelperDecorator.openInputStream(LazyURLFileSystemHelperDecorator.java:364)
        at oracle.ide.net.URLFileSystemHelperDecorator.openInputStream(URLFileSystemHelperDecorator.java:291)
        at oracle.ide.net.URLFileSystem.openInputStream(URLFileSystem.java:1368)
        at oracle.ide.net.IdeURLFileSystemHelper.openInputStream(IdeURLFileSystemHelper.java:360)
        at oracle.ideimpl.net.LazyURLFileSystemHelper.openInputStream(LazyURLFileSystemHelper.java:303)
        at oracle.ide.net.URLFileSystem.openInputStream(URLFileSystem.java:1368)
        at oracle.ide.net.URLFileSystem.copy(URLFileSystem.java:384)
        at oracle.dbtools.worksheet.editor.OpenWorksheetWizard$NL$3.run(OpenWorksheetWizard.java:158)
        at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:251)
        at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:733)
        at java.awt.EventQueue.access$200(EventQueue.java:103)
        at java.awt.EventQueue$3.run(EventQueue.java:694)
        at java.awt.EventQueue$3.run(EventQueue.java:692)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:703)
        at oracle.javatools.internal.ui.EventQueueWrapper._dispatchEvent(EventQueueWrapper.java:169)
        at oracle.javatools.internal.ui.EventQueueWrapper.dispatchEvent(EventQueueWrapper.java:151)
        at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)
        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)
        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:146)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138)
        at java.awt.EventDispatchThread.run(EventDispatchThread.java:91)
      

       

      Thanks in advance for your ideas.