SCJD 1.4<br />SCJP 1.4<br />-----------------------------------<br />"With regard to excellence, it is not enough to know, but we must try to have and use it.<br />" Aristotle
Well
"select d.module from PermissionDefinition d left outer join fetch d.module where d.module.moduleId = 1 "
"SELECT d.module"
Where are you selecting "D" by itself. If you just want the module, then you don't even need a join, query on the module and not the PermissionDefinition.
I think the query might be backwards here. So the error you get is because it is looking for you to "select d". "d being the owner of the query.
Mark
SCJD 1.4<br />SCJP 1.4<br />-----------------------------------<br />"With regard to excellence, it is not enough to know, but we must try to have and use it.<br />" Aristotle
Try just
"Select d" ... in your query.
SCJD 1.4<br />SCJP 1.4<br />-----------------------------------<br />"With regard to excellence, it is not enough to know, but we must try to have and use it.<br />" Aristotle
SCJD 1.4<br />SCJP 1.4<br />-----------------------------------<br />"With regard to excellence, it is not enough to know, but we must try to have and use it.<br />" Aristotle
SCJD 1.4<br />SCJP 1.4<br />-----------------------------------<br />"With regard to excellence, it is not enough to know, but we must try to have and use it.<br />" Aristotle
Don't get me started about those stupid light bulbs. |