the following sql is sent to the db using hibernate

From com.workpool.directory.Entry entry where (
entry.name like "%Nigeria' s%") OR (entry.refNo like "%Nigeria's%") and (entry.personal="No" or entry.author.id=3) order
by entry.name


If you do the query in sql it works and displays a result but in hibernate it throws an exception beacause of the apopstrophe. Is there any why to search with an apostrohe and still get the correct result and no exception. I have tried a / in front of the apostrophe and also double quotes.


thanks

How about passing %Nigeria's% as a parameter?

Erik

no it is a string value and therefore needs the double quotes aroud it.

Sorry but that's absurd - JDBC cares for things like that. Use ? as a placeholder , pass a parameter to the query and it will work.

Erik