Lucene and Joined Entities

bangroot · **Joined:** Sat Sep 30, 2006 11:33 am **Posts:** 2

I have been reading and investigating and not had much luck. Is there a way to tie joined entities into the same index as the main entity. For example:

Code:

@Entity
@Indexed(index="indexes/foo")
public class Foo
    private Long id;
    private Set<Bar> bars = new HashSet<Bars>();

    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    @Keyword(id=true)
    public Long getId() {
        return id;
    }

    public void setId(Long id) {
        this.id = id;
    }
 
   @OneToMany(cascade = CascadeType.ALL, fetch = FetchType.LAZY)
    public Set<Bar> getBars() {
        return bars;
    }

    public void setBars(Set<Bar> bars) {
        this.bars = bars;
    }
}

How do I get Bars to be indexed and searchable as part of the same index, but return the found Foo class when matched?

mseritan · **Posted:** Sun Oct 01, 2006 12:13 am

AFAIK one index is defined for one or multiple columns on one table. Since you have two classes in a one-to-many relationship I assume that 2 tables are used and in the Bar table you store the parent id of the first table. You can define an index that will include the parent id and some other column in bar. Is that what you have in mind? If so you can always ALTER the table to add the proper index.

Not sure if this helps, it is likely that I misunderstood your question...

Marius

bangroot · **Joined:** Sat Sep 30, 2006 11:33 am **Posts:** 2

Thanks for the reply, but I think you did misunderstand. I was speaking of Lucene indexes, not database indexes. But, you did make me think that perhaps I can just tie the @Keyword(id=true) to the Foo.id instead of the Bar.id . . .

sergiu72 · **Joined:** Tue Oct 10, 2006 2:38 pm **Posts:** 17

hi,

did you find any solution? I'm trying to create a lucene index from 2 joined entities... but no luck until now.

can you help with some ideeas?

many thanks