Extract output of CreateNativeQuery

[Juliana Steven]

Hi,

I am working on a piece of code where the sql statement returns 2 fields. For e.g.

String sql = " select a.id, b.id from name_table a, address_table b where a.name = b.name and a.name = 'Sam'";
Query query = em.CreateNativeQuery(sql);
List<Object> resultList = query.getResultList();

Now resultList is comprised of Objects. Each Object has 2 attributes namely the ids which show up on Debug as BigDecimal or type Object. I tried giving a

for (Object result : resultList) {
}

to access the attributes, but am unable to do so.
How do I get the value of a.id and b.id in 2 separate variables from the Object result?

Any help would be appreciated.

Thanks Much,
Juliana

[Juliana Steven]

I figured it out. This is what I needed to do in the for loop

for (Object result : resultList) {
    Object[] r = (Object[] result;
    for (Object r1: r) {
        System.out.println(r1.toString());
    }

}

Now I can access my elements!