You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@continuum.apache.org by "Arun Nachimuthu (JIRA)" <ji...@codehaus.org> on 2010/10/20 02:08:32 UTC
[jira] Created: (CONTINUUM-2575) Show Project Groups page errors
when using oracle as the database
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
[jira] Updated: (CONTINUUM-2575) Show Project Groups page errors
when using oracle as the database
Posted by "Brett Porter (JIRA)" <ji...@codehaus.org>.
[ 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