Uploaded image for project: 'Continuum'
  1. Continuum
  2. CONTINUUM-2575

Show Project Groups page errors when using oracle as the database

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 1.3.6, 1.4.0 (Beta)
    • None
    • None
    • Oracle Database

    Description

      Show Project Groups page errors when using oracle as the database.

      javax.jdo.JDODataStoreException: Error executing JDOQL query "SELECT THIS.PROJECT_GROUP_ID_OID AS projectGroupId,THIS.PROJECTSTATE AS projectState,COUNT(THIS.PROJECTSTATE) AS size FROM PROJECT THIS GROUP BY THIS.PROJECT_GROUP_ID_OID,THIS.PROJECTSTATE" : ORA-00923: FROM keyword not found where expected . NestedThrowables: java.sql.SQLException: ORA-00923: FROM keyword not found where expected.

      The column alias "COUNT(THIS.PROJECTSTATE) AS size" should be changed since "size" is a reserved keyword. The query executes fine if it is modified to "COUNT(THIS.PROJECTSTATE) AS projectSize"

      Attachments

        1. stacktrace.txt
          36 kB

        Activity

          There are no comments yet on this issue.

          People

            Unassigned Unassigned
            anachimuthu0 Arun Nachimuthu
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated: