RE: Case insensitive primary keys

2001-03-12 Thread KirkYarina
Add a finder (see the advanced finder section in the right-side menu at www.orionsupport.com ) Collection findIgnoringCase(String name) with a where clause of finder-method query="UPPER(table.name) = UPPER ( $1 )" If you have "Smith" and "smith" do you want them to be separate entities, or

RE: Case insensitive primary keys

2001-03-11 Thread Jeff Schnitzer
Thanks for everyone's comments. From: Rafael Alvarez [mailto:[EMAIL PROTECTED]] You can do two things: .- In the EJBCreate change the user name to Upper or Lower case when setting it. Also in the PK class change it to Upper or Lower case. Not a good solution for me, because I want to preserve

Re: Case insensitive primary keys

2001-03-09 Thread Rafael Alvarez
Hello Jeff, You can do two things: .- In the EJBCreate change the user name to Upper or Lower case when setting it. Also in the PK class change it to Upper or Lower case. .- Override the PK class equal() method, to compare the username in Upper(Lower)case. Thursday, March 08, 2001, 7:30:39 PM,

Re: Case insensitive primary keys

2001-03-08 Thread Patrick V. Madden
Can't you just take your input key in the ejb finder method and always convert it to lower case or uppercase. Then do your search. Do the same if you provide an ejb create method that takes a string. Just a quick thought. At 03:30 PM 3/8/2001 -0800, Jeff Schnitzer wrote: I have a primary key