1 Reply Latest reply on Mar 20, 2006 10:52 AM by Jason Cunningham

    EJB query language problem with NOT MEMBER OF

    Nicola Segata Newbie

      Hi,
      I have a problem with the following finder:

      SELECT OBJECT(s)
      FROM Survey AS s, User AS u
      WHERE u.username = ?1
      AND u NOT MEMBER OF s.user


      Survey and User are Entity Bean in relation N-to-N with a dedicated Cross Table and the relation works fine (for examples getting UserDTOP from SurveyDTO, ... )

      At runtime the finder throws this exception:
      Code:

      javax.ejb.FinderException: Find failed: java.sql.SQLException: Unknown table 't3_s_user_RELATION_TAB
      LE' in where clause.


      In my database I don't have t3_s_user_RELATION_TABLE and I don't know the meaning of this table and why it must exist... looking at the EJB query language specifications there are no references to such a tables.

      I develop the EJB with JBuilder 2006, with JBoss 3.2.3.

      Any ideas?

      Thank you in advance for your responses...