-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 3 posts ] 
Author Message
 Post subject: outer join giving error
PostPosted: Mon Feb 14, 2005 7:49 am 
Newbie

Joined: Fri Feb 11, 2005 7:20 am
Posts: 18
when i use outer join am getting the following exception

org.hibernate.QueryException: outer or full join must be followed by path expression

any idea ???

_________________
Thanks in advance,
Lakshmi


Top
 Profile  
 
 Post subject:
PostPosted: Mon Feb 14, 2005 7:51 am 
Hibernate Team
Hibernate Team

Joined: Tue Sep 09, 2003 2:10 pm
Posts: 3246
Location: Passau, Germany
How should we ever answer such stuff if you don't even give us the query you try to execute?


Top
 Profile  
 
 Post subject: outer or full join error
PostPosted: Tue Aug 30, 2005 5:12 am 
Newbie

Joined: Tue Aug 30, 2005 5:02 am
Posts: 1
hi

example query for the above problem :

select dept0_.deptid as deptid0_, emps1_.empid as empid1_, dept0_.deptname as deptname0_, emps1_.empname as empname1_, emps1_.dept_deptid as dept_dep3_1_, emps1_.dept_deptid as dept_dep3___, emps1_.empid as empid__ from dept dept0_ left outer join emp emps1_ on dept0_.deptid=emps1_.dept_deptid where (dept0_.deptid=? )

here emp table contains dept_deptid as fk

i m also getting the same error as

net.sf.hibernate.QueryException: outer or full join must be followed by path expression [select dept0.deptid as deptid, emps.empid as empid, dept0.deptname as deptname, emps.empname as empname, emps.dept_deptid as emp_dept_depid, emps.dept_deptid as dept_dep3, emps1_.empid as empid from Dept dept0 left outer join Emp emps on dept0.deptid=emps.dept_deptid where (dept0.deptid='9')]

plz urgent reply to this
thnks


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 3 posts ] 

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

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.