Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error when exporting dataset

stomApr 20 2022

Version 21.4.3.063 and 21.4.2.018
OS version: Windows 10
Oracle DB: 12.2 on OEL 6
Run a query, right click on the result in the data grid, select "Export"

image.png

java.lang.reflect.InvocationTargetException
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	at oracle.ide.panels.MetaTraversable.newTraversable(MetaTraversable.java:315)
	at oracle.ide.wizard.Step.newTraversable(Step.java:171)
	at oracle.ide.wizard.FSMStateInfo.getTraversable(FSMStateInfo.java:99)
	at oracle.ide.wizard.FSMWizard._addPage(FSMWizard.java:579)
	at oracle.ide.wizard.FSMWizard._populatePages(FSMWizard.java:533)
	at oracle.ide.wizard.FSMWizard.<init>(FSMWizard.java:120)
	at oracle.dbtools.raptor.export.wizard.ExportWizMain.launchWizard(ExportWizMain.java:226)
	at oracle.dbtools.raptor.export.wizard.ExportWizMain.launchForGrid(ExportWizMain.java:204)
	at oracle.dbtools.raptor.dialogs.actions.TableExportAction.launchForGrid(TableExportAction.java:75)
	at oracle.dbtools.raptor.controls.grid.contextmenu.ExportGrid$1.actionPerformed(ExportGrid.java:159)
	at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)
	at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348)
	at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
	at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
	at javax.swing.AbstractButton.doClick(AbstractButton.java:376)
	at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:842)
	at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:886)
	at java.awt.Component.processMouseEvent(Component.java:6539)
	at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
	at java.awt.Component.processEvent(Component.java:6304)
	at java.awt.Container.processEvent(Container.java:2239)
	at java.awt.Component.dispatchEventImpl(Component.java:4889)
	at java.awt.Container.dispatchEventImpl(Container.java:2297)
	at java.awt.Component.dispatchEvent(Component.java:4711)
	at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4904)
	at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4535)
	at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4476)
	at java.awt.Container.dispatchEventImpl(Container.java:2283)
	at java.awt.Window.dispatchEventImpl(Window.java:2746)
	at java.awt.Component.dispatchEvent(Component.java:4711)
	at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:760)
	at java.awt.EventQueue.access$500(EventQueue.java:97)
	at java.awt.EventQueue$3.run(EventQueue.java:709)
	at java.awt.EventQueue$3.run(EventQueue.java:703)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74)
	at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:84)
	at java.awt.EventQueue$4.run(EventQueue.java:733)
	at java.awt.EventQueue$4.run(EventQueue.java:731)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74)
	at java.awt.EventQueue.dispatchEvent(EventQueue.java:730)
	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:205)
	at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
	at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
Caused by: java.lang.ClassCastException: java.lang.String cannot be cast to oracle.javatools.data.ListStructure
	at oracle.javatools.data.HashStructure.getListStructure(HashStructure.java:1070)
	at oracle.javatools.data.HashStructure.getOrCreateListStructure(HashStructure.java:1084)
	at oracle.dbtools.raptor.config.URLFileChooserPaths$URLFileChooserPathContext.getURLList(URLFileChooserPaths.java:250)
	at oracle.dbtools.raptor.config.URLFileChooserPaths$URLFileChooserPathContext.getURLPath(URLFileChooserPaths.java:191)
	at oracle.dbtools.raptor.ui.URLFileChooser.getPathContextPaths(URLFileChooser.java:1601)
	at oracle.dbtools.raptor.ui.URLFileChooser.setCurrentDirectoryFromPathContext(URLFileChooser.java:1542)
	at oracle.dbtools.raptor.ui.URLFileChooser.setPathContext(URLFileChooser.java:1528)
	at oracle.dbtools.raptor.ui.URLFileChooser$URLFileChooserPanel.setPathContext(URLFileChooser.java:1341)
	at oracle.dbtools.raptor.export.wizard.TargetOptionsPanel.initFilePanel(TargetOptionsPanel.java:277)
	at oracle.dbtools.raptor.export.wizard.TargetOptionsPanel.<init>(TargetOptionsPanel.java:63)
	at oracle.dbtools.raptor.export.wizard.TargetOptionsPanel.<init>(TargetOptionsPanel.java:55)
	at oracle.dbtools.raptor.export.wizard.ExportWizDestinstaionPanel.<init>(ExportWizDestinstaionPanel.java:96)
	... 54 more
java.lang.ClassCastException: java.lang.String cannot be cast to oracle.javatools.data.ListStructure
	at oracle.javatools.data.HashStructure.getListStructure(HashStructure.java:1070)
	at oracle.javatools.data.HashStructure.getOrCreateListStructure(HashStructure.java:1084)
	at oracle.dbtools.raptor.config.URLFileChooserPaths$URLFileChooserPathContext.getURLList(URLFileChooserPaths.java:250)
	at oracle.dbtools.raptor.config.URLFileChooserPaths$URLFileChooserPathContext.getURLPath(URLFileChooserPaths.java:191)
	at oracle.dbtools.raptor.ui.URLFileChooser.getPathContextPaths(URLFileChooser.java:1601)
	at oracle.dbtools.raptor.ui.URLFileChooser.setCurrentDirectoryFromPathContext(URLFileChooser.java:1542)
	at oracle.dbtools.raptor.ui.URLFileChooser.setPathContext(URLFileChooser.java:1528)
	at oracle.dbtools.raptor.ui.URLFileChooser$URLFileChooserPanel.setPathContext(URLFileChooser.java:1341)
	at oracle.dbtools.raptor.export.wizard.TargetOptionsPanel.initFilePanel(TargetOptionsPanel.java:277)
	at oracle.dbtools.raptor.export.wizard.TargetOptionsPanel.<init>(TargetOptionsPanel.java:63)
	at oracle.dbtools.raptor.export.wizard.TargetOptionsPanel.<init>(TargetOptionsPanel.java:55)
	at oracle.dbtools.raptor.export.wizard.ExportWizDestinstaionPanel.<init>(ExportWizDestinstaionPanel.java:96)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	at oracle.ide.panels.MetaTraversable.newTraversable(MetaTraversable.java:315)
	at oracle.ide.wizard.Step.newTraversable(Step.java:171)
	at oracle.ide.wizard.FSMStateInfo.getTraversable(FSMStateInfo.java:99)
	at oracle.ide.wizard.FSMWizard._addPage(FSMWizard.java:579)
	at oracle.ide.wizard.FSMWizard._populatePages(FSMWizard.java:533)
	at oracle.ide.wizard.FSMWizard.<init>(FSMWizard.java:120)
	at oracle.dbtools.raptor.export.wizard.ExportWizMain.launchWizard(ExportWizMain.java:226)
	at oracle.dbtools.raptor.export.wizard.ExportWizMain.launchForGrid(ExportWizMain.java:204)
	at oracle.dbtools.raptor.dialogs.actions.TableExportAction.launchForGrid(TableExportAction.java:75)
	at oracle.dbtools.raptor.controls.grid.contextmenu.ExportGrid$1.actionPerformed(ExportGrid.java:159)
	at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)
	at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348)
	at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
	at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
	at javax.swing.AbstractButton.doClick(AbstractButton.java:376)
	at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:842)
	at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:886)
	at java.awt.Component.processMouseEvent(Component.java:6539)
	at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
	at java.awt.Component.processEvent(Component.java:6304)
	at java.awt.Container.processEvent(Container.java:2239)
	at java.awt.Component.dispatchEventImpl(Component.java:4889)
	at java.awt.Container.dispatchEventImpl(Container.java:2297)
	at java.awt.Component.dispatchEvent(Component.java:4711)
	at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4904)
	at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4535)
	at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4476)
	at java.awt.Container.dispatchEventImpl(Container.java:2283)
	at java.awt.Window.dispatchEventImpl(Window.java:2746)
	at java.awt.Component.dispatchEvent(Component.java:4711)
	at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:760)
	at java.awt.EventQueue.access$500(EventQueue.java:97)
	at java.awt.EventQueue$3.run(EventQueue.java:709)
	at java.awt.EventQueue$3.run(EventQueue.java:703)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74)
	at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:84)
	at java.awt.EventQueue$4.run(EventQueue.java:733)
	at java.awt.EventQueue$4.run(EventQueue.java:731)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74)
	at java.awt.EventQueue.dispatchEvent(EventQueue.java:730)
	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:205)
	at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
	at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
This post has been answered by thatJeffSmith-Oracle on Apr 21 2022
Jump to Answer
Comments
Post Details
Added on Apr 20 2022
6 comments
393 views