|
From: Stepan R. <xr...@se...> - 2014-09-10 07:19:01
|
Hello, Jef, I have the same problem for years. But I have a workaround. Try to run sql select again, then NOT TO LEFT MOUSE CLICK ANYWHERE INTO RESULT SET TABLE and right mouse click for export procedure. You simply get info, if the export is successful, if You get popup window that "Export of ... rows to file ... is complete." I Regarding the error: Once You click into ResultSet table, and then export to MS Excel, You can see the error in SQuirreL event log pasted below. I think, that the problem occurs, if the ResultSet table contains (C)LOB column with nulls and before export You click into null cell of (C)LOB column. At least this is the way, how can I reproduce the error anytime. Stepan 2014-09-10 08:55:35,121 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.client.Main - Exception occured dispatching Event java.awt.event.MouseEvent[MOUSE_RELEASED,(70,188),absolute(939,865),button=1,modifiers=Button1,clickCount=1] on win0 java.lang.NullPointerException at net.sourceforge.squirrel_sql.fw.gui.action.TableExportCsvCommand.checkMissingData(TableExportCsvCommand.java:58) at net.sourceforge.squirrel_sql.fw.gui.action.AbstractExportCommand.execute(AbstractExportCommand.java:190) at net.sourceforge.squirrel_sql.fw.gui.TablePopupMenu$ExportCsvAction.actionPerformed(TablePopupMenu.java:397) at javax.swing.AbstractButton.fireActionPerformed(Unknown Source) at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.setPressed(Unknown Source) at javax.swing.AbstractButton.doClick(Unknown Source) at javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source) at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown Source) at java.awt.Component.processMouseEvent(Unknown Source) at javax.swing.JComponent.processMouseEvent(Unknown Source) at java.awt.Component.processEvent(Unknown Source) at java.awt.Container.processEvent(Unknown Source) at java.awt.Component.dispatchEventImpl(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Window.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.EventQueue.dispatchEventImpl(Unknown Source) at java.awt.EventQueue.access$400(Unknown Source) at java.awt.EventQueue$3.run(Unknown Source) at java.awt.EventQueue$3.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source) at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source) at java.awt.EventQueue$4.run(Unknown Source) at java.awt.EventQueue$4.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:99) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) ---------- Původní zpráva ---------- Od: Seyen, Jef Komu: squ...@li... Datum: 10. 9. 2014 3:54:32 Předmět: [Squirrel-sql-users] problem with export of result of squirrel I have a problem with export of a small result I am using version 3.5.3 Only 74 rows are in result (so not big file) When i export with paramaters like shown , i dont get any result Jef Seyen Applicatiebeheerder ESF-Agentschap Vlaanderen vzw Gasthuisstraat 31 1000 Brussel Tel: 02/5462247 Fax:02/546 22 40 ------------------------------------------------------------------------------ Want excitement? Manually upgrade your production database. When you want reliability, choose Perforce Perforce version control. Predictably reliable. http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk_______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
