Hello Frnds,

I have a basic question regarding Hibernate Search.
Basically I have to implement search against database which should have features like "Match all words" , "Match any words", "boolean".
I am not sure how hibernate serach can help me in that ? Does Lucene and Hibernate search help achive that?

Thanks,
DS.

sure, that's a job for Hibernate Search.
doing that by pure-SQL will get you into trouble.. lot of code to write and huge performance and scalability problems.
The task you describe is trivial with Hibernate Search, but you can get much more than that, like typo's corrections,
synonyms (vocabulary), return results in order of relevance, keywords highlighting, and much more.
You might not need them now, but just in case be aware that it all gets easy.
I'd recommend you read the book advertised in these pages as it best describes all features by a problem-solution approach and provides working examples.

Sanne, Thanks very much for the response.
I came across a tool called DBSight which uses lucene internally.The advantage I see with that is that it doesnt require any coding.
The index on data can be created outside the application and can integrate well with any app.

-Deepak.

That doesn't look like practical at all;
How will you keep the index in sync with your db?
And you'll have for sure to write code to make the queries; using Hibernate Search you have one unified API for both index and db queries, to minimize application code changes and keep it easy for developers.
BTW, Lucene's answers are not very practical to deal with, with HS you get objects as query results.

I m not sure why you feel its not practical!
The index can be created at specified intervals and It can be incremental.

Also you really dont need to write any query.The query parameter can be passed to the DBSight app which returns the matching results.

-DS