0 Replies Latest reply on Jul 8, 2004 10:53 AM by ghoyle

    Help with an ejb-ql query

    ghoyle Newbie

      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