Woodbridge, Mark R
m.woodbridge at imperial.ac.uk
Fri Nov 6 14:45:56 GMT 2009
Didn't help, unfortunately, but I can do it using sudo so no big problem. Perhaps something to look out for if you're using the API as the superuser.
From: Chris Allan [mailto:callan at lifesci.dundee.ac.uk]
Sent: 06 November 2009 14:37
To: Woodbridge, Mark R
Cc: ome-users at lists.openmicroscopy.org.uk
Subject: Re: [ome-users] QueryService
Have you tried "left outer join fetch"?
On 6 Nov 2009, at 14:29, Woodbridge, Mark R wrote:
> Well, yes. The actual code I'm running is:
> IObject image = factory.getQueryService().findByQuery("select i from
> Image i join fetch i.pixels where i.id = :id", new
> ParametersI().add("id", rlong(id)));
> The problem is that it won't in a session owned by root (it returns
> the aforementioned error). It works fine in a session owned by the
> owner of the image, but this means sudo-ing. Just wondered why I
> can't do it as the super user...
> -----Original Message-----
> From: Chris Allan [mailto:callan at lifesci.dundee.ac.uk]
> Sent: 06 November 2009 14:25
> To: Woodbridge, Mark R
> Cc: ome-users at lists.openmicroscopy.org.uk
> Subject: Re: [ome-users] QueryService
> Something that looks like this:
> Parameters p = new Parameters();
> List<Image = iQuery.findAllByQuery(select i from Image i join fetch
> i.pixels where i.id = :id);
> On 6 Nov 2009, at 14:02, Woodbridge, Mark R wrote:
>> I'm using the client API from Java to run the query:
>> select i from Image i join fetch i.pixels where i.id = :id
>> I'm doing this in order to get pixels IDs to pass to the thumbnail
>> service. When I run it as the OMERO super user I get the message:
>> "Null parameters not allowed: o_id"
>> I assumed that image Ids would be unique, but it looks like a need
>> to pass the ID of the owner, as well as the image ID. Is this
>> correct? Perhaps I have misunderstood...
>> ome-users mailing list
>> ome-users at lists.openmicroscopy.org.uk
More information about the ome-users