We help IT Professionals succeed at work.

How to make cassandra DB as non sensitive while retrieve?

Hi ,

How to make cassandra DB as non sensitive, I am using  CassandraRepository and findby method to get the data

if i pass name =sathish but in DB name ="Sathish" it return null because of case sensitive.

I tried findByIgnorgeCase but it does not help me .

timing being i am inserting  data  with caps(touppercase) and retrieving caps
Comment
Watch Question

From what I've gleaned, Cassandra holds its entries in what amounts to lower case. So issue your query in lower case from Java using .toLowerCase().

Commented:
Sathish, is it possible for your to share code ?
Adding IgnoreCase in repository JPA method