Uploaded image for project: 'JIRA Server (including JIRA Core)'
  1. JIRA Server (including JIRA Core)
  2. JRASERVER-11595

Jira Toolkit's 'Participants' customfield logs a "Three part identifiers prohibited" error in logs when running against HSQL

    Details

    • Type: Bug
    • Status: Resolved (View Workflow)
    • Priority: Low
    • Resolution: Fixed
    • Affects Version/s: 3.7 Beta 1
    • Fix Version/s: 3.7
    • Component/s: Issue - Fields
    • Labels:
    • Environment:

      Firefox 1.5, HSQL 1.8.0, Jira-toolkit 0.7.8

      Description

      The following error is logged upon entering the issue view, although the page is rendered correctly:

      java.sql.SQLException: Three part identifiers prohibited in statement [select distinct(PUBLIC.jiraaction.AUTHOR) from PUBLIC.jiraaction where PUBLIC.jiraaction.issueid = ? and PUBLIC.jiraaction.actiontype = 'comment'  and (PUBLIC.jiraaction.actionlevel is null or PUBLIC.jiraaction.actionlevel in ('jira-administrators','jira-developers','jira-users'))]
      	at org.hsqldb.jdbc.Util.throwError(Unknown Source)
      	at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
      	at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
      	at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:185)
      	at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:278)
      	at org.ofbiz.core.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:327)
      	at org.ofbiz.core.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:302)
      	at com.atlassian.jira.toolkit.customfield.ParticipantsDAO.getCommenterNames(ParticipantsDAO.java:110)
      	at com.atlassian.jira.toolkit.customfield.ParticipantsCFType.getValueFromIssue(ParticipantsCFType.java:84)
      	at com.atlassian.jira.issue.fields.CustomFieldImpl.getValue(CustomFieldImpl.java:225)
      	at com.atlassian.jira.issue.fields.screen.FieldScreenRendererImpl.getCustomFieldRenderLayoutItem(FieldScreenRendererImpl.java:160)
      	at com.atlassian.jira.issue.fields.screen.FieldScreenRendererImpl.init(FieldScreenRendererImpl.java:126)
      	at com.atlassian.jira.issue.fields.screen.FieldScreenRendererImpl.init(FieldScreenRendererImpl.java:87)
      	at com.atlassian.jira.issue.fields.screen.FieldScreenRendererFactoryImpl.getFieldScreenRenderer(FieldScreenRendererFactoryImpl.java:36)
      	at com.atlassian.jira.web.action.issue.AbstractCommentableIssue.getFieldScreenRendererWithAllFields(AbstractCommentableIssue.java:189)
      	at com.atlassian.jira.web.action.issue.AbstractCommentableIssue.getFieldScreenRendererLayoutItemForField(AbstractCommentableIssue.java:182)
      	at sun.reflect.GeneratedMethodAccessor209.invoke(Unknown Source)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      	at java.lang.reflect.Method.invoke(Method.java:585)
      	at webwork.util.InjectionUtils$DefaultInjectionImpl.invoke(InjectionUtils.java:61)
      	at webwork.util.InjectionUtils.invoke(InjectionUtils.java:52)
      	at webwork.util.ValueStack.findValue(ValueStack.java:426)
      	at webwork.util.ValueStack.findValue(ValueStack.java:175)
      	at webwork.view.taglib.WebWorkBodyTagSupport.findValue(WebWorkBodyTagSupport.java:61)
      	at webwork.view.taglib.BasicPropertyTag.doStartTag(BasicPropertyTag.java:54)
      	at org.apache.jsp.secure.views.issue.viewissue_jsp._jspx_meth_webwork_property_35(org.apache.jsp.secure.views.issue.viewissue_jsp:1741)
      	at org.apache.jsp.secure.views.issue.viewissue_jsp._jspx_meth_page_applyDecorator_0(org.apache.jsp.secure.views.issue.viewissue_jsp:1398)
      	at org.apache.jsp.secure.views.issue.viewissue_jsp._jspService(org.apache.jsp.secure.views.issue.viewissue_jsp:336)
      	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
      	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
      	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
      	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
      	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      	at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)
      	at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:463)
      	at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:398)
      	at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
      	at com.atlassian.jira.web.dispatcher.JiraServletDispatcher.service(JiraServletDispatcher.java:279)
      	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      	at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)
      	at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:463)
      	at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:398)
      	at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
      	at com.atlassian.jira.servlet.QuickLinkServlet.service(QuickLinkServlet.java:77)
      	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      	at com.atlassian.jira.web.filters.AccessLogFilter.doFilter(AccessLogFilter.java:51)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      	at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:119)
      	at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:55)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      	at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:182)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      	at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:181)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      	at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132)
      	at com.atlassian.jira.web.filters.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:38)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      	at com.atlassian.jira.web.filters.ActionCleanupDelayFilter.doFilter(ActionCleanupDelayFilter.java:44)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      	at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:298)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      	at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:37)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      	at com.atlassian.jira.appconsistency.db.DatabaseCompatibilityEnforcerFilter.doFilter(DatabaseCompatibilityEnforcerFilter.java:25)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
      	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
      	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
      	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
      	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
      	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
      	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
      	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
      	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
      	at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
      	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
      	at java.lang.Thread.run(Thread.java:595)
      

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              daniel.hurst@atlassian.com Daniel Hurst
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: