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
Note: See
TracTickets for help on using
tickets.
You may also have a look at Agilo extensions to the ticket.
Just ran into this again, after I put a query parameter in quotes:
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.