Hibernate Search indexing properties question

danscrima · **Posted:** Tue Aug 19, 2008 3:19 pm

I've read and tried many of the indexing options available, and still aren't quite getting what I need.

For example, if I have database table called "tblUtterance", with a column name "Line", the following is how I'm indexing...

Code:

Session session = this.hibernateTemplate.getSessionFactory().openSession();
        FullTextSession fullTextSession = Search.createFullTextSession(session);
        fullTextSession.getTransaction().begin();

        List<Utterance> utterances = session.createQuery("from Utterance").list();
        for (Utterance utterance : utterances) {
            fullTextSession.index(utterance);
        }

And this is my Utterance.java pojo. I also have this class extending another class where the @DocumentId is declared, so it is there as well.

Code:

@SuppressWarnings("serial")
@Entity
@Table(name = "tblUtterance", schema = "dbo")
@Indexed
@Analyzer(impl = WhitespaceAnalyzer.class)
public class Utterance extends UIDContainer {

    @Field(store = Store.YES, index = Index.TOKENIZED)
    @Column(name = "Line", nullable = false, length = 4000)
    private String line;

In the Luke tool, if a document that was indexed (a row in my table) is the following:
"Fine. How are you?"

I want to be able to search for the word "Fine" and have this utterance as a result, but nothing shows up. The only way it shows up is if I type the entire thing verbatim. Any ideas on how to have a true "full-text" index and search??

Thanks!

danscrima · **Posted:** Tue Aug 19, 2008 4:49 pm

I've figured it out using the online documentation as well as Hibernate Search in Action.

Its not even worth mentioning because I'm just a dummie sometimes...

Thanks to you who took the time to read this though. Definitely appreciated.

sanne.grinovero · **Posted:** Wed Aug 20, 2008 4:29 am

Hi danscrima,
I'm happy you solved it, but got curious.. so please, what was it?

danscrima · **Posted:** Wed Aug 20, 2008 6:05 am

I was indexing all wrong...

The top-level class needed @Indexed(index="indexName")
and I didnt need that for any of the other dependent classes. If you put @Indexed at the top of the other ones, it will created an additional index, and I wanted all my information to be in one to allow for easy searching.

So for an easy example, image my two classes, and I want them to be in the same index so I can search easily:

Code:

@Entity
@Table(name="tblPage",schema="dbo")
@Indexed(index="Library")
@Analyzer(impl = SimpleAnalyzer.class) 
public class Pages{
    @Id
    @Column(name = "id", nullable = false, unique = true, updatable = false)
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @DocumentId
    protected int id;

    @ManyToOne(fetch = FetchType.LAZY)
    @JoinColumn(name = "BookID", nullable = false)
    @IndexedEmbedded
    private Book book;
}

@Entity
@Table(name="tblBook",schema="dbo")
public class Book{
    @ContainedIn
    @OneToMany(mappedBy = "book")
    @Cascade(value = {CascadeType.SAVE_UPDATE})
    @Fetch(value = FetchMode.SUBSELECT)
    private List<Book> books= new ArrayList<Book>();
}

If you use Luke to analyze the index, you will see that each document will have a field "id" for the Page and a field "page.book.id" or something similar. I may have mixed them up but thats the general idea. Only one index is created.

Hope that helps... someone. Ha.