Hibernate Community • View topic - native SQL queries in hibernate don't work when using alias

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

native SQL queries in hibernate don't work when using alias

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

jainanuj82

Post subject: native SQL queries in hibernate don't work when using alias

Posted: Wed Jun 22, 2011 2:02 am

Newbie

Joined: Mon Oct 11, 2010 3:44 am
Posts: 2

I have a problem :

if you do something like this:

Code:

select 
oldForm.data as oldData
newForm.data as newData
from 
form oldForm,
join form newForm on oldForm.replaced_by_id = newForm.id

then use entityManager.createNativeQuery(sql).getResultList()

it will end up with an error that says column named oldData does not exist. If you take out the aliases, then it will just return the first value for "data" for every column. If you run this through straight JDBC with the alias, it works as expected.

The same issue is given at http://opensource.atlassian.com/projects/hibernate/browse/HHH-4174

Is there a solution to it??
Thanks to help..its urgent..

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