Hi experts,
I have two classes:
- Cat
- Person
A Cat has a reference to the following:
- Kittens
- PetStore
- ...
A Person has a cat
The from clause in my query:
first step:
Code:
...
from Cat as cat
left outer join cat.kittens as kittens
left outer join cat.petStore as petStore
left outer join petStore.....
...
No problem here, this works.
Next step, I want to join Person with cat.
Code:
...
from Person as per
right outer join per.cat as cat
left outer join cat.kittens as kittens
left outer join cat.petStore as petStore
left outer join petStore.....
...
This results in: java.lang.UnsupportedOperationException: join type not supported by OracleJoinFragment.
Is this normal or am I doing it wrong? And is there a workaround?
The mapping for the cat attribute on Person looks like this:
<many-to-one name="cat" column="CAT_ID" class="Cat" lazy="false"/>
Lennert