Search:

Sorry should have clarified. This is the query for oracle only, you won't be able to get a cross-platform sql statement as the ANSI join syntax was only added to Oracle from version 9.

The SQL query for Oracle is:


SELECT CHILD.id, CHILD.object_identity, CHILD.acl_class, PARENT.object_identity as PARENT_OBJECT_IDENTITY FROM acl_object_identity CHILD, acl_object_identity PARENT...

If you knew there existed at least one B for each A then you could retrieve the entire graph with one query.


from B b join fetch b.a join fetch b.c

You are only allowed to eagerly fetch one...