Hi all,

I am trying to create a hibernate search project and I am confused. It is better to use JPA or Hibernate Session? I am using EJB 3.0. My connection pool is in jboss AS6.

First, I try with JPA but I got "Hibernate Session is closed". Then I change to Hibernate and it seems to be working fine...what's the difference?

I have this:

@PersistenceContext(unitName="custDb")
EntityManager manager;

org.hibernate.Session session = (Session)manager.getDelegate();

Thanks in advance.

Hi,
for what matters for Hibernate Search's purposes they should behave exactly the same, being different only in the exposed interface.
Could you provide a test or example? As far as I know, that should work fine.

That's exactly what i thought but with jpa i got the exception "hibernate session is closed".

I got the mysql pool at JBoss 6 and I inject the code in my EJB 3.0 with:

@PersistenceContext()
EntityManager em;

My example with JPA:

FullTextEntityManager fullTextEntityManager = org.hibernate.search.jpa.Search.getFullTextEntityManager(em);
final QueryBuilder b = fullTextEntityManager.getSearchFactory().buildQueryBuilder().forEntity( Myth.class ).get();

org.apache.lucene.search.Query luceneQuery = b.keyword().onField("history").boostedTo(3).matching("storm").createQuery();
javax.persistence.Query fullTextQuery = fullTextEntityManager.createFullTextQuery( luceneQuery );

List result = fullTextQuery.getResultList(); //return a list of managed objects

My example with Hibernate Session:

Session session = (Session) em.unwrap(Session.class);
FullTextSession fullTextSession = Search.getFullTextSession(session);

SearchFactory searchFactory = fullTextSession.getSearchFactory();
...
org.hibernate.Query fullTextQuery = fullTextSession.createFullTextQuery(luceneQuery);

List result = fullTextQuery.list(); //return a list of managed objects


It's like with JPA the Hibernate Session is never initialized..but I don't really know. I' ve got an example that works with Hibernate session. You can check it out at http://forum.hibernate.org/viewtopic.php?f=9&t=1011450.

With JPA, should i start the session? I think that the EJB does it for me....

Well, let me know any suggestions :)

Thanks in advance.

yes you should not need to start the session, that should be done when it's injected.
Does something else work using this em? Can you check if a simple load, or a criteria work? Just to know if there's something wrong with your EntityManager, or with the Search integration.

as far as i know, every time that i wanted to make a search query with JPA i got to do this:

FullTextEntityManager fullTextEntityManager = org.hibernate.search.jpa.Search.getFullTextEntityManager(em);
final QueryBuilder b = fullTextEntityManager.getSearchFactory()
javax.persistence.Query fullTextQuery = fullTextEntityManager.createFullTextQuery( luceneQuery );


I want to create a query and use facets so i just need to create my fullTextQuery one time and apply or eliminate the facets. With jpa that was impossible because i got the exception "Hibernate session is closed" when I use the fullTextQuery created before.

I would like to use jpa but i can't make it work...

thanks in advance.

yes I understood that, but to try understanding your error I need to know if other queries work with the entitymanager (non fulltext but standard database queries).
Also, do you see exceptions or other error messages in the log?

Hi,

General database querys in mysql are working and also fulltextEntitymanager :

public String doindex() throws InterruptedException
{
FullTextEntityManager fullTextEntityManager = org.hibernate.search.jpa.Search.getFullTextEntityManager(em);

fullTextEntityManager.createIndexer().startAndWait();

return "OK";
}

The problem, as you see in my code posted before, is that if i want to reuse a query created before, hibernate tells me that the session is closed.

I got everything working now but only when i want to reuse the query for faceting, i am using the fulltextsession:

Session session = (Session) em.unwrap(Session.class);
FullTextSession fullTextSession = Search.getFullTextSession(session);

Thanks in advance