#496 failure to export cvs/excel on mac osx

closed-fixed
Rob Manning
Core (461)
9
2007-03-15
2007-03-14
Colin Bester
No

Just downloaded and installed to mac osx 10.4.8 running java version "1.5.0_07" and noticed that I am unable to export to CSV/Excel.

The log files show missing jxl class, see below.

I confirmed that jxl.jar is included in lib folder under Contents/Java

Hope this helps - awsome product and happy to assist with testing.

68899 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.client.Application - Exception occured dispatching Event java.awt.event.MouseEvent[MOUSE_RELEASED,(38,85),button=1,modifiers=Button1,clickCount=1] on ###overrideRedirect###
java.lang.NoClassDefFoundError: jxl/write/WritableCell
at net.sourceforge.squirrel_sql.fw.gui.TablePopupMenu$ExportCsvAction.actionPerformed(TablePopupMenu.java:303)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1882)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2202)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
at javax.swing.AbstractButton.doClick(AbstractButton.java:334)
at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1000)
at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1041)
at java.awt.Component.processMouseEvent(Component.java:5554)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3126)
at java.awt.Component.processEvent(Component.java:5319)
at java.awt.Container.processEvent(Container.java:2010)
at java.awt.Component.dispatchEventImpl(Component.java:4021)
at java.awt.Container.dispatchEventImpl(Container.java:2068)
at java.awt.Component.dispatchEvent(Component.java:3869)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4256)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3936)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3866)
at java.awt.Container.dispatchEventImpl(Container.java:2054)
at java.awt.Window.dispatchEventImpl(Window.java:1774)
at java.awt.Component.dispatchEvent(Component.java:3869)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
at net.sourceforge.squirrel_sql.client.Application$1.dispatchEvent(Application.java:168)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:190)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:176)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
81919 [AWT-EventQueue-1] DEBUG net.sourceforge.squirrel_sql.fw.util.TaskThreadPool - Reusing existing thread

Discussion

  • Colin Bester
    Colin Bester
    2007-03-14

    Logged In: YES
    user_id=7059
    Originator: YES

    Forgot to add I downloaded and installed Squirrel-sql Version 2.4.1

     
  • Rob Manning
    Rob Manning
    2007-03-15

    Logged In: YES
    user_id=1287991
    Originator: NO

    Confirmed, it's a problem. This issue isn't isolated to jxl.jar. It appears that the hibernate3.jar isn't being located as well. It's probably a bug in how we load the classes from jars at startup that only appears on the Mac platform. I'll look into it.

    Rob

     
  • Rob Manning
    Rob Manning
    2007-03-15

    • labels: --> Core
    • priority: 5 --> 9
    • assigned_to: nobody --> manningr
     
  • Rob Manning
    Rob Manning
    2007-03-15

    • status: open --> closed-fixed
     
  • Rob Manning
    Rob Manning
    2007-03-15

    Logged In: YES
    user_id=1287991
    Originator: NO

    No problem with how we load classes into the classloader. It's simply that the ClassPath entry is not correct in the Info.plist file. It is currently :

    <string>$JAVAROOT/squirrel-sql.jar</string>

    It needs to include all of the jars in $JAVAROOT/lib - like so:

    <string>$JAVAROOT/squirrel-sql.jar:$JAVAROOT/lib/antlr-2.7.5H3.jar:$JAVAROOT/lib/commons-cli.jar:$JAVAROOT/lib/commons-logging-1.0.4.jar:$JAVAROOT/lib/forms.jar:$JAVAROOT/lib/fw.jar:$JAVAROOT/lib/hibernate3.jar:$JAVAROOT/lib/jxl.jar:$JAVAROOT/lib/log4j.jar:$JAVAROOT/lib/nanoxml-2.2.3.jar</string>

    The Info.plist file will be located in SQuirrelSQL.app/Contents

    The file is fixed in CVS. Try making the change in your copy of Info.plist and let us know if it still isn't working.

    Rob

     
  • Colin Bester
    Colin Bester
    2007-03-16

    Logged In: YES
    user_id=7059
    Originator: YES

    I added the jars to class path in Info.plist and it works like a charm.

    Thanks
    Colin