Returning multiple values from HQL query

Question

I have the following HQL query:

SELECT ita.invoiceType, ita.agreementNumber, itr.ruleCategory 
FROM InvoiceTypeAgreements ita, InvoiceTypeRules itr 
WHERE ita.invoiceType = itr.invoiceType 
AND ita.agreementNumber IN (?1) 
AND itr.ruleCategory IN (?2)

I'm using query.getResultList() to get the values back from this. I assume it is returning an ArrayList<String[]> but whenever I try to access the String[]'s in the ArrayList<String[]> I get this error:

java.util.concurrent.ExecutionException: javax.ejb.EJBException:
java.lang.ClassCastException: [Ljava.lang.Object; cannot be cast to [Ljava.lang.String;

Is an ArrayList<String[]> not what the HQL query is returning?

Johanna · Accepted Answer · 2012-06-26 15:28:56Z

2

As you can see in the error message, you get List<Object[]> and not of String. The resulting values are not necessarily strings (perhaps they are in your example, but generally they aren't).

answered Jun 26, 2012 at 15:28

Johanna

5,3231 gold badge28 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Graham Over a year ago

I see. It needs to be an array of objects and then I need to cast each individual object a String. It works now. Thanks.

Collectives™ on Stack Overflow

Returning multiple values from HQL query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related