convert sql query to hibernate query to retun list of specific object

Question

I 'd like to convert the query below to hql to return me a List<Article> because with createSqlQuery it is impossible , I must convert the result manually :
here is the sql query :

Query query = getSessionFactory().getCurrentSession().createSQLQuery(
                 "select * 
                  from article 
                  where articleID in (select articleID 
                                      from article_depot 
                                      where depotID = "+depotID+")"
              );

thank you in advance

DessDess · Accepted Answer · 2013-04-05 08:38:25Z

2

Assuming that you have a OneToMany relation between article_depot and article (One Depot contains multiple articles) if this have been correctly mapped the query would be :

Query query = getSessionFactory().getCurrentSession().createQuery("SELECT d.article from article_depot d where d.depotId = :depotId");
query.setParameter("depotId", depotId);
List<article> resultList = query.getResultList();

edited Apr 5, 2013 at 8:38

answered Apr 5, 2013 at 8:31

DessDess

7871 gold badge6 silver badges20 bronze badges

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

Collectives™ on Stack Overflow

convert sql query to hibernate query to retun list of specific object

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related