How can I make case-insentitive using spring-data-jpa

Question

public interface XRepository extends JpaRepository<XEntity, Long> { 
Page<XEntity> findByParentIdAndNameContainingAndDescrContaining(Long parentId,String name, String descr, Pageable pageReq)
}

I'm writing. But it's case-sensitive. The result is wrong. How can I solve?

thank u, I put 'extends CrudRepository, JpaSpecificationExecutor'. this is working — Kübra, Jul 10 '19 at 10:55
`JpaSpecificationExecutor` doesn't have to do anything with case sensitivity — Mansoor Ali, Jul 10 '19 at 11:01
@Mansoor - it does, because `CriteriaBuilder` allows to transform `Path` to upper|lower case using its `upper()` and `lower()` methods. — t4dohx, Jul 10 '19 at 12:42

score 0 · Answer 1 · answered Jul 10 '19 at 10:50

0

Put IgnoreCase in the end of the method name.

answered Jul 10 '19 at 10:50

Guilherme Melo

209
3
13

score 0 · Answer 2 · answered Jul 10 '19 at 10:54

I usually write queries myself so I can better visualize what's going on.

public interface XRepository extends JpaRepository<XEntity, Long> {
    @Query("SELECT xe from XEntity xe where xe.parentId = :parentId and xe.name like concat('%', :name, '%') and xe.description like concat('%', :descr, '%')")
    Page<XEntity> findByParentIdAndNameContainingAndDescrContaining(Long parentId,String name, String descr, Pageable pageReq)
}

How can I make case-insentitive using spring-data-jpa

2 Answers2