Hibernate Community • View topic - native queries with non-persisted values

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

native queries with non-persisted values

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

DoubleDenim

Post subject: native queries with non-persisted values

Posted: Wed Jan 05, 2011 3:37 pm

Newbie

Joined: Wed Jan 05, 2011 3:31 pm
Posts: 1

Note: this has been pasted from the jboss ejb3 forum on the suggestion of another member.

Hi There,

I am using the following to pull back a list of results and I am pushing the results into my Location class. This all works perfectly.

Code:

Query q = em.createNativeQuery("call mydb.FindLocationsByCoords("+lat+","+lng+","+radius+")", Location.class);
 
List<Location> results = q.getResultList();

Now I would like to add a property to the Location class for a value which isn't persisted but is returned by my stored proc. This value is "distance", and it represents a calculation in km's that the Location record is from the coordinates entered.

Can anyone please point me in the right direction as to how I might go about this?

Thanks
DD

Top

Page 1 of 1

[ 1 post ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum