Bugs item #559024, was opened at 2002-05-22 06:13 You can respond by visiting: http://sourceforge.net/tracker/?func=detail&atid=376685&aid=559024&group_id=22866
Category: JBossCMP Group: v3.0 Rabbit Hole Status: Open Resolution: None Priority: 5 Submitted By: Henk Laracker (hlaracker) Assigned to: Nobody/Anonymous (nobody) Summary: Converting EJB-ql to SQL goes wrong Initial Comment: I'am using version 3.0 RC3 jdk 1.4,windows 2000 The ejb statement is : select object(o) from TaskDB as o where (o.relWaDB.relCodesDB.code = ?1 or o.relWaDB.code = ?1) the sql statement generated by jboss is : SELECT t0_o.syscode FROM TASK t0_o , WA t2_o_relWaDB , CODES t1_o_relWaDB_relCodesDB WHERE t1_o_relWaDB_relCodesDB.code = ? OR t2_o_relWaDB.code = ? AND ( t0_o.wa_syscode=t2_o_relWaDB.syscode AND t2_o_relWaDB.project_syscode= t1_o_relWaDB_relCodesDB.syscode) The braces in the ejb-ql statement are not present in the sql statement. This results in a different result then expected. What do i have to do the get the braces in the sql statement? ---------------------------------------------------------------------- You can respond by visiting: http://sourceforge.net/tracker/?func=detail&atid=376685&aid=559024&group_id=22866 _______________________________________________________________ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
