Hi Rob,

thanks for the quick reply.

My version in use is: 2010-07-15 08:30:53,772 [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - # Starting SQuirreL SQL Client Version 3.1.2 at 15.07.10 08:30

Pressing the export button I get a alert pop-up with the message:

There was an error while writing file ...
The error was:
For input string: "<B"

When I try to reproduce it now I can not see any exception logged, but I find the following exception earlier in the logs:

2010-07-15 08:25:50,440 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.client.Application  - Exception occured dispatching Event java.awt.event.MouseEvent[MOUSE_RELEASED,(28,35),absolute(645,366),button=1,modifiers=Button1,clickCount=1] on ###overrideRedirect###
java.lang.NumberFormatException: For input string: "<B"
    at java.lang.NumberFormatException.forInputString(Unknown Source)
    at java.lang.Integer.parseInt(Unknown Source)
    at java.lang.Integer.valueOf(Unknown Source)
    at net.sourceforge.squirrel_sql.fw.datasetviewer.cellcomponent.BinaryDisplayConverter.convertToBytes(BinaryDisplayConverter.java:188)
    at net.sourceforge.squirrel_sql.fw.datasetviewer.PopupEditableIOPanel$BinaryOptionActionListener.actionPerformed(PopupEditableIOPanel.java:111)
    at javax.swing.JComboBox.fireActionEvent(Unknown Source)
    at javax.swing.JComboBox.setSelectedItem(Unknown Source)
    at javax.swing.JComboBox.setSelectedIndex(Unknown Source)
    at javax.swing.plaf.basic.BasicComboPopup$Handler.mouseReleased(Unknown Source)
    at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
    at java.awt.Component.processMouseEvent(Unknown Source)
    at javax.swing.JComponent.processMouseEvent(Unknown Source)
    at javax.swing.plaf.basic.BasicComboPopup$1.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.dispatchEvent(Unknown Source)
    at net.sourceforge.squirrel_sql.client.Application$1.dispatchEvent(Application.java:194)
    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)

and some - even elder:

2010-07-14 18:59:45,590 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.client.Application  - Exception occured dispatching Event java.awt.event.InvocationEvent[INVOCATION_DEFAULT,runnable=javax.swing.SystemEventQueueUtilities$ComponentWorkRequest@274608,notifier=null,catchExceptions=false,when=1279126785309] on sun.awt.windows.WToolkit@698403
java.lang.OutOfMemoryError: Java heap space

The column of the cell I want to export is described as TYPE_NAME 'BLOB' in the Columns tab with DATA_TYPE 2004

Kind Regards,


On Thu, Jul 15, 2010 at 1:11 AM, Robert Manning <robert.m.manning@gmail.com> wrote:
I was able to just now with DB2 9.5 and the latest SQuirreL.  You
double-click on the blob cell and export the data to a file there,
Can you post the full stack trace ? (It may or may not be a bug we can
fix/work-around, but I need the stack trace to tell)


On Wed, Jul 14, 2010 at 3:50 PM, Andreas Mandel
<Andreas.Mandel@gmail.com> wrote:
> Hi,
> is it possible with quirrel-sql to read and write lob data stored in a
> DB cell from / to files?
> I've a DB2 backend and I'm looking for an easy way to work with binary
> data stored in the DB. If I try to 'EXPORT' data of a lob call
> (displayed as <BLOB>) all I get is a ArrayIndexOutOfBounds exception.
> Any help is welcome,
> Andreas.
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by Sprint
> What will you do first with EVO, the first 4G phone?
> Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
> _______________________________________________
> Squirrel-sql-users mailing list
> Squirrel-sql-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users