Hi,

I have the following set of classes
A extends B (joined-subclass in hibernate)

the foll query..
select a.*, b.* from B b inner join A a on a.id = b.id
query.addEntity("b",B.class);

yields the desired result..

however, setting setFirstResult and setMaxRows screws up everything.. Is this a bug or am I doing something wrong? Can anyone please help out with this?

Thanks..

Solved - I can manipulate the generated query as follows...
With X as (
select row.rownum_ b.* from ....
all row num stuff blah blah
) base
select a.*, b.* from base..

So now, I can put in parallel hints and use ORM for this native query..