Support Questions
Find answers, ask questions, and share your expertise
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Like search using JDBC driver 2.5.4


Like search using JDBC driver 2.5.4

New Contributor

I am trying to do a like search on percentage symbol from my java rest application. Something like 

select * from table1 where name like '%\%%'.


However as a standard practice I have to parameter bind my search values so my java query looks like

select * from table1 where name like :name 


:name to be replaced by the search value by the driver using setParameter() function


The second method of querying does not give me correct results when I try backslashes as escape sequence, so my search on SQL wildcards (%,_,\) fails.


This issue is not observed when I sent the values as quoted.


name = "%\%%" works.


Am I missing something here? Help much needed and appreciated


Don't have an account?
Coming from Hortonworks? Activate your account here