I'm sorry I was wrong, SQuirrel Client doesn't lock up, but it acts like it can't refresh its display. I can choose menu items, pick from the history drop down, move the size of windows, and click in the results panel, but the results only show one or two rows at at time, and the CLOB column data doesn't show up.
The table is fairly small (100-200 records), so the limit rows check box in the SQL panel didn't make a difference. I am also not performing any special SQL like 'order by'. I am actually doing one where for an individual row to be returned.
If it helps when I view the table in the Content Tab, the CLOB column rows don't immediately show the data. At first, the column rows read '<CLOB>', then after I select an individual cell, the contents is displayed. Is this normal behavior?
I will try an updated jdbc driver and see if that makes a difference.
From: firstname.lastname@example.org [mailto:email@example.com]
Sent: Thursday, July 01, 2004 6:59 PM
Subject: Re: [Squirrel-sql-users] CLOB in result SQL causing lockup...
Works for me
Oracle: Oracle9i Enterprise Edition Release 22.214.171.124.0 -
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 126.96.36.199.0 - Production
JDBC thin driver: 188.8.131.52.0
If its working in the Content Tab but not in the SQL tab
then it may be something as simple as you having the
"Contents - Limit Rows" checkbox selected with a small
number of rows (e.g. 100) in the Object Tree tab in your
session properties but not having the "Limit Rows" checkbox
selected on the SQL tab, which could mean (depending on the
size of your table) that you are bringing back a large
amount of data which may take a long time.
Are you using an ORDER BY clause or a WHERE clause that may
be causing a full table scan and so slowing it down?
> Does anyone know why a SQL statement that selects a table
> that contains a CLOB column is causing my SQuirrel Client
> to lockup? I can view the same table in Object Tree with
> no problems.
> SQuirrel Version: 1.2beta6
> Java Version: 1.4.2_04
> Database: Oracle 184.108.40.206
> CLOB column metadata:
> COLUMN_NAME: ENTRY
> TYPE_NAME: CLOB
> COLUMN_SIZE: 4000
> DECIMAL_DIGITS: <null>
> IS_NULLABLE: YES
> COLUMN_DEF: <null>
> REMARKS: <null>
> DATA_TYPE: 1111
> BUFFER_LENGTH: 0
> NUM_PREC_RADIX: 10
> NULLABLE: 1
> SQL_DATA_TYPE: 0
> SQL_DATETIME_SUB: 0
> CHAR_OCTET_LENGTH: 4000
> ORDINAL_POSITION: 5
This SF.Net email sponsored by Black Hat Briefings & Training.
Attend Black Hat Briefings & Training, Las Vegas July 24-29 -
digital self defense, top technical experts, no vendor pitches,
unmatched networking opportunities. Visit www.blackhat.com
Squirrel-sql-users mailing list