Re: need cursor info

From:

Robert Klemme <shortcutter@googlemail.com>

Newsgroups:

comp.lang.java.programmer

Date:

Tue, 28 Nov 2006 09:42:01 +0100

Message-ID:

<4t2b2lF1241m3U2@mid.individual.net>

On 28.11.2006 02:02, Martin Gregorie wrote:

Robert Klemme wrote:

Actually there are drivers with which you cannot get the column names
from a table via meta data, so once I actually had to resort to SELECT
* FROM table WHERE 1 = 0 in order to get the column names and types.
Fortunately I did not see the effects you mention. :-)

Sounds like a nasty driver to me. You're lucky you didn't have any large
tables to play with.

It /was/ a large table but the DB was smart enough to not do a FTS.

> Somewhat later I was working with the RedBrick data

warehouse, which only supported ODBC. Our fact table contained 3 BILLION
rows...

Some of our DWH's are in the same region.

Do you recall what happened when you tried using meta data? I mean, was
there a recognizable error code that could have been used, e.g. by
middleware developers, to decide whether the column metadata was usable
or if it was necessary to do the WHERE 1 = 0 trick?

I checked, but I did not find any error messages documented and I can't
remember. Would have to test it out again. The DB and driver were
Oracle - could be that it was with Oracle 8 and a newer driver.

Kind regards

robert