Hi,
I am having problems writing a ejb-ql query to based on a many to many relationship.
I have 2 entities: ClientDetails and the other is called TVBS
and there is a many to many relationship between them.
I want all of the TVBS's that a client has access too.
the ejb-relationship between them is called client-tvbs
The abstraact schema name for ClientDetails is clientdetails
and the abstract schema name for TVBS is tvbs
I would be passing in a userID to search on for the ClientDetails.
JBOSS does create the tables and a intermediatry table to resolve the many to many.
Any help with this would be most appreciated.
Thanks
G