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 : Fri Jun 22 2007 - 09:05:51 EDT