[
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.