Hi All,

I am using Hibernate to develop a contact application. I now need to add the support to detect duplicate contacts on the basis of Name, Email etc. I would like to know what could be the best implementation strategy for this problem? Should I make use of stored procedures or will APIs like Hibernate Search can help here?

Any links, references to the solutions which are targeted towards same domain will be highly appreciated.

Thanks,
Nitin

What exactly do you want? Is it that you dont want two contacts to have same name or email? Then a unique constraint will do ur work.

Thanks for the response.

In my case a user can import multiple contacts from multiple sources. There will be an option in the application using which an user can detect his duplicate contacts. The duplicity is to be detected on the basis of either of the email or the name.

I am looking for some help on what could be the best possible implementation strategy for this problem? Can I make use of Hibernate Search to simplify this kind of a look up & to achieve it with good performance as well. Or some kind of a stored procedure will work for me where I can use normal SQL functions like 'group by'.

Regards,
Nitin

I dont think Hibernate Search will be required for your case, coz its for free text search which means search a text criteria in different fields of different tables. But in your case at a time the search needs to be only in a particular field of a particular table. So you can use simple SQLs or HQLs to detect duplicate entries.