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... View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3912527#3912527 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3912527 ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
