Hi all, I�m trying to do this with ejb-ql but I cannot get it works: 'SELECT DISTINCT a.phone_oper, a.oper_description FROM Dyt_orc_area_off_cSchema as a'
when I deploy the bean it drops: 12:25:53,522 ERROR [EntityContainer] Starting failed org.jboss.deployment.DeploymentException: Error compiling EJB-QL statement 'SELECT DISTINCT a.phone_oper, a.oper_description FROM Dyt_orc_area_off_cSchema as a'; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "," at line 1, column 29. Was expecting: "FROM" ... ) at org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.<init>(JDBCEJBQLQuery.java:46) at org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.createEJBQLQuery(JDBCComma ndFactory.java:53) If I get only 1 field it works. Is there any way to do what I want? Regards, Hern�n. ------------------------------------------------------- The SF.Net email is sponsored by EclipseCon 2004 Premiere Conference on Open Tools Development and Integration See the breadth of Eclipse activity. February 3-5 in Anaheim, CA. http://www.eclipsecon.org/osdn _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
