Parameter in like clause JPQL

Question

I am trying to write a JPQL query with a like clause   LIKE    code     I would like to have code 4 and find   455 554 646       I cannot pass  code     value    namedQuery setParameter       this value           because in another place I need  value not wrapped by the   chars  Any help

User · Answer

I don t use named parameters for all queries  For example it is unusual to use named parameters in JpaRepository   To workaround I use JPQL CONCAT function  this code emulate start with     Repository public interface BranchRepository extends JpaRepository lt Branch  String gt        private static final String QUERY    select b from Branch b             left join b filial f             where f id    1 and b id like CONCAT  2              Query QUERY      List lt Branch gt  findByFilialAndBranchLike String filialId  String branchCode       I found this technique in excellent docs  http   openjpa apache org builds 1 0 1 apache-openjpa-1 0 1 docs manual jpa overview query html

User · Answer

Use JpaRepository or CrudRepository as repository interface   Repository public interface CustomerRepository extends JpaRepository lt Customer  Integer gt          Query  quot SELECT t from Customer t where LOWER t name  LIKE   name  quot       public List lt Customer gt  findByName  Param  quot name quot   String name         Service value  quot customerService quot   public class CustomerServiceImpl implements CustomerService        private CustomerRepository customerRepository                       Override     public List lt Customer gt  pattern String text  throws Exception           return customerRepository findByName text toLowerCase

User · Answer

There is nice like   method in JPA criteria API  Try to use that  hope it will help   CriteriaBuilder cb   em getCriteriaBuilder    CriteriaQuery criteriaQuery   cb createQuery Employees class   Root lt Employees gt  rootOfQuery   criteriaQuery from Employees class   criteriaQuery select rootOfQuery  where cb like rootOfQuery get  firstName     H

User · Answer

You could use the JPA LOCATE function       LOCATE searchString  candidateString    startIndex    Returns the   first index of searchString in candidateString  Positions are 1-based    If the string is not found  returns 0    FYI  The documentation on my top google hit had the parameters reversed   SELECT    e FROM    entity e WHERE    0  lt  LOCATE  searchStr  e property

User · Answer

Just leave out the     LIKE   code

User · Answer

I don t know if I am late or out of scope but in my opinion I could do it like   String orgName    anyParamValue    Query q   em createQuery  Select O from Organization O where O orgName LIKE    orgName       q setParameter  orgName   orgName

User · Answer

Use below JPQL query   select i from Instructor i where i address LIKE CONCAT      address       quot      Use below Criteria code for the same    Test public void findAllHavingAddressLike         CriteriaBuilder cb   criteriaUtils criteriaBuilder        CriteriaQuery lt Instructor gt  cq   cb createQuery Instructor class       Root lt Instructor gt  root   cq from Instructor class       printResultList cq select root  where          cb like root get Instructor  address    quot   1074  quot

User · Answer

If you do   LIKE  code   and then do   namedQuery setParameter  code         this value           Then value remains free from the     sign  If you need to use it somewhere else in the same query simply use another parameter name other than  code

[java] Parameter in like clause JPQL

Examples related to java

Examples related to jpa

Examples related to eclipselink

Examples related to jpql

Examples related to sql-like