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:
- 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
