How to apply case insestive on the Hibernate Query?

[Rd Dari]

Hi All,

below is the code using Like operator using hibernate. Can any one tell me how to apply case Insesitive on the below query.

@Override
	public List<LAHSGroupStudyMstr> getLikeSearchRecordsForGroup(BigDecimal siteId, BigDecimal customerId, String search)throws DAOException{
		List<LAHSGroupStudyMstr> likeSearchList = null;
		try{
			
			likeSearchList = session.createQuery("select id.groupSeqId, groupName, groupDesc, status from LAHSGroupStudyMstr where id.siteId=:siteId and customerId=:customerId and groupName LIKE :groupName"
					+ " OR groupDesc Like :groupDesc ")
					.setBigDecimal("customerId", customerId)
					.setBigDecimal("siteId", siteId)
					.setString("groupName", "%"+search+"%")
					.setString("groupDesc", "%"+search+"%").list();
			
		}
		catch(DAOException e){
			throw e;
		}
		return likeSearchList;
	}

Thanks in advanced!

[chets patel]

Use upper function of sql which convert into upper case. And while passing parameter to query, convert all variables into upper case.

 @Override  
    public List<LAHSGroupStudyMstr> getLikeSearchRecordsForGroup(BigDecimal siteId, BigDecimal customerId, String search)throws DAOException{  
        List<LAHSGroupStudyMstr> likeSearchList = null;  
        try{  
              
            likeSearchList = session.createQuery("select id.groupSeqId, groupName, groupDesc, status from LAHSGroupStudyMstr where id.siteId=:siteId and customerId=:customerId and UPPER(groupName) LIKE :groupName"  
                    + " OR UPPER(groupDesc) Like :groupDesc ")  
                    .setBigDecimal("customerId", customerId)  
                    .setBigDecimal("siteId", siteId)  
                    .setString("groupName", "%"+search.toUpperCase()+"%")  
                    .setString("groupDesc", "%"+search.toUpperCase()+"%").list();  
              
        }  
        catch(DAOException e){  
            throw e;  
        }  
        return likeSearchList;  
    }    

For more reading on hibernate, read my blogpost http://morejava4u.blogspot.com/p/hibernate.html