Hibernate Community • View topic - Need help expressing this SQL in HQL

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Need help expressing this SQL in HQL

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

hibernate2008

Post subject: Need help expressing this SQL in HQL

Posted: Tue Jun 03, 2008 3:14 pm

Newbie

Joined: Wed Apr 02, 2008 2:25 pm
Posts: 6

Hi,

Please help me convert this query into HQL:

Code:

select * from properties p inner join property_values v
  on p.id=v.property_id
    left outer join property_mappings m
      on (v.id=m.property_value_id and m.property_mapping_group_id=?);

I tried the following, but looks like HQL doesn't use on in its join syntax

Code:

from Property p join p.values as v left outer join v.mappings as m on m.propertyMappingGroupId=:propertyMappingGroupId

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