Recent changes to 1532: Export to XLSX broken?

#1532 Export to XLSX broken?

2024-12-20T08:53:40.649000Z

Thanks Gerd, I can export to XLSX again using the latest snapshot!

#1532 Export to XLSX broken?

2024-12-19T20:01:54.966000Z

Sorry, Vikaash, like Stepan I cannot reproduce your problem. But your error message points to a possible fix.
Could you please try out the latest snapshot available here
https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20241219_2026/
or here
https://github.com/squirrel-sql-client/squirrel-sql-snapshot-releases/releases/tag/snapshot-20241219_2026
and let me know if it fixes your problem or al least changes the error message?

#1532 Export to XLSX broken?

2024-12-18T11:40:31.749000Z

Hi Stepan,

I was wondering if clicking on OK in the dialog having XLSX selected would trigger an error in the log and it did! Hopefully devs can decipher it and diagnose what's going on.

Logged by net.sourceforge.squirrel_sql.client.Main at 18-12-2024, 10:59:

 Exception occurred dispatching Event java.awt.event.MouseEvent[MOUSE_RELEASED,(124,486),absolute(2726,842),button=1,modifiers=Button1,clickCount=1] on win0

Clicked on the stack trace button:

java.lang.NoSuchMethodError: 'org.apache.logging.log4j.LogBuilder org.apache.logging.log4j.LogBuilder.withThrowable(java.lang.Throwable)'
    at org.apache.poi.util.XMLHelper.logThrowable(XMLHelper.java:331)
    at org.apache.poi.util.XMLHelper.trySet(XMLHelper.java:288)
    at org.apache.poi.util.XMLHelper.getDocumentBuilderFactory(XMLHelper.java:116)
    at org.apache.poi.util.XMLHelper.<clinit>(XMLHelper.java:85)
    at org.apache.poi.ooxml.util.DocumentHelper.newDocumentBuilder(DocumentHelper.java:47)
    at org.apache.poi.ooxml.util.DocumentHelper.<clinit>(DocumentHelper.java:36)
    at org.apache.poi.openxml4j.opc.internal.ContentTypeManager.save(ContentTypeManager.java:429)
    at org.apache.poi.openxml4j.opc.ZipPackage.saveImpl(ZipPackage.java:569)
    at org.apache.poi.openxml4j.opc.OPCPackage.save(OPCPackage.java:1531)
    at org.apache.poi.ooxml.POIXMLDocument.write(POIXMLDocument.java:227)
    at net.sourceforge.squirrel_sql.fw.gui.action.fileexport.DataExportExcelWriter.afterWorking(DataExportExcelWriter.java:322)
    at net.sourceforge.squirrel_sql.fw.gui.action.fileexport.DataExportExcelWriter.write(DataExportExcelWriter.java:98)
    at net.sourceforge.squirrel_sql.fw.gui.action.fileexport.ExportFileWriter.export(ExportFileWriter.java:52)
    at net.sourceforge.squirrel_sql.fw.gui.action.fileexport.Exporter.writeExport(Exporter.java:203)
    at net.sourceforge.squirrel_sql.fw.gui.action.fileexport.Exporter.export(Exporter.java:132)
    at net.sourceforge.squirrel_sql.fw.gui.action.fileexport.Exporter.exportDialogClosed(Exporter.java:99)
    at net.sourceforge.squirrel_sql.fw.gui.action.fileexport.Exporter.export(Exporter.java:76)
    at net.sourceforge.squirrel_sql.fw.gui.action.fileexport.TableExport.export(TableExport.java:27)
    at net.sourceforge.squirrel_sql.fw.gui.TablePopupMenu$ExportAction.actionPerformed(TablePopupMenu.java:495)
    at java.desktop/javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1972)
    at java.desktop/javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2314)
    at java.desktop/javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:407)
    at java.desktop/javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:262)
    at java.desktop/javax.swing.AbstractButton.doClick(AbstractButton.java:374)
    at java.desktop/javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1029)
    at java.desktop/javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1073)
    at java.desktop/java.awt.Component.processMouseEvent(Component.java:6621)
    at java.desktop/javax.swing.JComponent.processMouseEvent(JComponent.java:3404)
    at java.desktop/java.awt.Component.processEvent(Component.java:6386)
    at java.desktop/java.awt.Container.processEvent(Container.java:2266)
    at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:4996)
    at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2324)
    at java.desktop/java.awt.Component.dispatchEvent(Component.java:4828)
    at java.desktop/java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4948)
    at java.desktop/java.awt.LightweightDispatcher.processMouseEvent(Container.java:4575)
    at java.desktop/java.awt.LightweightDispatcher.dispatchEvent(Container.java:4516)
    at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2310)
    at java.desktop/java.awt.Window.dispatchEventImpl(Window.java:2780)
    at java.desktop/java.awt.Component.dispatchEvent(Component.java:4828)
    at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:775)
    at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:720)
    at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:714)
    at java.base/java.security.AccessController.doPrivileged(AccessController.java:400)
    at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:87)
    at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:98)
    at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:747)
    at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:745)
    at java.base/java.security.AccessController.doPrivileged(AccessController.java:400)
    at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:87)
    at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:744)
    at net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:101)
    at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203)
    at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124)
    at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113)
    at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109)
    at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
    at java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90)

#1532 Export to XLSX broken?

2024-12-18T09:26:45.540000Z

Hello, I tested export to CSV on another (my private) comp Win11 just now, running under no admin, the latest Adoptium JDK 23 and CSV and XLSX works for me fine. Yes, I have JDK, no JRE and inside it Java FX from Gluon, but it should not affect this behaviour, I hope. Regards, Stepan

#1532 Export to XLSX broken?

2024-12-10T10:36:16.555000Z

I've also installed (unzipped) Eclipse Adoptium OpenJDK Runtime Environment 23.0.1+11 on my company managed laptop (MS Surface 5) running on Windows 11, but the export to XLSX still doesn't work for me. Must be a local issue then..

#1532 Export to XLSX broken?

2024-12-09T13:35:09.013000Z

Hello, Vikaash, I also tried Eclipse Adoptium OpenJDK Runtime Environment 23.0.1+11 on Windows Server 2016 and squirrel-sql-snapshot-20241208_2056-standard.jar and export to CSV nad XLSX works for me OK. Files are created, dialogue is responsive, files are opened in LibreOffice and MS Excel both OK. So it may be a problem in some configuration, I guess. Regards, Stepan

--H2 2.3.232 InMemory 
drop table if exists "t" ; 
create table "t" ("price" numeric (10, 2), "purchaseDate" timestamp); 
insert into "t" ("price", "purchaseDate") values (1234567.89, current_timestamp()); 
insert into "t" ("price", "purchaseDate") values (9876543.21, current_timestamp()); 
select "price", "purchaseDate" from "t";

#1532 Export to XLSX broken?

2024-12-09T08:42:21.507000Z

Thanks for checking. Perhaps the XLSX export is not (yet) compatible with Java 23. I've just installed 20241208_2056 and retested exporting XLSX, but unfortunately no dice..

#1532 Export to XLSX broken?

2024-12-05T09:59:04.350000Z

Hello, I tested XLSX export right now in version 20241201_2102 and it works fine for me. I am using Adoptium Java OpenJDK 17.0.12 on MS Windows. I tried the same settings as Vikaash, but Java version. Stepan

My test select is:

--H2 2.3.232 InMemory 
drop table if exists "t"; 
create table "t" ("id" int, "name" varchar(256)); 
insert into "t" ("id", "name") values (1, 'aaa'), (2, 'bbb'), (3, 'ccc'); 
select * from "t";

Export to XLSX broken?

2024-12-04T13:32:59.520000Z

Export to XLSX appears to be broken. Clicking ok in the dialogue box closes the box, but there's no export confirmation prompt after. There is however a file on the file system with size zero.
Export to XLS still works though.

Version: snapshot-20241201_2102
Java: 23.0.1+11-39