does FetchProfile work in HQL ?

gpeel · **Posted:** Fri Feb 15, 2013 1:14 pm

dear all,
I can't make Fetch Profiles work with HQL.
I used it succesfully with the (old) native Criteria and with session.get() API, but not with HQL.
is it normal ?
thanks

the following does not work :

Code:

   @Override
   public List<Country> findAllFetchProfileCities() {
      getSession().enableFetchProfile("countryCities");
      boolean enabled = getSession().isFetchProfileEnabled("countryCities");
      List<Country> list = getSession().createQuery("from Country").list();
      enabled = getSession().isFetchProfileEnabled("countryCities");
      return list;
   }

the following works OK :

Code:

   @Override
   public Country findOneFetchProfileCities(Long _id) {
      getSession().enableFetchProfile("countryCities");
      Country c = (Country) getSession().get(Country.class, _id);
      return c;
   }

   @Override
   public List<Country> findAllCriteriaFetchProfileCities() {
      getSession().enableFetchProfile("countryCities");
      return getSession().createCriteria(Country.class).list();
   }

impakt42 · **Joined:** Fri Dec 13, 2013 10:22 am **Posts:** 4

Hi Gauthier,

I have the same problem as you using a ProjectionList on a session using a FetchProfile...

did you resolve your previous problem ?

thx

i42
---
Salut Gauthier,

j'ai le mm problème que toi lorsque j'utilise une ProjectionList sur une session qui se sert d'un FetchProfile

As tu réussi à résoudre ton problème ?

merci (d'avance)

i42

gpeel · **Posted:** Fri Dec 13, 2013 10:44 am

No I guess, it simply doesn't work !
I've had no response from stackOverflow either.

impakt42 · **Joined:** Fri Dec 13, 2013 10:22 am **Posts:** 4

so have you find any way to bypass this problem to functionnaly reach your original goal ?

mv2014 · **Joined:** Thu Sep 18, 2014 11:15 am **Posts:** 1

Hi,

I have encountered the same issue (v 4.2.12). There seem to be part of answer in that Hibernate ticket:

See the: Steve Ebersole added a comment - 22/Oct/2009 15:53 PM

https://hibernate.atlassian.net/browse/HHH-3414

Basically HQL does not honor fetch-profiles.

Let me know if you have any other information regarding that please.

Thx