Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-51874

Hibernate query deprecation warnings in Confluence 6 logs

XMLWordPrintable

      Summary

      Hibernate query deprecation warnings in Confluence 6 logs

      Environment

      • Confluence 6
      • Synchrony enabled

      Steps to reproduce

      After startup the following message is printed to the atlassian-confluenc.log:

      2017-03-13 16:53:32,450 WARN [http-nio-443-exec-23] [hql.internal.ast.HqlSqlWalker] generatePositionalParameter [DEPRECATION] Encountered positional parameter near line 1, column 131 in HQL: [SELECT mem.parentGroup.name FROM com.atlassian.crowd.embedded.hibernate2.HibernateMembership mem WHERE mem.userMember.lowerName = ? and mem.parentGroup.directory.id = ? ORDER BY mem.parentGroup.lowerName]. Positional parameter are considered deprecated; use named parameters or JPA-style positional parameters instead.

      Notes

      Error seems to be benign as Synchrony still works, this is a logging issue.

      Workaround

      Adding the following to log4j.properties will suppress those messages

      log4j.logger.org.hibernate.hql.internal.ast=ERROR

            [CONFSERVER-51874] Hibernate query deprecation warnings in Confluence 6 logs

            Security Metrics Bot made changes -
            Labels Original: affects-server enterprise enterprise-backlog lbp log-pollution pse-request New: affects-server enterprise enterprise-backlog lbp log-pollution no-advisory-required pse-request
            Oliver Shen made changes -
            Fix Version/s New: 7.3.1 [ 91398 ]
            Fix Version/s Original: 7.3.0 [ 90890 ]
            Dhruv Phadnis (Inactive) made changes -
            Resolution New: Fixed [ 1 ]
            Status Original: Waiting for Release [ 12075 ] New: Closed [ 6 ]
            Dhruv Phadnis (Inactive) made changes -
            Fix Version/s New: 7.3.0 [ 90890 ]
            Dhruv Phadnis (Inactive) made changes -
            Status Original: Awaiting Merge [ 10064 ] New: Waiting for Release [ 12075 ]
            Dhruv Phadnis (Inactive) made changes -
            Remote Link New: This issue links to "R7.3 P1. Baseline › WebDriver tests (Firefox 2.53.1, Oracle JDK 11) › db-issue-73-CONFSERVER-51874-fix-hibernate-positional-deprecation (server-syd-bamboo)" [ 467362 ]
            Dhruv Phadnis (Inactive) made changes -
            Remote Link New: This issue links to "R7.3 P3. Database Support › SQL Server 2012, Tomcat 9, Java 11 › db-issue-73-CONFSERVER-51874-fix-hibernate-positional-deprecation (server-syd-bamboo)" [ 467361 ]
            Dhruv Phadnis (Inactive) made changes -
            Remote Link New: This issue links to "R7.3 P3. Major Release › Windows H2 (Tomcat 9, Java 11) › db-issue-73-CONFSERVER-51874-fix-hibernate-positional-deprecation (server-syd-bamboo)" [ 467549 ]
            Dhruv Phadnis (Inactive) made changes -
            Remote Link New: This issue links to "R7.3 P3. Database Support › MySQL 8.0, Tomcat 9, Java 11 › db-issue-73-CONFSERVER-51874-fix-hibernate-positional-deprecation (server-syd-bamboo)" [ 467360 ]
            Dhruv Phadnis (Inactive) made changes -
            Remote Link New: This issue links to "R7.3 P3. Database Support › SQL Server 2017 Linux, Tomcat 9, Java 11 › db-issue-73-CONFSERVER-51874-fix-hibernate-positional-deprecation (server-syd-bamboo)" [ 467548 ]

              dphadnis@atlassian.com Dhruv Phadnis (Inactive)
              dponzio Daniel Ponzio
              Affected customers:
              40 This affects my team
              Watchers:
              69 Start watching this issue

                Created:
                Updated:
                Resolved: