continuum-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brett Porter (JIRA)" <j...@codehaus.org>
Subject [jira] Updated: (CONTINUUM-2575) Show Project Groups page errors when using oracle as the database
Date Fri, 19 Nov 2010 05:05:38 GMT

     [ http://jira.codehaus.org/browse/CONTINUUM-2575?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Brett Porter updated CONTINUUM-2575:
------------------------------------

    Fix Version/s: Backlog

> 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.3.6, 1.4.0 (Beta)
>         Environment: Oracle Database
>            Reporter: Arun Nachimuthu
>             Fix For: Backlog
>
>         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

        

Mime
View raw message