Hibernate Community • View topic - Return mapped object from CreateSQLQuery()

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Return mapped object from CreateSQLQuery()

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

ik6s

Post subject: Return mapped object from CreateSQLQuery()

Posted: Thu Dec 22, 2011 4:08 pm

Newbie

Joined: Thu Dec 22, 2011 3:57 pm
Posts: 1

I have the following code, but I cannot return a Projects object. I need to return a list of Projects objects from thsi query tho. How do I do that? I am new to hibernate, so please be thorough in your response.

Code:

Query q = session.createSQLQuery("select p.projectid, p.projecttitle, p.projectdescription from projects p join accounts a on p.accountid = a. accountid join addresses ad on ad.accountid = a.accountid where ad.zipcode=" + zipcode);

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