Hi Everybody,

I have a requirement where in i need the product that we are devloping to allow the user with the following search type:

1. Stem Search:
Example Values: A query that can return values such as Abort, Aborting, Aborted.
I would like to return result that contain all the three values when the user enter any one of the above values as the search criteria.

2. Fuzzy Search:
Example Values : python, pithon, phithon
I would like to return all the above values for a search criteria where the user might enter any of the above three values. One could consider it as a case where in the user might have commited some typographical error.

3. Sounds/Phonic search:
Example values : Smith, Smithe, Smythe.

Here again the user might enter any of the above values but i need to return all the three values.

I would like to know if Hibernate has any in-built feature or some tweaks that will allow me to achive the above,

In our case the product that we are developing is pretty much assured to stick to Oracle for its life, i would also like to know if hibernate has any way to access the rich search featuers that oracle comes with (All the above search type are provided as an external piece of software that could be bought and used along with oracle from oracle itself).

I would appricate any insight into this query.

Warm Regards,
Madhusudan M Krishnamurthy

if your rdbms supports it and it can be expressed by a function call then you can use it in the where part of a HQL query.

if some special sql is needed look into createSQLQuery() (please not it currently only supports returning full persistent objects)

To me it seems like you're in the need of a free-text search engine. Have you considered Luceneand the like?

I'm afraid I can't help you with the Hibernate/Lucene integration though since I've never tried it myself...