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

                 Key: CONTINUUM-2575
                 URL: http://jira.codehaus.org/browse/CONTINUUM-2575
             Project: Continuum
          Issue Type: Bug
    Affects Versions: 1.4.0 (Beta), 1.3.6
         Environment: Oracle Database
            Reporter: Arun Nachimuthu
         Attachments: stacktrace.txt

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"



-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira