|
From: Gerd W. <ger...@t-...> - 2023-01-21 00:21:50
|
Ivo,
this issue required some restructuring of the BLOB and CLOB loading
configurations. Here's the excerpt from our change log on the changes:
Data types BLOB and CLOB loading configuration was restructured and fixed.
Both data types now offer the following loading options:
- Read contents when table is first loaded (offers to limit the
amount of data to read)
- Read contents when table cell becomes visible
- Read contents when table cell is focused
- Do not read contents
See menu File --> Global Preferences --> tab "Data Type Controls" -->
sections BLOB and CLOB
The first snapshot that contains these changes is available here
https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20230121_0057/
or here
https://github.com/squirrel-sql-client/squirrel-sql-snapshot-releases/releases/tag/snapshot-20230121_0057
Please give it a try.
Gerd
Am 11.01.23 um 14:21 schrieb Ivo Krab:
> Hi,
>
> Don't know if this is a bug or a config problem in my setup. I recently
> installed 4.5.1 next to the 4.0.0 I'd been using so far (with java 11
> and adapted launch .bat to use the correct java), but I notice problems
> with blob/clob columns. DB is Oracle 19c, driver ojdbc10.jar
>
> When the "Data Type Controls" options "Read contents when table is first
> loaded" is unchecked, the table shows just <blob> or <clob> (whereas
> 4.0.0. would after display still load the actual contents as they scroll
> into view in the table). However, double-clicking a cell to open it
> keeps showing just that, instead of loading the actual contents as I
> think it's supposed to do. Also I do not see any option to force-load
> the contents manually.
>
> When the option to pre-load is checked, the table shows for a clob for
> example "<ns2:notifyEmployeeAttributionDecision xmlns:ns2="... (so a
> truncated string to match the column width), but when I double-click to
> open, it still shows the truncated string instead of the full contents!
> Same with the bytes representation of a blob. Also remains truncated at
> the intial column width of the table...
>
> Any pointers as to what I might be doing wrong?
>
> Kr.
>
> Ivo Krab
>
>
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
|
