I'm having difficulties getting a portion of my WHERE clause to be case
insensitive with Oracle, and I'm wondering if this problem's been solved
already.
I've tried Criteria.setIgnoreCase(true), which forces all parts of the
WHERE clause to ignore case, and I've tried
Criterion.setIgnoreCase(true), which does absolutely nothing (does this
work with other databases???).
I've also tried the custom route: Criteria.add(columnName,
"UPPER("+columnName+") = " + someValue.toUpperCase()). But this is
inherently dangerous when the value (someValue) is coming from an end
user. (May allow users to execute arbitrary SQL.)
What I want is something which results in the left half being converted
to upper case and the right half still using a bind variable:
UPPER(columnName) = ?
Anyone know if this is possible? I'm using the latest version (3.2).
Thanks.
-rob
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
