[ 
https://issues.apache.org/cayenne/browse/CAY-995?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12762#action_12762
 ] 

Kevin Menard commented on CAY-995:
----------------------------------

+1 on the named queries, too.

Taking it a step further, it'd be nice if prefetches and orderings could be 
modeled even for regular relationships.  E.g., I have some relationships that I 
always want returned in a sorted order.  As of now, I have to go well out of my 
way to achieve that.  Control of prefetches over flattened relationships would 
be nice as well.

I suppose these should be separate JIRAs, however.

> Generating stored procedures access code
> ----------------------------------------
>
>                 Key: CAY-995
>                 URL: https://issues.apache.org/cayenne/browse/CAY-995
>             Project: Cayenne
>          Issue Type: New Feature
>          Components: CayenneModeler GUI
>    Affects Versions: 3.0
>            Reporter: Rares Ispas
>            Assignee: Andrus Adamchik
>
> For us the greatest benefit of Cayenne is that it generates Java code which 
> can be verified by the compiler whenever the schema changes. However, that 
> only happens for entity objects. It would be great if it would also work for 
> stored procedures, so that the code that accesses the SP is automatically 
> generated by Cayenne.
> Example:
> create procedure createOrFindUser(
>     @userName varchar(100) )
> returns bigint
> as
> .... code
> should generate a function
> Long createOrFindUser( String userName )
> I think the advantages are obvious and the implementation should be 
> straightforward enough.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to