Notice: In order to edit this ticket you need to be either: a Product Owner, The owner or the reporter of the ticket, or, in case of a Task not yet assigned, a team_member"

Task #12122 (new)

Opened 6 years ago

RFE: query service handling of bytea DB columns

Reported by: mtbcarroll Owned by: jamoore
Priority: minor Milestone: Unscheduled
Component: Services Version: 5.0.0
Keywords: n.a. Cc: omero-team@…
Resources: n.a. Referenced By: n.a.
References: n.a. Remaining Time: n.a.
Sprint: n.a.

Description

$ bin/omero hql --limit 1 'select params from ParseJob'
Using session 0b9d8ca4-a208-4f28-8fff-51ba6deb1e18 (root@gretzky.openmicroscopy.org.uk:4064). Idle timeout: 10.0 min. Current group: read-only-1
Traceback (most recent call last):
  File "/home/mtbc/src/openmicroscopy/dist/bin/omero", line 125, in <module>
    rv = omero.cli.argv()
  File "/home/mtbc/src/openmicroscopy/dist/lib/python/omero/cli.py", line 1197, in argv
    cli.invoke(args[1:])
  File "/home/mtbc/src/openmicroscopy/dist/lib/python/omero/cli.py", line 745, in invoke
    stop = self.onecmd(line, previous_args)
  File "/home/mtbc/src/openmicroscopy/dist/lib/python/omero/cli.py", line 814, in onecmd
    self.execute(line, previous_args)
  File "/home/mtbc/src/openmicroscopy/dist/lib/python/omero/cli.py", line 894, in execute
    args.func(args)
  File "/home/mtbc/src/openmicroscopy/dist/lib/python/omero/plugins/hql.py", line 44, in __call__
    self.hql(args)
  File "/home/mtbc/src/openmicroscopy/dist/lib/python/omero/plugins/hql.py", line 66, in hql
    rv = self.project(q, args.query, p, ice_map)
  File "/home/mtbc/src/openmicroscopy/dist/lib/python/omero/plugins/hql.py", line 221, in project
    rv = querySvc.projection(queryStr, params, ice_map)
  File "/home/mtbc/src/openmicroscopy/dist/lib/python/omero_api_IQuery_ice.py", line 237, in projection
    return _M_omero.api.IQuery._op_projection.invoke(self, ((query, params), _ctx))
omero.ApiUsageException: exception ::omero::ApiUsageException
{
    serverStackTrace = 
    serverExceptionClass = 
    message = Unsupported conversion to rtype from [B:[B@7c5ad1fa
}

It is probably worth rethinking how byte array values are handled through RType and bin/omero hql.

Change History (0)

Note: See TracTickets for help on using tickets. You may also have a look at Agilo extensions to the ticket.

1.3.13-PRO © 2008-2011 Agilo Software all rights reserved (this page was served in: 0.74750 sec.)

We're Hiring!