hi
bad thing to do performance wise,
if u have an index on the colmn eg the username and use this construction
then the index is not used and you end up with a table scan.
I think you can better "manage" it while inserting,
eg
class User {
private String userName;
public setUserName(String name) {
this.userName = name.toLowerCase();
}
...
}
and modify the query's
with
Criteria criteria = new Criteria();
criteria.addEqualTo("userName", name.toLowerCase());
...
Bram
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, August 08, 2003 5:16 PM
To: [EMAIL PROTECTED]
Subject: not case sensitve search in DB2
Hi,
has some body made an SqlGenerator Class that generates
a where claus like this:
select x,y,z from a where upper(z) like upper(?)
this is helpful if the database like claus is case sensitiv, like in oracle
or db2.
regards
Matthias Roth
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
