Hi all, How to write in EJB-QL the EXISTS statement in WHERE (like in SQL92)? For now it seems to me that it is not in the EJB-QL spec and JBoss-QL as well.
More general observation, which probably most of you can share: I've just started to be familiar wit JBoss and CMP and found that some very basic syntax of sql is not a part of EJB/JBoss-QL (exists, select inside 'in', just few sql functions implemeted). Many free java O/R mapping libraries (like castor, jonas CMP) have much more powerfull QL. Speaking frankly current EJB-SQL/JBoss-QL with its limitation is just a toy and the real job must be done in ugly sql. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3831548#3831548 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3831548 ------------------------------------------------------- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
