The SQL92 EJB-QL compiler generated invalid SQL from a finder. The finder is:
SELECT OBJECT(i) FROM Item i WHERE i.folder.project.path = ?1 AND i.folder.path = ?2 AND i.name = ?3 AND i.deleted = FALSE The SQL generated is: SELECT t0_i.id, t0_i.name, t0_i.title, t0_i.type_id, t0_i.version, t0_i.date_created, t0_i.date_last_modified, t0_i.is_deleted, t0_i.last_modified_by_id, t0_i.created_by_id, t0_i.folder_id FROM item t0_i LEFT OUTER JOIN folder t2_i_folder ON t0_i.folder_id=t2_i_folder.id LEFT OUTER JOIN project t1_i_folder_project ON t0_i.project_id=t1_i_folder_project.id WHERE t1_i_folder_project.path = ? AND t2_i_folder.path = ? AND t0_i.name = ? AND t0_i.is_deleted = FALSE The error that follows is: java.sql.SQLException: ERROR: No such attribute t0_i.project_id The 3 tables involved are: item (id, name, title, ..., folder_id) folder (id, path, title, ..., parent_folder_id, project_id) project(id, path, title, ..., parent_project_id) The SQL should have t0_i.project_id replaced with t2_i_folder.project_id View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3839467#3839467 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3839467 ------------------------------------------------------- This SF.Net email sponsored by Black Hat Briefings & Training. Attend Black Hat Briefings & Training, Las Vegas July 24-29 - digital self defense, top technical experts, no vendor pitches, unmatched networking opportunities. Visit www.blackhat.com _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user