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

From: Andrus Adamchik (JIRA) ("Andrus)
Date: Fri Jun 22 2007 - 09:05:28 EDT

  • Next message: Andrus Adamchik: "What a query result can be [Was: performing count]"

    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