Hibernate Community • View topic - Help !!! cannot run named queries

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Help !!! cannot run named queries

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

nil_ban

Post subject: Help !!! cannot run named queries

Posted: Thu Nov 17, 2005 8:53 am

Newbie

Joined: Tue Oct 18, 2005 2:51 am
Posts: 14
Location: Chennai, India

Hi everybody,

I got into a problem. Must be a silly one. But I am not getting the answer anywhere and I need it urgently.

Problem
I have a named sql query (which has columns from multiple tables) and I want to put the results in a class. But the class map is always asking for a table for a class.

How to solve it?

regards,
Neil

Top

anandbn

Post subject:

Posted: Sun Nov 27, 2005 2:43 pm

Regular

Joined: Wed May 05, 2004 3:41 pm
Posts: 118
Location: New Jersey,USA

You could so something like

Code:

select new Object(a.col1,b.col2)
from classA a
left join classB b
where b.col3=<some condition>

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