O, I see. We will rewrite query. Another question Is HQL may join entities only if there is a refference-way from one to another?
Thanks! On Sep 16, 11:17 pm, Fabio Maulo <[email protected]> wrote: > mmm the "path" mentioned in the exception message is not your property > called "Path" but: > left join Department <=== from where come Department ? it is a property of > what ? > The other error you will find is "on"; "on" is not HQL > The other strange thing is: :rootDepartmentPath2 + '%' ; why don't do it in > the parameter ? > > before say "We try to use HQL first time and found exception" perhaps would > be more productive to think : "We try to use HQL first time and perhpas we > have not studied it enough". > > > > On Thu, Sep 16, 2010 at 1:08 PM, alexey_baranov <[email protected]> wrote: > > Hello! > > > We try to use HQL first time and found exception. What does this "Path > > expected for join!" means ? Path is a string not null property. Wwe > > try to use this HQL to find Persons within Department rootDepartment > > and not in subdepartments. > > > Path expected for join! [ > > select p > > from > > Helpdesk.Person p > > left join Department d on p.Path like d.Path + > > cast(d.Id as String) + '/%' > > where > > p.Path like :rootDepartmentPath2 + '%' > > and d.Path like :rootDepartmentPath2 + '%' > > and d is null > > ] > > > Thanks. > > > -- > > You received this message because you are subscribed to the Google Groups > > "nhusers" group. > > To post to this group, send email to [email protected]. > > To unsubscribe from this group, send email to > > [email protected]<nhusers%[email protected]> > > . > > For more options, visit this group at > >http://groups.google.com/group/nhusers?hl=en. > > -- > Fabio Maulo -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
