Re: [Squirrel-sql-users] LOB Support

[Andreas M. <and...@gm...>]

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,

Andreas.


On Thu, Jul 15, 2010 at 1:11 AM, Robert Manning
<rob...@gm...>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,
> correct?
> 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)
>
> Rob
>
> On Wed, Jul 14, 2010 at 3:50 PM, Andreas Mandel
> <And...@gm...> 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
> > Squ...@li...
> > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> >
>