Hi I have a problem getting it to leave the SQL query alone. My best guess is that Hibernate wants to interpret the colon like it does with a Hibernate Query. My question is whether or not there is a way of getting it to treat the colon as a colon and not some special character?

Hibernate version: 3.0

Mapping documents: made from scratch like a geico quote?

Code between sessionFactory.openSession() and session.close(): yes

Name and version of the database you are using: Oracle 9i

Hibernate code:
Iterator i = session.createSQLQuery("SELECT " +
" TO_CHAR (rcpt_date, 'mm/dd/yyyy hh24:mi:ss') received," +
" TO_CHAR (rlsd_date, 'mm/dd/rrrr hh24:mi:ss') released," +
" TO_CHAR (shpd_date, 'mm/dd/rrrr hh24:mi:ss') shipped" +
" FROM aTable" +
" WHERE documentNumber LIKE " + 'SOMETHINGOROTHER%'")
.addScalar("RECEIVED", Hibernate.STRING)
.addScalar("RELEASED", Hibernate.STRING)
.addScalar("SHIPPED", Hibernate.STRING)
.list().iterator();

The generated SQL (show_sql=true):
SELECT
TO_CHAR (rcpt_date, 'mm/dd/yyyy hh24?') received,
TO_CHAR (rlsd_date, 'mm/dd/rrrr hh24?') released,
TO_CHAR (shpd_date, 'mm/dd/rrrr hh24?') shipped,
FROM aTable
WHERE documentNumber LIKE 'SOMETHINGOROTHER%'

The SQL I want:
SELECT
TO_CHAR (rcpt_date, 'mm/dd/yyyy hh24:mi:ss') received,
TO_CHAR (rlsd_date, 'mm/dd/rrrr hh24:mi:ss') released,
TO_CHAR (shpd_date, 'mm/dd/rrrr hh24:mi:ss') shipped,
FROM aTable
WHERE documentNumber LIKE 'SOMETHINGOROTHER%'

I've gone through the parse code and I don't see support for escape characters. However you can get around it by making the pattern bit ('mm/dd/yyyy hh24:mi:ss') into a positional or named parameter, because there's no recursion in parsing:

use parameters as suggested - also generally more safe and efficient.

Tenwit,
Thanks for the swift reply. Thanks for checking to see if there was a valid escape sequence. I'll go with your suggestion.