|
From: Colin B. <Col...@as...> - 2004-07-03 00:11:43
|
Hi, I've managed to duplicate this. Its happens intermittently for me, possibly depending on the actual data. I'll take a futher look at it. Col -----Original Message----- From: Knepp, Ethan [mailto:eK...@c-...] Sent: Friday, 2 July 2004 10:27 PM To: 'squ...@li...' Subject: RE: [Squirrel-sql-users] CLOB in result SQL causing lockup... 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. Thanks, Ethan -----Original Message----- From: co...@in... [mailto:co...@in...] Sent: Thursday, July 01, 2004 6:59 PM To: squ...@li... Subject: Re: [Squirrel-sql-users] CLOB in result SQL causing lockup... Hi Ethan, Works for me Oracle: Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.3.0 - Production JDBC thin driver: 9.2.0.3.0 java: 1.4.2_03-b02 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? Col > 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 9.2.0.4 > > 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 Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
