[Squirrel-sql-users] Hangs viewing BLOBs in Oracle

[LarsJ <lar...@co...>]

I just updated to the latest Squirrel-SQL Base (squirrel-sql-2.6.9-base.zip -
although within the app itself it says 2.6.8), running on Windows XP.

As soon as I execute a query that returns a BLOB, the little memory-usage
bar graph at the bottom of the SquirrelSQL window climbs to 254MB and then
Squirrel hangs.  Changing the BLOB/CLOB preferences in File -> Global
Preferences -> Data Type Controls seems to make no difference - tried "Read
contents when table is first loaded" checked, unchecked, and checked with
"Read only the first 1" or "Read only the first 0".

I also get the following stack trace in the log:

743573 [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@6788c4,notifier=null,catchExceptions=false,when=1233631707202]
on sun.awt.windows.WToolkit@e86da0
java.lang.OutOfMemoryError: Java heap space
	at java.util.Arrays.copyOf(Unknown Source)
	at java.lang.AbstractStringBuilder.expandCapacity(Unknown Source)
	at java.lang.AbstractStringBuilder.append(Unknown Source)
	at java.lang.StringBuffer.append(Unknown Source)
	at
net.sourceforge.squirrel_sql.fw.datasetviewer.cellcomponent.BinaryDisplayConverter.convertToString(BinaryDisplayConverter.java:142)
	at
net.sourceforge.squirrel_sql.fw.datasetviewer.cellcomponent.BlobDescriptor.toString(BlobDescriptor.java:145)
	at
net.sourceforge.squirrel_sql.fw.datasetviewer.cellcomponent.DefaultColumnRenderer.renderObject(DefaultColumnRenderer.java:64)
	at
net.sourceforge.squirrel_sql.fw.datasetviewer.cellcomponent.DataTypeBlob.renderObject(DataTypeBlob.java:226)
	at
net.sourceforge.squirrel_sql.fw.datasetviewer.cellcomponent.CellComponentFactory$CellRenderer.setValue(CellComponentFactory.java:294)
	at
javax.swing.table.DefaultTableCellRenderer.getTableCellRendererComponent(Unknown
Source)
	at
net.sourceforge.squirrel_sql.fw.datasetviewer.cellcomponent.CellComponentFactory$CellRenderer.getTableCellRendererComponent(CellComponentFactory.java:263)
	at javax.swing.JTable.prepareRenderer(Unknown Source)
	at javax.swing.plaf.basic.BasicTableUI.paintCell(Unknown Source)
	at javax.swing.plaf.basic.BasicTableUI.paintCells(Unknown Source)
	at javax.swing.plaf.basic.BasicTableUI.paint(Unknown Source)
	at javax.swing.plaf.ComponentUI.update(Unknown Source)
	at javax.swing.JComponent.paintComponent(Unknown Source)
	at javax.swing.JComponent.paint(Unknown Source)
	at
net.sourceforge.squirrel_sql.fw.datasetviewer.DataSetViewerTablePanel$MyJTable.paint(DataSetViewerTablePanel.java:244)
	at javax.swing.JComponent.paintChildren(Unknown Source)
	at javax.swing.JComponent.paint(Unknown Source)
	at javax.swing.JViewport.paint(Unknown Source)
	at javax.swing.JComponent.paintChildren(Unknown Source)
	at javax.swing.JComponent.paint(Unknown Source)
	at javax.swing.JComponent.paintChildren(Unknown Source)
	at javax.swing.JComponent.paint(Unknown Source)
	at javax.swing.JComponent.paintChildren(Unknown Source)
	at javax.swing.JComponent.paint(Unknown Source)
	at javax.swing.JComponent.paintChildren(Unknown Source)
	at javax.swing.JComponent.paint(Unknown Source)
	at javax.swing.JComponent.paintChildren(Unknown Source)
	at javax.swing.JComponent.paint(Unknown Source)

Is there a way I can force Squirrel not to attempt to display these BLOB
fields?

-- 
View this message in context: http://www.nabble.com/Hangs-viewing-BLOBs-in-Oracle-tp21803374p21803374.html
Sent from the squirrel-sql-users mailing list archive at Nabble.com.