Hibernate Community • View topic - Want to select list and one column using select query

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Want to select list and one column using select query

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

navnath

Post subject: Want to select list and one column using select query

Posted: Tue Apr 26, 2011 9:43 am

Newbie

Joined: Wed Jan 19, 2011 6:30 am
Posts: 10

HI All,

want to select list and one variable using select query

e.g.
select a.lstObject, b.name from Employee b, custObject a inner join a.lstObject
where b.id=?

getting Exception like

Code:

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'as'.

How do I write this query?

Thanx in advance.
Navnath Kumbhar.

Top

overmeulen

Post subject: Re: Want to select list and one column using select query

Posted: Tue Apr 26, 2011 10:04 am

Regular

Joined: Fri Jan 28, 2011 11:44 am
Posts: 117

Give an alias to a.lstObject and select this alias!

Top

navnath

Post subject: Re: Want to select list and one column using select query

Posted: Tue Apr 26, 2011 10:25 am

Newbie

Joined: Wed Jan 19, 2011 6:30 am
Posts: 10

Hi overmeulen,

it works...... :)

Thanx for your replay.

Top

Page 1 of 1

[ 3 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