Alexey, I tried using the <ql-compiler>org.jboss.ejb.plugins.cmp.jdbc.EJBQLToSQL92Compiler</ql-compiler> setting, but it seems to cause problems.
For a query defined as : | SELECT OBJECT(o) FROM Weight o | WHERE ( o.sale.client.traceId = ?1 ) AND ( o.sale.date = ?2 ) AND ( o.unidModificationDate >= ?3 ) | ORDER BY o.unidModificationDate LIMIT ?4 | In this table "sale" is of type WeightGroup (CMR), in in WeightGroup, "client" is of type "Company" (CMR) It generates the following SQL code (field replaced by *) : | SELECT * FROM T_WEIGHT t0_o | LEFT OUTER JOIN T_WEIGHTGROUP t2_o_sale ON t0_o.f_Sale_UOID=t2_o_sale.UNID_UOID | LEFT OUTER JOIN T_COMPANY t1_o_sale_client ON t0_o.f_Client_UOID=t1_o_sale_client.UNID_UOID | WHERE (t1_o_sale_client.f_TraceId = ?) AND (t2_o_sale.f_Date = ?) AND (t0_o.UNID_MODIFIED >= ?) ORDER BY t0_o.UNID_MODIFIED ASC | This is wrong in that the second "left outer join" "skips" a related table, by referencing "t0_o.f_Client_UOID" which should be "t2_o.f_Client_UOID" causing an SQLException because the f_client_uoid does not exist in the t_Weight table. Joachim View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3838139#3838139 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3838139 ------------------------------------------------------- This SF.Net email is sponsored by: GNOME Foundation Hackers Unite! GUADEC: The world's #1 Open Source Desktop Event. GNOME Users and Developers European Conference, 28-30th June in Norway http://2004/guadec.org _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
