Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-14888

"AT" is an Reserved word in SQL

    XMLWordPrintable

Details

    • Bug
    • Resolution: Obsolete
    • Medium
    • None
    • 3.11
    • Issue - Fields
    • win2003

    Description

      "AT" is used as an alias in one of the sql statements from Jira.

      see:

      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:619)
      2008-04-29 16:18:53,893 http-8080-Processor20 ERROR [ext.charting.field.ResolutionDateDAO] org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:

      select min( at.CREATED) from jiraaction at , jiraissue it where at.issueid = ? and at.issueid = it.ID and at.actiontype = 'comment' and it.REPORTER != at.AUTHOR

      (GDS Exception. 335544569. Dynamic SQL Error
      SQL error code = -104
      Token unknown - line 1, column 13
      at)

      org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:select min( at.CREATED) from jiraaction at , jiraissue it where at.issueid = ? and at.issueid = it.ID and at.actiontype = 'comment' and it.REPORTER != at.AUTHOR (GDS Exception. 335544569. Dynamic SQL Error
      SQL error code = -104
      Token unknown - line 1, column 13
      at)
      at org.ofbiz.core.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:330)
      at org.ofbiz.core.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:302)
      at com.atlassian.jira.ext.charting.field.AbstractSingleDateDAO.calculateDate(AbstractSingleDateDAO.java:54)
      at com.atlassian.jira.ext.charting.field.DateOfFirstResponseCFType.calculateFirstResponseDate(DateOfFirstResponseCFType.java:46)
      at com.atlassian.jira.ext.charting.field.DateOfFirstResponseCFType.getValueFromIssue(DateOfFirstResponseCFType.java:34)
      at com.atlassian.jira.issue.fields.CustomFieldImpl.getValue(CustomFieldImpl.java:266)

      Attachments

        Activity

          People

            dushan@atlassian.com Dushan Hanuska [Atlassian]
            2e6084074260 Derryck Welas
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: