[castor-dev] bug handling OQL date literals

[Sean Rohead]

I am trying to use a date literal in an OQL statement and it chokes on
oracle.

The where clause looks like this:

where expireDate > Date'1-28-2002'

I get an error from the oracle driver when I try to execute this because the
where clause of the query looks like:

WHERE ("BLAH"."EXPIRE_DATE" > '1-28-2002')

when for oracle it SHOULD BE > '28-Jan-2002' or the more portable JDBC
escape {d '2002-01-28'}

Thanks,

Sean Rohead

----------------------------------------------------------- 
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
        unsubscribe castor-dev