Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Tomcat Users List" <users@tomcat.apache.org>
Received-SPF: neutral (nike.apache.org: local policy)
Message-ID: <47210AEF.1070402@christopherschultz.net>
Date: Thu, 25 Oct 2007 17:30:23 -0400
From: Christopher Schultz <chris@christopherschultz.net>
User-Agent: Thunderbird 2.0.0.6 (Windows/20070728)
MIME-Version: 1.0
To: Tomcat Users List <users@tomcat.apache.org>
Subject: Re: JDBC Realm with case insensitive user name
References: <4720941A.2050508@gmail.com>
In-Reply-To: <4720941A.2050508@gmail.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Pedro,

Pedro wrote:
> I basically need to implement case insensitive user names, can this be
> done with a servlet filter or do I need to subclass JDBC realm:

Er, before you get too far on this, check to see if your database
already does this without you realizing that it does.

For instance, MySQL does case-insensitive VARCHAR and CHAR lookups
unless the column type is marked BINARY or you cast the type to BINARY
in your SQL query.

For instance, 'chris' = 'CHRIS' in MySQL inder normal circumstances.

Primary and unique keys respect this behavior, too, so I can't have
"chris" and "CHRIS" as two separate usernames in my user table where
"username" is a UNIQUE key.

You might be able to save yourself a lot of trouble.

- -chris

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFHIQru9CaO5/Lv0PARAkV6AJ9eBvJFTb8HCA5lL/6iU17AVF4DyQCgoDWg
TA5RHoInDsnxkDSqILJiYvI=
=J3qJ
-----END PGP SIGNATURE-----

---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org