|
From: Gerd W. <ger...@t-...> - 2014-09-10 19:49:20
|
Hi Stepan and Jef, please have a look at the snapshot here: https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20140910_2140/ and let me know if the bug is fixed. Thanks Gerd Am 10.09.2014 um 09:06 schrieb Stepan RYBAR: > 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= > > > > ------------------------------------------------------------------------------ > 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 > |
