Bugs item #621270, was opened at 2002-10-10 15:07 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=621270&group_id=22866
Category: JBossCMP Group: v3.0 Rabbit Hole Status: Open Resolution: None Priority: 5 Submitted By: Alexei Yudichev (sflexus) Assigned to: Nobody/Anonymous (nobody) Summary: invalid SQL is generated for MSSQL Initial Comment: I have the following EJBQL expression: SELECT DISTINCT OBJECT(c) FROM StoreCategory c, IN (c.locales) l WHERE l.code=?1 AND c.images IS NOT EMPTY which for postgresql translates into: Executing SQL: SELECT DISTINCT t0_c.id FROM storecategory t0_c, mmslocale t1_l, storecategory_locales_m_18q3els t2_c_locales_RELATION_TABLE, mmsimage t3_c_images, mmsimage_storecategorie_1diogue t4_c_images_RELATION_TABLE WHERE (t1_l.code = ? AND TRUE) AND (t0_c.id=t4_c_images_RELATION_TABLE.StoreCategory AND t3_c_images.id=t4_c_images_RELATION_TABLE.MMSImage AND t0_c.id=t2_c_locales_RELATION_TABLE.StoreCategory AND t1_l.code=t2_c_locales_RELATION_TABLE.MMSLocale) and executes normally. But for MSSQL I get: SELECT DISTINCT t0_c.id FROM StoreCategory t0_c, MMSLocale t1_l, StoreCategory_locales_MMSLocale_storeCategories t2_c_locales_RELATION_TABLE, MMSImage t3_c_images, MMSImage_storeCategories_StoreCategory_images t4_c_images_RELATION_TABLE WHERE (t1_l.code = ? AND 1) AND (t0_c.id=t4_c_images_RELATION_TABLE.StoreCategory AND t3_c_images.id=t4_c_images_RELATION_TABLE.MMSImage AND t0_c.id=t2_c_locales_RELATION_TABLE.StoreCategory AND t1_l.code=t2_c_locales_RELATION_TABLE.MMSLocale) which leads to java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Line 1: Incorrect syntax near ')'. Why not using "AND 1=1" instead of "AND 1"? ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=621270&group_id=22866 ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
