Bugs item #626468, was opened at 2002-10-21 21:27 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=626468&group_id=22866
Category: JBossCMP Group: v3.0 Rabbit Hole Status: Open Resolution: None Priority: 5 Submitted By: Andrew (mr_dronski) Assigned to: Nobody/Anonymous (nobody) >Summary: ejb ql "IS NOT EMPTY" is not implemented Initial Comment: ejb 2.0 final spec, page 236, section 11.3.2 Find all orders that have line items: SELECT DISTINCT OBJECT(o) FROM Order o, IN(o.lineItems) l Note that the result of this query does not include orders with no associated line items. This query can also be written as: SELECT OBJECT(o) FROM Order o WHERE o.lineItems IS NOT EMPTY ===================================== those 2 queries are identical in meaning and the developer has a choice which way to write it. but the one with IS NOT EMPTY is giving a FinderException with a nested SQL exception: 19:10:35,461 ERROR [STDERR] javax.ejb.FinderException: Find failed: java.sql.SQLException: Missing relational operator at position 119. 19:10:35,477 ERROR [STDERR] at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(JDBCAbstractQueryCommand.java:1 48) 19:10:35,477 ERROR [STDERR] at org.jboss.ejb.plugins.cmp.jdbc.JDBCFindEntitiesCommand.execute(JDBCFindEntitiesCommand.java:40) 19:10:35,477 ERROR [STDERR] at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.findEntities(JDBCStoreManager.java:549) 19:10:35,477 ERROR [STDERR] at org.jboss.ejb.plugins.CMPPersistenceManager.findEntities(CMPPersistenceManager.java:348) the SQL error code is 10009. seems that there's an error in sql generator. ---------------------------------------------------------------------- >Comment By: Alexey Loubyansky (loubyansky) Date: 2002-11-13 21:38 Message: Logged In: YES user_id=543482 Please, check out a fresh JBoss version try your code. Similar bug 621270 was just fix. Let us know the results, please. alex ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=626468&group_id=22866 ------------------------------------------------------- This sf.net email is sponsored by: Are you worried about your web server security? Click here for a FREE Thawte Apache SSL Guide and answer your Apache SSL security needs: http://www.gothawte.com/rd523.html _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
