query list casting help needed

m2m · **Joined:** Thu Aug 07, 2008 4:35 pm **Posts:** 9

I'm using

Code:

...
Query q =  (Query) getSession().createSQLQuery(query);
return q.list();

This is returning a Long "id" column and a Float "distance" column.

I'm getting a casting exception when trying to get the results from that list. How can i get at the id of lets say index 2? What should i cast this list object as?

Thanks

sethrohit1977 · **Joined:** Mon Jan 22, 2007 10:32 am **Posts:** 101

I am not very sure what you are asking for but I guess you are asking for casting to get a rows from a result set having multiple columns

int cntr = 0;
Object[] objArr = (Object[])resultList.get(cntr);
Long id = (Long)objArr[0];
Float distance = (Float)objArr[1];

jpkrohling · **Posted:** Fri Aug 08, 2008 4:16 am

What is the query you are using?

m2m · **Joined:** Thu Aug 07, 2008 4:35 pm **Posts:** 9

thanks sethrohit, that worked..
turns out the long id came back as a BigInteger.