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

[Robert M. <rob...@gm...>]

For large BLOBs the most practical setting is to uncheck the "Read
contents when table is first loaded", or edit the startup script to
give more memory to the Java process (for example, increase -Xmx256m
to something like -Xmx512m if you have at least 512 MB of physical
ram).

Rob

On Mon, Feb 9, 2009 at 12:54 AM, LarsJ <lar...@co...> wrote:
>
> 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.
>
>
> ------------------------------------------------------------------------------
> Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM)
> software. With Adobe AIR, Ajax developers can use existing skills and code to
> build responsive, highly engaging applications that combine the power of local
> resources and data with the reach of the web. Download the Adobe AIR SDK and
> Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>