Bug #1161 (closed)
Opened 11 years ago
Closed 10 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 10 years ago by jmoore
- Milestone changed from OMERO-Beta4.1 to Future
comment:2 Changed 10 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.