iam using oracle database.
i want to do case insensitve operation.
suppose in ejbcreate i have username has a primary key field.
if i have one record in database table with user name as "hari" and if i try to create another record with the same user name "Hari"(here in this case H is capital letter) it should through create exception.
how to achieve this in ejbcreate itself, instead of doing first ejbfindbyprimarykey(username) and then ejbcreate.
thanks
hari