From: "The Man, The Myth, The Legend" <hotkee@hotmail.com>
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle,comp.databases.oracle.tools
Subject: Re: interMedia functions and JDBC ResultSets
Date: Sat, 9 Sep 2000 16:53:45 +0100
Organization: BT Internet
Lines: 46
Message-ID: <8pdml1$6ut$1@neptunium.btinternet.com>
References: <39B7B8D5.54FBE7FC@agency.com>
NNTP-Posting-Host: host213-1-131-143.btinternet.com
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300


try specifiying an alias for the score(0) value

Kemi Eke <keke@agency.com> wrote in message
news:39B7B8D5.54FBE7FC@agency.com...
> Hi
>
> I am working with Oracle 8i and interMedia and have a simple-ish
> question on the use of the score(int containsLabel) and SQL SELECT
> statements with JDBC ResultSets.
>
> If I execute the following statement on a table named "docs" of say two
> columns named document_id and text, where "text" has been indexed by
> interMedia...
>
> SELECT document_id, text, score(0)
> FROM docs
> WHERE CONTAINS(text, 'fish', 0) > 0
> ORDER BY score(0) DESC
>
> ...using JDBC I get a "invalid column name" for score(0) returned as a
> SQLException, but in SQL+ this works perfectly well.  This "pseudo"
> column exists and shows the relevant results but I can't access it with
> JDBC. I also have had problems with Oracle's implementation of
> oracle.jdbc.driver.* classes.  Also, one of the design constraints on
> the project is not to use temporary tables.  This leads me to several
> conclusions:
>
> 1) Should I create a table and perform the operation on docs, stuff the
> results in the new table and then interrogate the new table for the
> results?
>
> 2)Is there something basic I'm missing that JDBC offers wrt "pseudo"
> columns?
>
> Any assistance would be gratefully received.
>
> Thanks in advance
>
> Kemi Eke
>
> PS Please reply to my email address as well if possible keke@agency.com
>
>
>