Should ur query be
SELECT OBJECT(r) FROM Rest AS r, IN(r.restParts) rp WHERE rp.posting.id = 1
It doesn't help.
If I use rp.uuu where uuu is CMP not CMR field it's ok
Can u check if u have defined a CMR field called "posting" in ur ejb-jar.xml file?
Yes it's mentioned both in ejb-jar.xml and in jbosscmp-jdbc.xml