File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Search BLOB for text Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Search BLOB for text" Watch "Search BLOB for text" New topic

Search BLOB for text

Abhijatt Alokk

Joined: Jan 24, 2006
Posts: 1
I have around 7000 blob records containg word Doc's.(Its increasing ...)
I need a text search on this BLOB feild.
I am considering two options as of now:
1. store all the BLOB into the local File system of the App Server and use file search.i.e create a file object and loop and search.Thus every time i insert a new blob from application i do it on the server FS and in the DB.

2. Write a proc in the DB where i loop and the blobs and search my text.(I dont know how..)

Any Help would Be greatly Appreciated...
Thanks in Advance.
Paul Clapham

Joined: Oct 14, 2005
Posts: 19973

Your main problem is not that the data is in a BLOB, but that the data is in MS Word format. To search for text in the documents, you must have code that understands MS Word format. And Java code that does that is not easy to find (and don't even think of trying to write it yourself if you have to ask this question).

It's possible that Open Office has something that could help you.
I agree. Here's the link:
subject: Search BLOB for text
It's not a secret anymore!