permaculture playing cards*
The moose likes Object Relational Mapping and the fly likes HQL join query not executing Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "HQL join query not executing" Watch "HQL join query not executing" New topic

HQL join query not executing

saravanan sambandam
Ranch Hand

Joined: Aug 30, 2010
Posts: 42
I have 3 tables

user_master : contain with user_id, user_name
group_master : contain with group_id, group_name
user_group : contain with user_group_id, group_id, user_id

SQL statment : select a.user_group_id, b.group_id, b.group_name from user_group a left outer join group_master b on b.group_id=a.group_id;
but when i am using HQL is not execute what i did the mistake? please let me know

This query is not executing please help me where i did the mistake.
Don't get me started about those stupid light bulbs.
subject: HQL join query not executing
Similar Threads
Convert SQL to Criteria please
@ManyToOne & @JoinColumn
Help me for Joinin two tables.
How to create .hbm.xml file for this table?
Help with HQL Insert and Joins using Hibernate 3 / JPA