Hi There,

I'm wondering how to specify a one-to-many join annotation with a constant value. Here's an example of a query I'm trying to run that has this relationship:

SELECT * FROM CWO_TASK LEFT OUTER JOIN UOBJ_ALIAS ON UOBJ_ALIAS.PRIMARY_REF = 1 AND CWO_TASK.OBJ_ID = UOBJ_ALIAS.PARENT_OBJ_ID

I would want to put the relationship on the CWO_TASK entity.

Any ideas on this. I've seen this pagehttp://openjpa.apache.org/builds/2.2.2/apache-openjpa/docs/ref_guide_mapping_notes_nonstdjoins.html but when I deploy my JBoss server, I get an error.

Thanks,
N8