aspose file tools *
The moose likes EJB and other Java EE Technologies and the fly likes Extract output of CreateNativeQuery Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "Extract output of CreateNativeQuery" Watch "Extract output of CreateNativeQuery" New topic
Author

Extract output of CreateNativeQuery

Juliana Steven
Greenhorn

Joined: Nov 08, 2009
Posts: 6
Hi,

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


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

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
Greenhorn

Joined: Nov 08, 2009
Posts: 6
I figured it out. This is what I needed to do in the for loop



Now I can access my elements!
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Extract output of CreateNativeQuery