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:
javax.ejb.FinderException: Find failed: java.sql.SQLException: Unknown table 't3_s_user_RELATION_TABLE' in where clause.
In my database I don't have t3_s_user_RELATION_TABLE, but 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...