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.
