You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cayenne.apache.org by "Andrus Adamchik (JIRA)" <de...@cayenne.apache.org> on 2008/02/23 18:19:48 UTC
[JIRA] Closed: (CAY-809) Support for explicit mapping of SQL
results with SQLResultSetMapping
[ https://issues.apache.org/cayenne/browse/CAY-809?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Andrus Adamchik closed CAY-809.
-------------------------------
Resolution: Fixed
> Support for explicit mapping of SQL results with SQLResultSetMapping
> --------------------------------------------------------------------
>
> Key: CAY-809
> URL: https://issues.apache.org/cayenne/browse/CAY-809
> Project: Cayenne
> Issue Type: New Feature
> Components: Cayenne Core Library
> Affects Versions: 3.0
> Reporter: Andrus Adamchik
> Assignee: Andrus Adamchik
> Fix For: 3.0
>
>
> In Cayenne query results are either Persistent objects or DataRows (maps). In JPA query results are lists of Object or Object[], with Objects that can be scalar values (e.g. Long for COUNT query) or persistent objects. We need a similar functionality in Cayenne.
> JPA has a concept of SqlResultSetMapping that provides a specification for decoding a result row. Support SqlResultSetMapping objects for postconversion of DataRows.
> 1. Support for SQLResultSetMapping in QueryMetadata
> 2. Support for SQLResultSetMapping in ObjectContextQueryAction and DataDomainQueryAction (would take precedence over "dataRows" flag and would result in suppressing any prefetch settings).
> 3. Support for SQLResultSetMapping in SQLTemplate (the only query that would support it directly)
> 4. Support for setting SQLResultSetMapping in EJBQLAction based on parsed EJBQL.
> 5. Update the docs for ObjectContext.performQuery to reflect the new results
> Initial limitations:
> * No support for EntityResultMapping
> * No support for multiple SQLResultSetMapping's per query
> * No support for SQLResultSetMapping in ProcedureQuery.
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.