Hi all
I currently have the problem that I get a "ParseException, Expecting AND OR..." with the following EJBQl statement on JBoss 3.2.3:
select object(rel) from Relationships rel WHERE rel.stSourceId = ?1 ORDER BY rel.stRelationshipId DESC, rel.stTimestamp DESC
1) Remove the ORDER BY bits - check this works
2) Create identical entry in jbosscmp-jbbc.xml (with ORDER BY), replacing 'ejb-ql' tag with 'jboss-ql'. Empty the 'ejb-ql' tag in ejb-jar.xml
Try again.
G'luck
tim