[eclipselink-users] Customizing @ManyToOne?

[Laird Nelson <ljnelson@xxxxxxxxx>]

I have a VERY complicated join in a legacy database I can't change.  I would like a child object in this context to be able to navigate to his parent via a @ManyToOne operation.  However, there is no direct link from the child to the parent.  In SQL, I need to go through several INNER JOIN clauses to ultimately arrive at the proper destination.

How would I go about customizing this relationship in EclipseLInk?  Is there somewhere I can tell EclipseLink that when someone calls child.getParent() I would like it to run this large query instead?

I had a look at http://wiki.eclipse.org/Customizing_the_EclipseLink_Application_%28ELUG%29 but didn't really know what to look for.

Thanks,
Laird