Exception in Named Query

Question

JPA is giving me an error when my application goes up. The error is in the named query:

org.hibernate.HibernateException: Errors in named queries: MyEntity.MyQuery org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:435)
org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1385)
org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:954)
org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:883)
org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:56)
javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:48)
javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:32)

The Entity code:

@NamedQuery(name = "MyEntity.MyQuery", query = "SELECT r FROM MyEntity r WHERE r.cdSecao = :secao AND r.cdPublico IN :publico")


// other class stuff declarations...


    @JoinColumn(name = "cd_publico", referencedColumnName = "cd_publico")
@ManyToOne
private TbPublico cdPublico;

@JoinColumn(name = "cd_secao", referencedColumnName = "cd_secao")
@ManyToOne
private TbSecao cdSecao;

// getters setters and assorted shenanigans...

Then in the DAO, I invoke it with this method, even though the exception is being thrown at the init of the EntityManager (because its a named query and stuff). But for the sake of completeness, here it goes:

public List<MyEntity> listMyEntity(String idPublico, TbSecao secao) {
    List<TbPublico> listaPublico = OtherClass.doMcGuffin(idPublico);

    EntityManager em = EMFactory.getEntityManager();
    TypedQuery<MyEntity> theQuery= em.createNamedQuery("MyEntity.MyQuery", MyEntity.class);
    theQuery.setParameter("secao", secao);
    theQuery.setParameter("publico", listaPublico);

    return theQuery.getResultList();

}

Back to the named query... if I remove the AND r.cdPublico IN :publico it works, but I need it.

MGPJ · Accepted Answer · 2012-12-16 03:38:43Z

1

Modify the query like this

SELECT r FROM MyEntity r WHERE r.cdSecao = :secao AND r.cdPublico IN (:publico)

When you use the IN statemet in your query then it should come into the ().

answered Dec 16, 2012 at 3:38

MGPJ

1,0821 gold badge8 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

DataNucleus · Accepted Answer · 2012-12-15 10:37:39Z

0

Explain how a TbPublico can be IN a List<Integer> ??? It could possibly be IN a List<TbPublico>

answered Dec 15, 2012 at 10:37

DataNucleus

15.6k3 gold badges34 silver badges37 bronze badges

4 Comments

Mindwin Remember Monica Over a year ago

MAYBE A TYPO. I had to change some stuff in order to obfuscate my real source code (company policy) so I could post it on S.O. without my boss yanking my ears.

Mindwin Remember Monica Over a year ago

Also, this is not a real answer, you should use a comment for stuff like that, i think ;()

DataNucleus Over a year ago

If you have a typo I suggest that you correct your question, because obviously as it is currently my answer points out an error in it and consequently a possible reason why your JPA provider throws an exception.

Mindwin Remember Monica Over a year ago

The JPA framework loads the named queries annotated in entities at server startup, by the time the DAO code is executed, the hybernate exception has been long thrown. Actually, it is not even executed, because the entity manager never loaded.

Collectives™ on Stack Overflow

Exception in Named Query

2 Answers 2

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related