lucene-general mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sanne Grinovero <sanne.grinov...@gmail.com>
Subject Re: Lucene with Relational Databases
Date Tue, 25 May 2010 22:23:46 GMT
2010/5/25 josh45 <joshhoy45@gmail.com>:
>
> Hello All,
>
> First let me start of by saying thanks for any help anyone can give me.  I
> am a newb when it comes to Lucene and what it can do and I have been
> searching to see if it can solve one of my problems.  However, I guess I
> don't have my black belt yet with searching google and have not yet been
> able to find the answer so I figured I could ask the experts :).
>
> So here it goes....
>
> I have a relational database for example I have the tables, orders,
> products, and customers.  The relationship is in orders has a product id and
> customer id.  My issue is I would like to enter in something like "Mike and
> printer" And have it return the the customer id and the printer id.  Pretty
> bad example I know but I think it gets the point across.  If this can be
> done or can not with Lucene I would love to know.  If I need to go into
> anymore detail please let me know I would be glad to.  Thanks again, I know
> its a poor question but I would love to know the answer or now where to get
> the answer!

if you're using Hibernate or JPA to abstract your database I would
recommend to look into Hibernate Search; also it's quite simple to use
in case you're new to Lucene.
(but my suggestion doesn't make sense if the application exists
already and is not using Hibernate).

Sanne

Mime
View raw message