Oracle Text and Java

[Quoted] I stored files( pdf,word) in blob column. I created index (INSO_FILTER) and i would like to query the files.
...

String sword="test";
String query = "Select COMPID,CREATED,NAME,CVNUMBER from COMPANYCV" + " where contains(CV,' "+sword+" ') > 0 " ; System.out.println(query);
ResultSet rs = stmt.executeQuery(query);
...

works fine i get the compid,date,number and filename of the stored file in the blob column. This info is displayed als a link(url). ie. <A HREF="ShowCv.jsp?NAME=doc1.pdf...... So when the user clicks on it, the appropriate program opens (word,acrobat reader) and the content of the file is shown.

But i also want to know how many times the word "test" is found in each of the documents? How can i do this in java (jsp)?

And i want to highlight to word that is searched for in the document? Any help on doing this ( examples)? The doc should open in the browswer( html -version) and words
should be highlighted.

plz help!

ps.

if i use:
select score(1),NAME,COMPID from COMPANYCV where contains(CV, 'BLOB',1 ) > 0 order by score(1) desc

i get:
100,Test2.doc,4
39,Test1.doc,5

the score is 39 with Test1.doc! But the word blob is not present in that document. What does the score realy mean?

thx Received on Sat Feb 16 2002 - 14:47:17 CET