Uploaded image for project: 'Blog Application'
  1. Blog Application
  2. BLOG-140

Warnings related to deprecated usage of parameters when accessing Blog pages in XWiki 11.5

    XMLWordPrintable

Details

    • Bug
    • Resolution: Solved By
    • Major
    • None
    • 9.10.2
    • None
    • Windows 10 Pro 64 bit, IE11, using a local instance of XWiki 11.5, on MySQL 5.7
    • Unknown

    Description

      STEPS TO REPRODUCE

      Preconditions: An instance of XWiki 11.5 is already created.

      1. Install Blog Application on XWiki 11.5
      2. Click on Blog from Applications Panel
      3. Create a blog post
      4. Navigate on Blog App's pages (Main page, the page of blog post previously created)

      EXPECTED RESULTS

      There are no warnings/errors displayed.

      ACTUAL RESULTS

      Some warnings are displayed related to deprecated usage of HQL parameters:

      2019-06-27 10:34:25,380 [http://localhost:1151/xwiki/bin/view/Blog/] WARN  c.x.x.XWiki                    - Deprecated usage legacy-style HQL ordinal parameters (`?`); use JPA-style ordinal parameters (e.g., `?1`) instead. Query [select count(distinct doc.fullName) from XWikiDocument doc , DBStringListProperty as categories join categories.list as category, BaseObject as obj, IntegerProperty isPublished,
IntegerProperty hidden, DateProperty publishDate
where doc.fullName <> 'Blog.BlogPostTemplate' and
obj.name=doc.fullName and obj.className='Blog.BlogPostClass' and
isPublished.id.id = obj.id and isPublished.id.name = 'published' and
hidden.id.id = obj.id and hidden.id.name='hidden' and
publishDate.id.id = obj.id and publishDate.id.name='publishDate' and
(doc.creator = 'XWiki.ILIE' or (isPublished.value = 1 and hidden.value = 0)) and obj.id = categories.id.id and categories.id.name='category' and category in (?)] has been converted to [select count(distinct doc.fullName) from XWikiDocument doc , DBStringListProperty as categories join categories.list as category, BaseObject as obj, IntegerProperty isPublished,
IntegerProperty hidden, DateProperty publishDate
where doc.fullName <> 'Blog.BlogPostTemplate' and
obj.name=doc.fullName and obj.className='Blog.BlogPostClass' and
isPublished.id.id = obj.id and isPublished.id.name = 'published' and
hidden.id.id = obj.id and hidden.id.name='hidden' and
publishDate.id.id = obj.id and publishDate.id.name='publishDate' and
(doc.creator = 'XWiki.ILIE' or (isPublished.value = 1 and hidden.value = 0)) and obj.id = categories.id.id and categories.id.name='category' and category in (?1)]
2019-06-27 10:34:25,401 [http://localhost:1151/xwiki/bin/view/Blog/] WARN  c.x.x.XWiki                    - Deprecated usage legacy-style HQL ordinal parameters (`?`); use JPA-style ordinal parameters (e.g., `?1`) instead. Query [select distinct doc.fullName, publishDate.value from XWikiDocument doc , DBStringListProperty as categories join categories.list as category, BaseObject as obj, IntegerProperty isPublished,
IntegerProperty hidden, DateProperty publishDate
where doc.fullName <> 'Blog.BlogPostTemplate' and
obj.name=doc.fullName and obj.className='Blog.BlogPostClass' and
isPublished.id.id = obj.id and isPublished.id.name = 'published' and
hidden.id.id = obj.id and hidden.id.name='hidden' and
publishDate.id.id = obj.id and publishDate.id.name='publishDate' and
(doc.creator = 'XWiki.ILIE' or (isPublished.value = 1 and hidden.value = 0)) and obj.id = categories.id.id and categories.id.name='category' and category in (?) order by publishDate.value desc] has been converted to [select distinct doc.fullName, publishDate.value from XWikiDocument doc , DBStringListProperty as categories join categories.list as category, BaseObject as obj, IntegerProperty isPublished,
IntegerProperty hidden, DateProperty publishDate
where doc.fullName <> 'Blog.BlogPostTemplate' and
obj.name=doc.fullName and obj.className='Blog.BlogPostClass' and
isPublished.id.id = obj.id and isPublished.id.name = 'published' and
hidden.id.id = obj.id and hidden.id.name='hidden' and
publishDate.id.id = obj.id and publishDate.id.name='publishDate' and
(doc.creator = 'XWiki.ILIE' or (isPublished.value = 1 and hidden.value = 0)) and obj.id = categories.id.id and categories.id.name='category' and category in (?1) order by publishDate.value desc]
2019-06-27 10:34:25,417 [http://localhost:1151/xwiki/bin/view/Blog/] WARN  c.x.x.XWiki                    - Deprecated usage legacy-style HQL ordinal parameters (`?`); use JPA-style ordinal parameters (e.g., `?1`) instead. Query [select count(distinct doc.fullName) from XWikiDocument doc , DBStringListProperty as categories join categories.list as category, BaseObject as obj, IntegerProperty isPublished,
IntegerProperty hidden, DateProperty publishDate
where doc.fullName <> 'Blog.BlogPostTemplate' and
obj.name=doc.fullName and obj.className='Blog.BlogPostClass' and
isPublished.id.id = obj.id and isPublished.id.name = 'published' and
hidden.id.id = obj.id and hidden.id.name='hidden' and
publishDate.id.id = obj.id and publishDate.id.name='publishDate' and
(doc.creator = 'XWiki.ILIE' or (isPublished.value = 1 and hidden.value = 0)) and obj.id = categories.id.id and categories.id.name='category' and category in (?)] has been converted to [select count(distinct doc.fullName) from XWikiDocument doc , DBStringListProperty as categories join categories.list as category, BaseObject as obj, IntegerProperty isPublished,
IntegerProperty hidden, DateProperty publishDate
where doc.fullName <> 'Blog.BlogPostTemplate' and
obj.name=doc.fullName and obj.className='Blog.BlogPostClass' and
isPublished.id.id = obj.id and isPublished.id.name = 'published' and
hidden.id.id = obj.id and hidden.id.name='hidden' and
publishDate.id.id = obj.id and publishDate.id.name='publishDate' and
(doc.creator = 'XWiki.ILIE' or (isPublished.value = 1 and hidden.value = 0)) and obj.id = categories.id.id and categories.id.name='category' and category in (?1)]
2019-06-27 10:34:25,426 [http://localhost:1151/xwiki/bin/view/Blog/] WARN  c.x.x.XWiki                    - Deprecated usage legacy-style HQL ordinal parameters (`?`); use JPA-style ordinal parameters (e.g., `?1`) instead. Query [select distinct doc.fullName, publishDate.value from XWikiDocument doc , DBStringListProperty as categories join categories.list as category, BaseObject as obj, IntegerProperty isPublished,
IntegerProperty hidden, DateProperty publishDate
where doc.fullName <> 'Blog.BlogPostTemplate' and
obj.name=doc.fullName and obj.className='Blog.BlogPostClass' and
isPublished.id.id = obj.id and isPublished.id.name = 'published' and
hidden.id.id = obj.id and hidden.id.name='hidden' and
publishDate.id.id = obj.id and publishDate.id.name='publishDate' and
(doc.creator = 'XWiki.ILIE' or (isPublished.value = 1 and hidden.value = 0)) and obj.id = categories.id.id and categories.id.name='category' and category in (?) order by publishDate.value desc] has been converted to [select distinct doc.fullName, publishDate.value from XWikiDocument doc , DBStringListProperty as categories join categories.list as category, BaseObject as obj, IntegerProperty isPublished,
IntegerProperty hidden, DateProperty publishDate
where doc.fullName <> 'Blog.BlogPostTemplate' and
obj.name=doc.fullName and obj.className='Blog.BlogPostClass' and
isPublished.id.id = obj.id and isPublished.id.name = 'published' and
hidden.id.id = obj.id and hidden.id.name='hidden' and
publishDate.id.id = obj.id and publishDate.id.name='publishDate' and
(doc.creator = 'XWiki.ILIE' or (isPublished.value = 1 and hidden.value = 0)) and obj.id = categories.id.id and categories.id.name='category' and category in (?1) order by publishDate.value desc]
2019-06-27 10:34:25,439 [http://localhost:1151/xwiki/bin/view/Blog/] WARN  c.x.x.XWiki                    - Deprecated usage legacy-style HQL ordinal parameters (`?`); use JPA-style ordinal parameters (e.g., `?1`) instead. Query [select count(distinct doc.fullName) from XWikiDocument doc , DBStringListProperty as categories join categories.list as category, BaseObject as obj, IntegerProperty isPublished,
IntegerProperty hidden, DateProperty publishDate
where doc.fullName <> 'Blog.BlogPostTemplate' and
obj.name=doc.fullName and obj.className='Blog.BlogPostClass' and
isPublished.id.id = obj.id and isPublished.id.name = 'published' and
hidden.id.id = obj.id and hidden.id.name='hidden' and
publishDate.id.id = obj.id and publishDate.id.name='publishDate' and
(doc.creator = 'XWiki.ILIE' or (isPublished.value = 1 and hidden.value = 0)) and obj.id = categories.id.id and categories.id.name='category' and category in (?)] has been converted to [select count(distinct doc.fullName) from XWikiDocument doc , DBStringListProperty as categories join categories.list as category, BaseObject as obj, IntegerProperty isPublished,
IntegerProperty hidden, DateProperty publishDate
where doc.fullName <> 'Blog.BlogPostTemplate' and
obj.name=doc.fullName and obj.className='Blog.BlogPostClass' and
isPublished.id.id = obj.id and isPublished.id.name = 'published' and
hidden.id.id = obj.id and hidden.id.name='hidden' and
publishDate.id.id = obj.id and publishDate.id.name='publishDate' and
(doc.creator = 'XWiki.ILIE' or (isPublished.value = 1 and hidden.value = 0)) and obj.id = categories.id.id and categories.id.name='category' and category in (?1)]
2019-06-27 10:34:25,447 [http://localhost:1151/xwiki/bin/view/Blog/] WARN  c.x.x.XWiki                    - Deprecated usage legacy-style HQL ordinal parameters (`?`); use JPA-style ordinal parameters (e.g., `?1`) instead. Query [select distinct doc.fullName, publishDate.value from XWikiDocument doc , DBStringListProperty as categories join categories.list as category, BaseObject as obj, IntegerProperty isPublished,
IntegerProperty hidden, DateProperty publishDate
where doc.fullName <> 'Blog.BlogPostTemplate' and
obj.name=doc.fullName and obj.className='Blog.BlogPostClass' and
isPublished.id.id = obj.id and isPublished.id.name = 'published' and
hidden.id.id = obj.id and hidden.id.name='hidden' and
publishDate.id.id = obj.id and publishDate.id.name='publishDate' and
(doc.creator = 'XWiki.ILIE' or (isPublished.value = 1 and hidden.value = 0)) and obj.id = categories.id.id and categories.id.name='category' and category in (?) order by publishDate.value desc] has been converted to [select distinct doc.fullName, publishDate.value from XWikiDocument doc , DBStringListProperty as categories join categories.list as category, BaseObject as obj, IntegerProperty isPublished,
IntegerProperty hidden, DateProperty publishDate
where doc.fullName <> 'Blog.BlogPostTemplate' and
obj.name=doc.fullName and obj.className='Blog.BlogPostClass' and
isPublished.id.id = obj.id and isPublished.id.name = 'published' and
hidden.id.id = obj.id and hidden.id.name='hidden' and
publishDate.id.id = obj.id and publishDate.id.name='publishDate' and
(doc.creator = 'XWiki.ILIE' or (isPublished.value = 1 and hidden.value = 0)) and obj.id = categories.id.id and categories.id.name='category' and category in (?1) order by publishDate.value desc]

      The warnings are displayed in console every time the user lands Blog App's pages and can fill up the logs, taking up space.

      The issue could not be reproduced on the same version of Blog (9.10.2) on XWiki 11.4.

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. BLOG-146 Avoid deprecated usage of legacy-style HQL ordinal parameters

          • Major - Major loss of function.
          • Closed
          is related to

          Task - A task that needs to be done. XWIKI-8286 Upgrade to Hibernate 5.4.3

          • Major - Major loss of function.
          • Closed

          Activity

            People

              acotiuga Alex Cotiugă
              iandriuta Ilie Andriuta
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: