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(
> ..serName 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.
This archive was generated by hypermail 2.0.0 : Mon Mar 03 2008 - 08:08:28 EST