Avoiding% and _ in a SQL predicate

Question

Avoiding% and _ in a SQL predicate

The following code for finding particle data in a map does not work if the searchWord contains %, ', _, etc.

StringBuilder fullQuery= new StringBuilder().
                 append("Name like \'").append(searchWord).
                 append("%\'");

List<Person> persons = (List<Person>) personMap
                .values(new SqlPredicate(fullQuery));

How can I use these symbols for the actual match.

+3

java hazelcast

Kajal Jul 28 15 at 11:42

source to share

1 answer

noctarius · Accepted Answer · 2015-07-28T12:08:12+0000

There is no variable binding in Hazelcast SQL like Hibernate. You have to do it yourself. You may want to keep the operator in a constant and use String :: format to replace variables.

Avoiding% and _ in a SQL predicate

More articles: