[
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.
