HI,

For an example i have a table tree whose primary key is referenced in many rows of table fruits. To get all the available trees left outer joined with fruits with weight say 10 gms i need to write this query.

My Approach:



The problem is that the query fails when there is a tree with 1 fruit of wt equal to 1 gms.

What i require is All trees irrespective of fruits & if there are fruits of wt 10 grams associate them also.

kindly help.

Ravi C

The documentation says that we cant use subselects in from clause. So how do we go about such cases?


Kindly help.

try this

from
trees t
left outer join t.fruits as fr
where
fr.weight=10

and in mapping of trees.hbm.xml
add this line :
<many-to-one name="fruits" class="fully qualified name of fruits class" column="trees_id" insert="false" update="false" />

and in Trees.java
add
private Fruits fruits; with its getter and setter.
you can put select clause also with its condition.

[rate, if helpful]

Thanks,
Gopal

Hi,

The query does not work please look into the initial posts. The same query is written.

Check this once carefully,
This is different from your query. and I can assure you that This ll work correctly, If you applies it correctly.

Thanks,
Gopal

Hmm, maybe this isn't the answer they're looking for, in the original post.....



Are they saying, the result set should be all trees, regardless of the weight of fruit, but also, if the weight of the fruit is 10 or greater then the related fruit entity should be populated too.

Sounds like a where clause controlling the fetch functionality? Don't know if that can be done?

Tom

Let me know what error are you getting ?

Thanks,
Gopal