Details

      Description

      Just tried installing JIRA 2.6.1 Enterprise – installed ok, but after creating a project, creating a bug in that project, and finally trying to add that project to my dashboard – it seems to have melted down.

      Now I cannot even log into JIRA.

      Upon startup, I found this trace in the tomcat stdout.log which I realize uses "POSITION" as a fieldname – something which is VERBOTEN in HSQLDB 1.7.2RC5 and above. POSITION is a reserved token in SQL apparently. FYI – it can still be used if the field is fully qualified with the tablename, ex.PORTLETCONFIGURATION.POSITION, but it would be better to change the fieldname.

      I use the name "ORDINAL" – Check webster.com for the def'n:

      "1 : a number designating the place (as first, second, or third) occupied by an item in an ordered sequence"

      In the meantime – is there a way I can workaround this?

      Cheers,
      Timo

      2004-04-28 08:00:59,829 ERROR [jira.action.admin.DataExport] Error exporting: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, PORTALPAGE, PORTLET_ID, COLUMN_NUMBER, POSITION FROM portletconfiguration (Unexpected token in statement [SELECT ID, PORTALPAGE, PORTLET_ID, COLUMN_NUMBER, POSITION FROM portletconfiguration])
      org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, PORTALPAGE, PORTLET_ID, COLUMN_NUMBER, POSITION FROM portletconfiguration (Unexpected token in statement [SELECT ID, PORTALPAGE, PORTLET_ID, COLUMN_NUMBER, POSITION FROM portletconfiguration])
      at org.ofbiz.core.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:295)
      at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:1024)
      at org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:595)
      at org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:134)
      at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:782)
      at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:767)
      at org.ofbiz.core.entity.GenericDelegator.findAll(GenericDelegator.java:705)
      at com.atlassian.jira.action.admin.DataExport.execute(DataExport.java:58)
      at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:131)
      at com.atlassian.core.action.DefaultActionDispatcher.execute(DefaultActionDispatcher.java:34)
      at com.atlassian.jira.service.services.export.ExportService.run(ExportService.java:90)
      at com.atlassian.jira.service.JiraServiceContainer.run(JiraServiceContainer.java:51)
      at com.atlassian.jira.service.ServiceRunner.execute(ServiceRunner.java:50)
      at org.quartz.core.JobRunShell.run(JobRunShell.java:147)
      at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:387)
      java.sql.SQLException: Unexpected token in statement [SELECT ID, PORTALPAGE, PORTLET_ID, COLUMN_NUMBER, POSITION FROM portletconfiguration]
      at org.hsqldb.jdbc.jdbcUtil.throwError(Unknown Source)
      at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
      at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
      at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:226)
      at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:328)
      at org.ofbiz.core.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:290)
      at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:1024)
      at org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:595)
      at org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:134)
      at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:782)
      at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:767)
      at org.ofbiz.core.entity.GenericDelegator.findAll(GenericDelegator.java:705)
      at com.atlassian.jira.action.admin.DataExport.execute(DataExport.java:58)
      at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:131)
      at com.atlassian.core.action.DefaultActionDispatcher.execute(DefaultActionDispatcher.java:34)
      at com.atlassian.jira.service.services.export.ExportService.run(ExportService.java:90)
      at com.atlassian.jira.service.JiraServiceContainer.run(JiraServiceContainer.java:51)
      at com.atlassian.jira.service.ServiceRunner.execute(ServiceRunner.java:50)
      at org.quartz.core.JobRunShell.run(JobRunShell.java:147)
      at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:387)
      2004-04-28 08:00:59,869 WARN [service.services.export.ExportService] Exception running export service Error in action: com.atlassian.jira.action.admin.DataExport@a0560e, result: error
      Error exporting: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, PORTALPAGE, PORTLET_ID, COLUMN_NUMBER, POSITION FROM portletconfiguration (Unexpected token in statement [SELECT ID, PORTALPAGE, PORTLET_ID, COLUMN_NUMBER, POSITION FROM portletconfiguration])
      com.atlassian.core.AtlassianCoreException: Error in action: com.atlassian.jira.action.admin.DataExport@a0560e, result: error
      Error exporting: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, PORTALPAGE, PORTLET_ID, COLUMN_NUMBER, POSITION FROM portletconfiguration (Unexpected token in statement [SELECT ID, PORTALPAGE, PORTLET_ID, COLUMN_NUMBER, POSITION FROM portletconfiguration])
      at com.atlassian.core.action.ActionUtils.checkForErrors(ActionUtils.java:53)
      at com.atlassian.jira.service.services.export.ExportService.run(ExportService.java:91)
      at com.atlassian.jira.service.JiraServiceContainer.run(JiraServiceContainer.java:51)
      at com.atlassian.jira.service.ServiceRunner.execute(ServiceRunner.java:50)
      at org.quartz.core.JobRunShell.run(JobRunShell.java:147)
      at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:387)

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                timcolson Tim Colson (yahoo)
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: