I am assuming this is not possible because the ejbSelect methods can only return one value: a CMP field, a CMR field as a single entity or a group of CMR fields as a Collection. So, it doesn't seem logical to allow EJB-QL to return multiple fields from the SELECT.
Please correct if I am wrong, I haven't looked this up in the spec.
Please read the EJB-QL specs. ****ONLY ONE **** cmp field can be returned from query. The return type of the SELECT clause can be one of the following: 1. The abstract schema of the entity bean that contains the select method. 2. The abstract schema of a related entity bean. 3. A persistent field
I am wondering why will anybody select just one field, when YOU can get whole LocalPerson interface object.
"Twenty years from now you will be more disappointed by the things that you didn't do than by the ones you did. So throw off the bowlines. Sail away from the safe harbor. Catch the trade winds in your sails. Explore. Dream. Discover." - Mark Twain