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

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Solved By
    • Affects Version/s: 9.10.2
    • Fix Version/s: None
    • Labels:
      None
    • Environment:
      Windows 10 Pro 64 bit, IE11, using a local instance of XWiki 11.5, on MySQL 5.7
    • Difficulty:
      Unknown
    • Similar issues:

      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

            Activity

              People

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

                Dates

                Created:
                Updated:
                Resolved: