#1039 Grid does not show CLOB values for DB2

3.2.1
closed-invalid
Rob Manning
DB2 Plugin (16)
5
2014-09-17
2012-07-31
leo marini
No

On clicking on the Content tab for a table with CLOB columns (when connected to a DB2-UDB) the data is displayed without the correct value in the CLOB
columsn. That column is displayed as <Clob> instead of the actual data.
If I query that very same record using the DB2 CLP (Command Line Program) I can see the values coming from that very column.

I'm using JDBC driver 'IBM Data Server Driver for JDBC and SQLJ' version 4.7.85.

Other drivers for other DBMS e.g. Oracle, do work.
Ex. JDBC driver 'Oracle JDBC driver' version 11.2.0.2.0

Please advise,

Leo

Discussion

  • Rob Manning
    Rob Manning
    2012-08-12

    This is the default setting for BLOB/CLOB types. It allows SQuirreL to load the more commonly used data faster. You can change this by going to File -> Global Preferences -> Data Type Controls, and scroll down in the Global Preferences window until you see settings for BLOB and CLOB types. There you would select the checkbox next to "Read contents when table is first loaded". Alternatively, it may also be possible to double-click on the cell that contains
    "<Clob>" value to see a separate window with the data displayed.

     
  • Rob Manning
    Rob Manning
    2012-08-12

    • status: open --> closed-invalid