There is 1 update.
 
 
Recommendation Application / cid:jira-generated-image-avatar-3d5dd25a-3c47-421a-8ffc-dc8b293a7aed XRECOMMEND-12 Open

The recommendation queries compare the date of the pages with a string

 
View issue   ยท   Add comment
 

1 update

 
cid:jira-generated-image-avatar-16fdcc40-24ed-45c1-85c6-83bf3cb30578 Changes by Thomas Mortagne on 17/Nov/26 15:35
 
Description: {{RecommendationsCode.ProfilesScheduler}} and {{RecommendationsCode.SendProfile_PagesList}} compare the date of the pages with a string:

{noformat}
doc.date >= '${updateDate}'
doc.date >= '${request.get('updateDate')}'
{noformat}

Since Hibernate 6, HQL checks the types of both sides of a comparison when the query is parsed, and rejects incompatible ones ({{SemanticException: Cannot compare left expression of type ... with right expression of type ...}}). XWiki is moving to Hibernate 7 (XWIKI-19708), where these queries will fail on every database. With Hibernate 5 the literal is copied as is in the SQL, so the queries rely on the database converting it implicitly, which not all databases do.

On Oracle, this already depends on the date format of the database session ({{NLS_DATE_FORMAT}}).

Bind the date as a {{java.util.Date}} query parameter instead (which also avoids injecting a request parameter in the query). This works with all the databases and all the Hibernate versions.


PS: This post was co-written with Claude Code.