Hibernate Community • View topic - select 1 from .... HQL query gives undefined alias exception

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

select 1 from .... HQL query gives undefined alias exception

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

sekharsp

Post subject: select 1 from .... HQL query gives undefined alias exception

Posted: Sat Aug 30, 2008 8:55 am

Newbie

Joined: Sat Aug 23, 2008 1:30 pm
Posts: 4

Hi ALL ,

I get hibernate error “undefined alias”

org.hibernate.QueryException: undefined alias: 1

Can any one tell me wats wrong in the HQL query?

HQL QUERY :

select distinct mct.num ,

mct.iss ,

mct.ch,

mct.date ,

mpl.add ,

mct.jal,

mct.ref,

mpl.spons from

DTO1 mpl, DTO2 maa, DTO3 mct

where mct.add = maa.add and

maa.add = mpl.add and

mpl.spons = ‘TT’ and mct.num= 1231 and

not exists ( select 1 from DTO4 mtp WHERE mtp.jal = mct.jal )

Please let me know if you have any pointers.

Top

bmc

Post subject: Re: select 1 from .... HQL query gives undefined alias excep

Posted: Mon Sep 01, 2008 4:08 am

Newbie

Joined: Mon May 29, 2006 7:37 am
Posts: 4

Hi,
AFAIK there is no such ability to specify "pagination" is HQL. I.e. your code

Code:

select 1 from DTO4 mtp WHERE mtp.jal = mct.jal

is database-specific SQL, not HQL.

You could try to use SQL query.

Top

Page 1 of 1

[ 2 posts ]

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