I want to return multiple values in my
EJB query. The query goes something like this:
SELECT SUM(s.sales) SUM(s.cancels) FROM accounts.
To implement this if I write as below:
Query query = _em.createNamedQuery("Accounts.findAccountData");
Now if I do query.getSingleResult(); how do i retrieve both the values since the ejb finder returns either a single object or a collection?.
Any help is much appreciated