wood burning stoves 2.0*
The moose likes JSP and the fly likes Oracle text search Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » JSP
Bookmark "Oracle text search" Watch "Oracle text search" New topic
Author

Oracle text search

Raj Puri
Ranch Hand

Joined: Apr 24, 2003
Posts: 189
I am trying to set up a JSP so that it can display the result of search on a Oracle text(like Blob) column. The Blobs stored could be doc,pdf,xls etc.
The page should show file name along with matching hits and one should be able to click the file name and view whole file etc.


I looked Oracle text documentation but that seems to use Oracle Java lib,
is there any other way? Thanks.
Adeel Ansari
Ranch Hand

Joined: Aug 15, 2004
Posts: 2874
Originally posted by Raj Puri:
[QB]I am trying to set up a JSP so that it can display the result of search on a Oracle text(like Blob) column.


Blob is not text. You can search based on file name and then get the corresponding file to show/download.
 
Consider Paul's rocket mass heater.
 
subject: Oracle text search