Warning: Can't synchronize with repository "(default)" (/home/git/ome.git does not appear to be a Git repository.). Look in the Trac log for more information.
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"

Bug #1161 (closed)

Opened 15 years ago

Closed 15 years ago

"Invalid filter-parameter name format" thrown from HQL with colon in string

Reported by: jamoore Owned by: jamoore
Priority: major Cc: carlos@…, cxallan
Sprint: n.a.
Total Remaining Time: n.a.

Description

2009-02-01 22:58:36,743 INFO  [        ome.services.util.ServiceHandler] (l.Server-6)  Meth:    interface ome.api.IQuery.findAllByQuery
2009-02-01 22:58:36,743 INFO  [        ome.services.util.ServiceHandler] (l.Server-6)  Args:    [
             select l
             from DatasetImageLink dil
             join dil.child as i
             join i.annotationLinks as l
             join l.child  as a
             where a.ns='com.glencoesoftware.journal_bridge:part'
             and dil.parent.id=265
             and a.textValue='B : tiled imaged'
            , null]
2009-02-01 22:58:36,743 INFO  [         ome.security.basic.EventHandler] (l.Server-6)  Auth:    user=150,group=0,event=null(User)
2009-02-01 22:58:36,745 WARN  [        ome.services.util.ServiceHandler] (l.Server-6) IllegalArgumentException thrown.

java.lang.IllegalArgumentException: Invalid filter-parameter name format
        at org.hibernate.impl.SessionImpl.parseFilterParameterName(SessionImpl.java:1086)
        at org.hibernate.impl.SessionImpl.getFilterParameterValue(SessionImpl.java:1046)
        at org.hibernate.engine.QueryParameters.processFilters(QueryParameters.java:401)
        at org.hibernate.loader.Loader.processFilters(Loader.java:1595)
        at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1517)
        at org.hibernate.loader.Loader.doQuery(Loader.java:673)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
        at org.hibernate.loader.Loader.doList(Loader.java:2213)
        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
        at org.hibernate.loader.Loader.list(Loader.java:2099)
        at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
        at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
        at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
        at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
        at ome.services.query.Query.doInHibernate(Query.java:239)

Change History (2)

comment:1 Changed 15 years ago by jmoore

  • Milestone changed from OMERO-Beta4.1 to Future

comment:2 Changed 15 years ago by jmoore

  • Milestone changed from Unscheduled to OMERO-Beta4.1
  • Resolution set to fixed
  • Status changed from new to closed
  • Summary changed from "Invalid filter-parameter name format" thrown from HQL to "Invalid filter-parameter name format" thrown from HQL with colon in string

Just ran into this again, after I put a query parameter in quotes:

...where f.sha1 = ':sha1'

Pretty suitable and hard to find. All colons in strings must, presumably, be escaped. Probably not much we can do about this, but to document the fact.

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.64889 sec.)

We're Hiring!