[JIRA] Created: (CAY-809) Support for explicit mapping of SQL results with SQLResultSetMapping

["Andrus Adamchik (JIRA)" <de...@cayenne.apache.org>]

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.