Hi everyone. I have two tables, say table1 and table2, with a one to many relation. Accordingly, the table1 java object has a Set of table2 elements, and the table2 object has one table1 object.

When I get a complete table1 object, with a query like this:



the object is retrieved with no problems, and it has its Set of table2 objects filled correctly.

But if I try to get just the Set of table2 objects this way:



then the query doesn't complete because it seems to enter an infinite loop.

Isn't that query the way to get just the Set of table2 objects?

Thanks in advance.

select elements(p.childs) from parent p where p.id=:id

Hi delpouve, thanks for your answer. I didn't have the code in front of me when I wrote the message so I wrote some sort of pseudocode, but in fact I was already using an alias for the table. I was making another mistake on my query which apparently caused the infinite loop.

But now I have another problem.

If I write:



Then I get a "parent" object with a Set of "child" objects inside. But if I write:



Then I get many "parent" objects (one for each child) with one "child" object, and I want a single "parent" object with a Set of "child" objects.

If I don't call the "elements()" function, I get an error executing the query, because Hibernate expects this function or "indices()".

I've also tried this:



with no luck.

How can I do what I want?

Thanks

Its a bit unclear what you want.

OK, I will try to explain it as clear as I can.

If I execute this:



The resulting list has one object of type "parent" which has a Set of N objects of type "child". N is the number of childs of the given parent.

If I execute this:



The resulting list has N arrays of 2 objects, the first one being the ID and the second one an object of type "child".

What I would want is that the resulting list had just one array of 2 objects, the first one being the ID and the second one a Set of N objects of type "child".

Sorry but I can't explain it better.

I would get the whole object using the first query, but the "parent" table is too big and I don't need all its fields.

The last thing I've tried is declaring a constructor like this:



and with a query like this:



but Hibernate tells me that "parent" class doesn't have the requested constructor.

This is not possible.

Thanks a lot, gavin, I thought it could be.