Hibernate version:
3.0

Name and version of the database you are using:
DB2 UDB for AS/400 05.02.0000 V5R2m0 AS/400 Toolbox for Java JDBC Driver 6.0

The generated SQL (show_sql=true):

Hi,

How do you escape colons (:) when using the createSQLQuery command?
Right now it is replacing the : with a ? in the string

for example:

sql = "select { tbl.* } from table1 where COL1 = 'THING: THANG'

Query query = session.createSQLQuery(sql, "tbl", MyClass.class);

the output is:
select tbl.COL1 as COL10_, tbl.COL2 as COL20_ from table1 tbl where COL10 = 'THING? THANG'

i tried using \ to escape it, but then i end up with:
select tbl.COL1 as COL10_, tbl.COL2 as COL20_ from table1 tbl where COL10 = 'THING\: THANG'

which is no good either

i searched the forums and jira and it seems this issue was addressed:
http://opensource.atlassian.com/project ... se/HB-1042

but it's does not seem to be working
any ideas?

thanks

how about using a parameter

This may Help for this Problem, but in general there is a need for escape character in general for Hibernate specific characters.

In this case colon ":",
in case of a SqlQuery it can happen that you need to wirte a specific Query which needs colons.

for example casting in Postgres:

A query like
"SELECT number::int4 From numbers "

is not performable (::int4 is for casting the Value to integer).

Of course there are workarounds, but such a query should be performable in Hibernate.

At present with hibernate3 it is not !

open a JIRA issue

Has the issue of escaping the colon character been resolved?

I am using Eclipse SDK
Version: 3.2.0
Build id: M20060629-1905

The SQLQuery statement for a native MSSQL 2005 I am trying to use is:

select top 10 MyTable.GUID as GUID0_ where MyTable.myDate < cast('2007/11/08 01:24:35' as datetime)

The Hibernate 3.2.0 translate it into:

select top 10 MyTable.GUID as GUID0_ where MyTable.myDate < cast('2007/11/08 01?' as datetime)

which of course failed the query.

Is this issue resolved?

Thanks for your help.
Shuh