-
1. Re: Unexpected select object
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' -
2. Re: Unexpected select object
"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
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
