The problem is that the original QL compiler which is the default one even now is based on SQL-89 joins. Now try to come up with an SQL for you EJBQL query using SQL-89.
You have to solutions: 1. use DISTINCT. Result should be correct but the SQL query would be inefficient. 2. use SQL92 compiler in 3.2.4 like this | <jbosscmp-jdbc> | <defaults> | <ql-compiler>org.jboss.ejb.plugins.cmp.jdbc.EJBQLToSQL92Compiler</ql-compiler> | </defaults> | ... | View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3837806#3837806 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3837806 ------------------------------------------------------- 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
