Hi all,

Wondering if someone can help. I have three classes: ClassA, ClassB, and ClassC. ClassB has two one-to-many relationships: one with ClassA and one with ClassC. I'm trying to execute HQL that resembles the following:



In the query, objectB is of type ClassB.

Now, ClassA has a constructor defined as: ClassA(ClassB, double), which I'm trying to call with this query. Unfortunately, it fails with a SQL exception because the generated SQL SELECT contains all of the properties of ClassB, but the GROUP BY contains only the ID of ClassB.

My question is: How can I get this query to work? If I change the SELECT clause to select only the ID of objectB, then it still doesn't work because the constructor would need to take the ID as input rather than the entity object itself. (I want the object itself or at least a proxy.)

I'm using Hibernate 2.1.6. Any ideas?

Thanks.

you need to list all the properties on the object when doing this AFAIK

You mean in the GROUP BY clause? Ugh. That would not be fun because there are a lot of properties.

I guess I could remove ClassB from the constructor and have the query return tuples of the ClassA object and the ID of objectB. Then in my DAO, I could load and set the instacnes of objectB before returning a list of ClassA objects to the caller.

Is there an easier way?

Well, it seems my idea doesn't work. Apparently, if you use dynamic instantiation in a SELECT clause, the clause cannot contain any other items. I traced QueryHelper.renderSQL() and found that it looks for a constructor for all of the items in the SELECT clause, regardless of whether they are contained within the argument list of new ClassA(...). Looks like a bug to me.

no as far as i know...