[Hibernate] Oracle question

[Gavin K. <ga...@ap...>]

Does anyone know why the following query, which is good in DB2, is no good
in Oracle:

SELECT c.container_id FROM Simple sim2_, Container c, manyToMany man0_
WHERE (sim2_.count_=2 and man0_.elt=sim2_.id_ and
c.container_id=man0_.container_id2 and man0_.list_index=
(SELECT count(*) FROM manyToMany man1_ WHERE
c.container_id=man1_.container_id2)-1)

Hibernate generates that SQL for this query:

select c from c in class Container where c.manyToMany[ c.manyToMany.size -
1].count = 2



which is kinda useful.





Gavin