Re: [eclipselink-users] What is wrong with this JPQL Query ?

[Christopher Delahunt <christopher.delahunt@xxxxxxxxxx>]

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