"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

Reply via email to