cannot fetch multiple collections in one query???

orientphoebus · **Joined:** Thu Dec 02, 2004 10:42 am **Posts:** 54

I got this Exception when doing 2 join fetch for 2 collections of the class in Hql.
Then, trace the problem into Hql/QueryTranslator.cs, I found this code:

Code:

public void SetCollectionToFetch( string role, string name, string ownerName, string entityName )
      {
         if( fetchName != null )
         {
            throw new QueryException( "cannot fetch multiple collections in one query" );
         }
...
}

Compare it to source code of Hibernate 2.1.8, it doesn't have this limitation? Why needed for NHibernate? When I took it out, the compact I got is it can return duplicate objects, but that's usual thing for using Hql.

orientphoebus · **Joined:** Thu Dec 02, 2004 10:42 am **Posts:** 54

I try the code with this checking comment out.

Only the latest join fetched collection get initialized.

Is it a bug in Hibernate 2.1.8? Can we correct it here is NHibernate?

sergey · **Posted:** Thu Oct 06, 2005 6:01 am

Yes, that's a Hibernate 2.1 limitation. Not really easy to fix.

orientphoebus · **Joined:** Thu Dec 02, 2004 10:42 am **Posts:** 54

sergey wrote:

Yes, that's a Hibernate 2.1 limitation. Not really easy to fix.

May I ask what is NHibernate's remote plan to begin to move to Hibernate 3? Half year? 1 year or 2 ?

paulh · **Posted:** Thu Oct 06, 2005 10:28 am

I would guess work would start in the next month or two, but will be initially done against Framework 1.1 - I know 2.0 is now RTM, but I have projects which will need HIbernate 3.0 capabilities under 1.1 so that's where I'm going to start :D

Feel free to chip in with .NET 2.0 features in the code with conditional compilation - it's only going to affect a small number of areas I think.

orientphoebus · **Joined:** Thu Dec 02, 2004 10:42 am **Posts:** 54

This is great. I think I am going to stuck in .Net 1.1 for a while also, and there are lots of Hibernate3 features I'd like to have from NHibernate.

looking forward to it: :D