Hibernate Community • View topic

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

HQL question

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

remasuri123

Post subject: HQL question

Posted: Fri Jul 02, 2004 4:06 am

Newbie

Joined: Tue Feb 24, 2004 8:08 am
Posts: 4

hi

i have a class Image and a class Repository. Repository has List of Images mapped as many-to-many. all works fine ... but ... i dont know how to query for all Repositories containing a specific image ?

can somebody help me translate the this into HQL ?

Code:

Image img = someMethodToGetAnImage();
List reps = s.find("all instances of Repository that are referencing img");

(currently my underlying DB is MySQL 4, im using latest hibernate release)

thanks

rema

Top

steve

Post subject:

Posted: Fri Jul 02, 2004 4:14 am

Hibernate Team

Joined: Tue Aug 26, 2003 3:00 pm
Posts: 1816
Location: Austin, TX

select r from Repository as r join r.images as i where i.id = :imageId

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