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