[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
Re: [eclipselink-users] What is wrong with this JPQL Query ?
|
Thanks Tom and Chris,
I was wondering why the query was working in SQL and and failing in JPQL; I think I got carried away with SQL way of making joins.
Thanks and Regards,
Samba
On Wed, Jun 2, 2010 at 8:06 PM, Christopher Delahunt
<christopher.delahunt@xxxxxxxxxx> wrote:
The exception states it cannot find a path for the join statements. In your first subselect, you have "
join Csresourcerolepermassign rrp join Csresource rs join Csresourcetype rt " which is incorrect - they need paths to define how to do the join, much like you did in the previous join statements such as join u.csRoles rl
Best Regards,
Chris
On 02/06/2010 10:29 AM, Samba wrote:
Hi,
I'm facing some issues with the following query:
select operation from Csoperation operation where
operation.id not in ((select rs.nativeid from CsUser u join u.csRoles rl join Csresourcerolepermassign rrp join Csresource rs join Csresourcetype rt where
u.id=(select
user.id from CsUser user where user.loginName=:userLogin) and
rt.name='operation' and rrp.permissions=(select p.value from Cspermission p where
p.name='view')));
I'm getting the following the messages in the log :
-------------------------------------------------------------------------------------------------
Path expected for join!
Invalid path: 'rs.nativeid'
Invalid path: 'rt.name'
<AST>:0:0:unexpected end of subtree
left-hand operand of a binary operator was null
Invalid path: 'rrp.permissions'
<AST>:0:0:unexpected end of subtree
left-hand operand of a binary operator was null
the invalid paths referred in the error messages were present as fields in the respective entities.
-----------------------------------------------------------------------------------------------------------------------------------------------------------
Can some one tell me if I'm doing some thing wrong here?
Thanks and Regards,
Samba
_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users