Many warnings related to deprecated usage of legacy-style HQL ordinal parameters in console when using the app

[ilieandriuta]

STEPS TO REPRODUCE

1. Go to Administer Wiki > Other > Antivirus
2. Observe the console logs

EXPECTED RESULTS

The console does not display any warnings/ errors.

ACTUAL RESULTS

On each click on the Antivirus App from Administration, the logs are filled with warnings like:

2019-10-08 15:11:15,823 [http://localhost:1181/xwiki/bin/get/Antivirus/AntivirusLogLiveTableResults?outputSyntax=plain&transprefix=antivirus.log.index.&classname=Antivirus.AntivirusIncidentClass&collist=attachmentName%2CattachmentDocument%2CattachmentInfections%2CincidentDate%2CattachmentAuthor%2CincidentAction&queryFilters=currentlanguage%2Chidden&offset=1&limit=10&reqNo=1&sort=incidentDate&dir=desc] WARN c.x.x.XWiki - Deprecated usage legacy-style HQL ordinal parameters (?); use JPA-style ordinal parameters (e.g., ?1) instead. Query [select elements(prop.list) from XWikiDocument as doc, BaseObject as tagobject, DBStringListProperty as prop, BaseObject as obj , DateProperty prop_incidentDate where (doc.hidden <> true or doc.hidden is null) and (tagobject.name=doc.fullName and tagobject.className='XWiki.TagClass' and tagobject.id=prop.id.id and prop.id.name='tags' and doc.translation=0 and obj.name=doc.fullName and obj.className = ? and doc.fullName not in (?, ?) and obj.id=prop_incidentDate.id.id and prop_incidentDate.name = ?)] has been converted to [select elements(prop.list) from XWikiDocument as doc, BaseObject as tagobject, DBStringListProperty as prop, BaseObject as obj , DateProperty prop_incidentDate where (doc.hidden <> true or doc.hidden is null) and (tagobject.name=doc.fullName and tagobject.className='XWiki.TagClass' and tagobject.id=prop.id.id and prop.id.name='tags' and doc.translation=0 and obj.name=doc.fullName and obj.className = ?1 and doc.fullName not in (?2, ?3) and obj.id=prop_incidentDate.id.id and prop_incidentDate.name = ?4)] 2019-10-08 15:11:15,830 [http://localhost:1181/xwiki/bin/get/Antivirus/AntivirusLogLiveTableResults?outputSyntax=plain&transprefix=antivirus.log.index.&classname=Antivirus.AntivirusIncidentClass&collist=attachmentName%2CattachmentDocument%2CattachmentInfections%2CincidentDate%2CattachmentAuthor%2CincidentAction&queryFilters=currentlanguage%2Chidden&offset=1&limit=10&reqNo=1&sort=incidentDate&dir=desc] WARN c.x.x.XWiki - Deprecated usage legacy-style HQL ordinal parameters (?); use JPA-style ordinal parameters (e.g., ?1) instead. Query [select elements(prop.list) from XWikiDocument as doc, BaseObject as tagobject, DBStringListProperty as prop, BaseObject as obj where (doc.hidden <> true or doc.hidden is null) and (tagobject.name=doc.fullName and tagobject.className='XWiki.TagClass' and tagobject.id=prop.id.id and prop.id.name='tags' and doc.translation=0 and obj.name=doc.fullName and obj.className = ? and doc.fullName not in (?, ?))] has been converted to [select elements(prop.list) from XWikiDocument as doc, BaseObject as tagobject, DBStringListProperty as prop, BaseObject as obj where (doc.hidden <> true or doc.hidden is null) and (tagobject.name=doc.fullName and tagobject.className='XWiki.TagClass' and tagobject.id=prop.id.id and prop.id.name='tags' and doc.translation=0 and obj.name=doc.fullName and obj.className = ?1 and doc.fullName not in (?2, ?3))] 2019-10-08 15:11:15,837 [http://localhost:1181/xwiki/bin/get/Antivirus/AntivirusLogLiveTableResults?outputSyntax=plain&transprefix=antivirus.log.index.&classname=Antivirus.AntivirusIncidentClass&collist=attachmentName%2CattachmentDocument%2CattachmentInfections%2CincidentDate%2CattachmentAuthor%2CincidentAction&queryFilters=currentlanguage%2Chidden&offset=1&limit=10&reqNo=1&sort=incidentDate&dir=desc] WARN c.x.x.XWiki - Deprecated usage legacy-style HQL ordinal parameters (?); use JPA-style ordinal parameters (e.g., ?1) instead. Query [select doc.fullName from XWikiDocument doc , BaseObject as obj , DateProperty prop_incidentDate where (doc.hidden <> true or doc.hidden is null) and ((doc.language is null or doc.language = '' or doc.language = 'en') and (obj.name=doc.fullName and obj.className = ? and doc.fullName not in (?, ?) and obj.id=prop_incidentDate.id.id and prop_incidentDate.name = ? )) order by prop_incidentDate.value desc] has been converted to [select doc.fullName from XWikiDocument doc , BaseObject as obj , DateProperty prop_incidentDate where (doc.hidden <> true or doc.hidden is null) and ((doc.language is null or doc.language = '' or doc.language = 'en') and (obj.name=doc.fullName and obj.className = ?1 and doc.fullName not in (?2, ?3) and obj.id=prop_incidentDate.id.id and prop_incidentDate.name = ?4 )) order by prop_incidentDate.value desc] 2019-10-08 15:11:15,842 [http://localhost:1181/xwiki/bin/get/Antivirus/AntivirusLogLiveTableResults?outputSyntax=plain&transprefix=antivirus.log.index.&classname=Antivirus.AntivirusIncidentClass&collist=attachmentName%2CattachmentDocument%2CattachmentInfections%2CincidentDate%2CattachmentAuthor%2CincidentAction&queryFilters=currentlanguage%2Chidden&offset=1&limit=10&reqNo=1&sort=incidentDate&dir=desc] WARN c.x.x.XWiki - Deprecated usage legacy-style HQL ordinal parameters (?); use JPA-style ordinal parameters (e.g., ?1) instead. Query [select count(doc.fullName) from XWikiDocument doc , BaseObject as obj , DateProperty prop_incidentDate where (doc.hidden <> true or doc.hidden is null) and ((doc.language is null or doc.language = '' or doc.language = 'en') and (obj.name=doc.fullName and obj.className = ? and doc.fullName not in (?, ?) and obj.id=prop_incidentDate.id.id and prop_incidentDate.name = ? )) ] has been converted to [select count(doc.fullName) from XWikiDocument doc , BaseObject as obj , DateProperty prop_incidentDate where (doc.hidden <> true or doc.hidden is null) and ((doc.language is null or doc.language = '' or doc.language = 'en') and (obj.name=doc.fullName and obj.className = ?1 and doc.fullName not in (?2, ?3) and obj.id=prop_incidentDate.id.id and prop_incidentDate.name = ?4 )) ]

This can fill up the logs quickly and take up space.

Environment: Environment: Windows 10 64bit, Chrome 77, using a local instance of XWiki 11.8.1 on HSQL (Antivirus Application v. 1.2.6)