How about changing your query to return the entire User object instead of just the ids? Maybe like this:
SELECT USR FROM USER USR, USERWATCH UW WHERE USR.ADDEDBYID =1 AND USR.COUNTRY = CAS | E WHEN (UW.COUNTRY is null) THEN USR.COUNTRY ELSE UW.COUNTRY END AND USR.ALIVE = 'A' See if that works. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4159291#4159291 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4159291 _______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user