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.
This archive was generated by hypermail 2.0.0 : Sat Feb 23 2008 - 12:20:34 EST