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
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
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,
I have a primary key which is a string (user's name), and I would like
it to be case-insensitive. That is, if there is already a "bob" entity,
trying to create a "Bob" entity should throw a DuplicateKeyException.
Is there a way I can do this with Orion?
I vaguely recall reading something in
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