Is it possible to write an JPQL/HQL query that has entities *and* scalar values in the select clause?



So c.customerId is a scalar value and a is the Address entity. I'm assuming if this is legal, then the resultset is a List<Object[]> instance. correct?

I should just try it to see what happens...

That's right.
//somehow get the session.
List<Object[]> objects =session.createQuery("select c.customerId,
a
from Customer c,
Address a
where c.addressId = a.addressId").list();

where each object array will have
Object[0] --Long(assuming the customerId is mapped to Long.)
Object[1] -- Instance of Address.

-Srilatha.