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.
