"waggj" wrote : Shouldn't there be an 'AS' in there? | 'SELECT DISTINCT u.clTitle FROM Unspsc AS u WHERE u.sgCode= ?1 AND u.faCode=?2 ORDER BY u.clCode'
I think that's not the problem... Actualy I solved the problem by removing these lines from JDBCEJBQLCompiler.java in jboss3.2.6RC1 snapshot anonymous wrote : | else | { | throw new IllegalStateException("Unexpected select object: " + selectObject); | } | and rebuilding jboss. The exception was thrown when the GROUP BY field wasn't found among the select fields. This shoud not be a limitation. regards View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3844897#3844897 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3844897 ------------------------------------------------------- SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift. http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user