I'm moving an app using hibernate from postgres to oracle, and it has hql queries with
Code:
from Tab t left join fetch t.template where t.id = :tabId and t.deleted = 'false'"
notice the single quotes around the false value. I have the following in my hibernate properties:
Code:
<entry key="hibernate.query.substitutions" value="true 1, false 0, 'true' 1, 'false' 0" />
but it will only replace the value if i change the query to remove the quotes around true/false. i'd rather not have to make these changes all over the place, am I missing something?