[jira] Commented: (CAY-995) Generating stored procedures access code

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

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

Andrus Adamchik commented on CAY-995:
-------------------------------------

+1

I was thinking about something like that recently... Same thing for named queries ....

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