You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by "David Louie (JIRA)" <ji...@apache.org> on 2011/06/06 21:14:04 UTC
[jira] [Created] (OPENJPA-2008) OpenJPA does not work with native
queries in a distributed (Slice) environment
OpenJPA does not work with native queries in a distributed (Slice) environment
------------------------------------------------------------------------------
Key: OPENJPA-2008
URL: https://issues.apache.org/jira/browse/OPENJPA-2008
Project: OpenJPA
Issue Type: Bug
Components: slice
Affects Versions: 2.1.0
Environment: Slice, Tomcat 6, MySql 5.5, openJPA 2.1
Reporter: David Louie
When trying to create a native query in a distributed (slice) environment, an exception is thrown because there is no ExpressionParser for language openJPA.SQL for a distributed query.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Resolved] (OPENJPA-2008) OpenJPA does not work with native
queries in a distributed (Slice) environment
Posted by "David Louie (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-2008?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
David Louie resolved OPENJPA-2008.
----------------------------------
Resolution: Fixed
Fix Version/s: 2.2.0
Issue has been resolved in revision 1135806.
Tested with the following query and the query worked, count works, and sorting works:
SELECT DISTINCT u.uid, u.studentid, u.firstname, u.lastname, u.username, u.lastlogintime, count(DISTINCT e.uid) FROM roles r
INNER JOIN userroles ur ON ur.roleID = r.uid
INNER JOIN users u ON ur.userID = u.uid
AND r.namefield IN (?1)
AND u.lastname LIKE ?2
AND u.firstname LIKE ?3
AND u.studentid LIKE ?4
AND u.isactive IS TRUE
LEFT JOIN courseenrollments e ON e.userID = u.uid
AND e.schoolyearID = ?5
AND e.enddate IS NULL
GROUP BY u.uid, u.studentid, u.firstname, u.lastname, u.username, u.lastlogintime
ORDER BY u.uid
> OpenJPA does not work with native queries in a distributed (Slice) environment
> ------------------------------------------------------------------------------
>
> Key: OPENJPA-2008
> URL: https://issues.apache.org/jira/browse/OPENJPA-2008
> Project: OpenJPA
> Issue Type: Bug
> Components: slice
> Affects Versions: 2.1.0
> Environment: Slice, Tomcat 6, MySql 5.5, openJPA 2.1
> Reporter: David Louie
> Fix For: 2.2.0
>
>
> When trying to create a native query in a distributed (slice) environment, an exception is thrown because there is no ExpressionParser for language openJPA.SQL for a distributed query.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Assigned] (OPENJPA-2008) OpenJPA does not work with native
queries in a distributed (Slice) environment
Posted by "Pinaki Poddar (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-2008?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Pinaki Poddar reassigned OPENJPA-2008:
--------------------------------------
Assignee: Pinaki Poddar
> OpenJPA does not work with native queries in a distributed (Slice) environment
> ------------------------------------------------------------------------------
>
> Key: OPENJPA-2008
> URL: https://issues.apache.org/jira/browse/OPENJPA-2008
> Project: OpenJPA
> Issue Type: Bug
> Components: slice
> Affects Versions: 2.1.0
> Environment: Slice, Tomcat 6, MySql 5.5, openJPA 2.1
> Reporter: David Louie
> Assignee: Pinaki Poddar
> Fix For: 2.2.0
>
>
> When trying to create a native query in a distributed (slice) environment, an exception is thrown because there is no ExpressionParser for language openJPA.SQL for a distributed query.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Closed] (OPENJPA-2008) OpenJPA does not work with native
queries in a distributed (Slice) environment
Posted by "Albert Lee (Closed) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-2008?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Albert Lee closed OPENJPA-2008.
-------------------------------
Close issue in preparation for 2.2.0 release.
> OpenJPA does not work with native queries in a distributed (Slice) environment
> ------------------------------------------------------------------------------
>
> Key: OPENJPA-2008
> URL: https://issues.apache.org/jira/browse/OPENJPA-2008
> Project: OpenJPA
> Issue Type: Bug
> Components: slice
> Affects Versions: 2.1.0
> Environment: Slice, Tomcat 6, MySql 5.5, openJPA 2.1
> Reporter: David Louie
> Assignee: Pinaki Poddar
> Fix For: 2.2.0
>
>
> When trying to create a native query in a distributed (slice) environment, an exception is thrown because there is no ExpressionParser for language openJPA.SQL for a distributed query.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira