Hibernate version: 3.1

Name and version of the database you are using: mysql 5


I have this great hql below. I want to also capture the distance being calculated as well. Currently the resultset is a Business object. Is there a simple way to do a alias or something and have the distance set on my Business object as well?

String hql = "from Business biz where biz.name like :criteria and "+
" acos( " +
" sin(:lat) * sin(biz.address.latitude) + " +
" cos(:lat) * cos(biz.address.latitude) * " +
" cos(biz.address.longitude - :lon) " +
" ) * 3956 < :distance order by biz.currentRating desc";

Query query = session.createQuery(hql)
.setInteger("distance", radius)
.setString("criteria", likeCriteria)
.setDouble("lat", targetZip.getLatitude())
.setDouble("lon", targetZip.getLongitude())
.setFirstResult(offset)
.setMaxResults(RESULTS_PER_PAGE);

<formula>

ahhhh yes ... I did see this briefly in the docs, this should work perfectly, thanks. I'll post my solution when complete.

Max I don't see how this helps. At first glance is sounds ok but this distance calculation is parameterized, it's based on second lat/lon pair. Neither formulas nor filters help me here. Any suggestions?

native sql query

Yes but I was hoping for something more elegant than this. Apparently this is my only choice.

Max can you show in a simple SQL query how I might get that calculated value into my business object?

thanks

See the solution here:

http://forum.hibernate.org/viewtopic.ph ... 14#2271614