Hi,

is it possible to change the wildcard characters or are % and _ hard coded?

I would like to use * and ? but I do not want to change all the queries.

Thank you.

Hi,

I assume you are talking HQL or JPA QL here in which case this is probably the wrong forum. Hibernate Search is really about the combination of Hibernate and Lucene.

Nevertheless, Hibernate's LIKE operator allows wildcard searches via the symbols % and _. This is in accordance with the SQL standard. As far as I know there is no easy way to change to change the wildcard symbols. Also remember, even if you could write your queries with * and ?, once the SQL query will be executed the symbols would have to be replaced again with % respectively _ since this is what the database will expect.

What is your actual usecase? Why do you want to change the query syntax?

--Hardy

Well the reason is simple:

Users normally know * and ?, but not % and _.

the EQL is:

select foo from bar where test like ?1

The value for parameter 1 is given by the user in an input mask.

Maybe you should parse/validate the user specified query string? For the user you can expose "*" and "?" which you then map to the appropriate queries. This would also give an additional level security for malicious SQL injection.

Alternatively you could consider using Hibernate Search. Hibernate Search is build on Lucene which uses "*" and "?" (and many more) meta characters and has an extensive query parser. Of course it really depends on your usecase.

The spec allows you to define the escape character through ESCAPE but that is pretty much all you can do. Otherwise, you need to parse the user provided character string.