Hi!
We are using Entity beans and their finder methods for initiating different searches through the Database -- Oracle. The beans are in Web Logic 5.1. The users enter data in JSPs. The problem is the user is allowed to enter in upper and lowercase. The search should also respect the case and find the data accordingly; i.e. if user enters "usa", bean-finder method should search ONLY for "usa" and not for "usa" and "USA". How can I make the finder methods in Entity Beans to respect the case and search accordingly.
Thanks for all help beforehand,
Regards,
Baivab
-
Not case-sensitive search through Entity Beans Finder methods (2 messages)
- Posted by: Baivab Mitra
- Posted on: June 05 2001 07:07 EDT
Threaded Messages (2)
- Not case-sensitive search through Entity Beans Finder methods by Jayakumar Gopalan on June 08 2001 07:35 EDT
- Not case-sensitive search through Entity Beans Finder methods by Omar Abu-jiab on June 11 2001 05:38 EDT
-
Not case-sensitive search through Entity Beans Finder methods[ Go to top ]
- Posted by: Jayakumar Gopalan
- Posted on: June 08 2001 07:35 EDT
- in response to Baivab Mitra
SQL is not case sensitive and also Oracle. So even if you write a BMP and provide your own SQL query, when it is executed by the Oracle, it will do case-Insensitive search only. So you can't achieve Case-Sensitive searches in database. Correct me if I am wrong. -
Not case-sensitive search through Entity Beans Finder methods[ Go to top ]
- Posted by: Omar Abu-jiab
- Posted on: June 11 2001 05:38 EDT
- in response to Baivab Mitra
you can write a helper class - i know it is not that great ,and but it in you session facade where it could varify the proper entity bean of you choice.
i hope it is helpfull.
regards;
omar abu-jiab.