Values beginning with colon treated as named parameters?

Harel · **Joined:** Tue Jun 22, 2004 7:42 pm **Posts:** 1

Quote:

select x from fmc_web.pool.Pool x left join x.containers c0 where (upper(x.name) = upper(':') and c0.id = 1)

The HQL above fails with the error "Not all named parameters have been set".

This is because the ':' is interpreted as the start of a named parameter. There seems to be no way to 'escape' the colon to make Hibernate treat it like a regular character.

Is this a bug in Hibernate, or are we just not good enough at reading the documentation?

gavin · **Posted:** Tue Jun 22, 2004 9:13 pm

I'd call that a bug ;)

Please submit it to JIRA. Thanks.

RedWolf · **Joined:** Tue May 10, 2005 2:22 pm **Posts:** 10

I'm using 3.0 and I need to be able to escape the leading colon in the where clause of an HQL statement. I've tried \: and :: but those don't work although the following post seems to indicate those escape sequences should work:

http://opensource.atlassian.com/project ... se/HB-1042

RedWolf · **Joined:** Tue May 10, 2005 2:22 pm **Posts:** 10

Before someone replies that I can "simply" use named parameters, I will add that that solution is non-trivial in my situation. I'm dynamically building a query that involves multiple optional sub-queries and it would mean major changes to the code. It would be so much simpler in my case if I could just escape the colon. My WHERE clause with the colon is similar to:

WHERE upper(last_name) like ':%'

ranjee29 · **Joined:** Wed Jul 26, 2006 9:53 pm **Posts:** 16

I am facing a similar problem, I cannot use named parameters as the query string is dynamically generated.
Even thougha lot places I read that this has been fixed for HB3 but I am using 3.0.5 and it doesnt seems to be working.
has this been resolved in 3.2???

max · **Posted:** Tue Oct 17, 2006 3:21 am

why don't you just try ? :)

gokusandwich · **Joined:** Tue Oct 31, 2006 12:32 pm **Posts:** 1

Escaping colons seems to be possible, in at least version 3.0.5, by using a double colon ("::"). Using a regular escape character for the colon does not seem to work. So,

Code:

FROM User u WHERE lower(u.name) LIKE '%!:%' ESCAPE '!'

does not seem to do the trick.